Hi,
I am testing a simple automate workflow that opens an existing Excel spreadsheet, runs a query, puts data in the spreadsheet and closes the spreadsheet. I started getting errors that the spreadsheet was opening in read only mode and couldn't figure out why. I looked at the Task Manager and saw there were multiple excel.exe processes still running. Has anyone else experienced this? Any idea how to fix it? I've attached the code. Thanks for your help! Becki

Category Survey

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
&lt;AMFUNCTION NAME="Main" RETURNTYPE="variable"&gt; &lt;AMVARIABLE NAME="dt_Today_CCYYMMDD"&gt;&lt;/AMVARIABLE&gt; &lt;AMTEXTFORMATDATETIME DATETIMEFORMAT="yyyy-mm-dd" TWELVEHOURFORMAT="NO" RESULTVARIABLE="dt_Today_CCYYMMDD" /&gt; &lt;AMVARIABLE NAME="dt_Yesterday_CCYYMMDD"&gt;&lt;/AMVARIABLE&gt; &lt;AMTEXTFORMATDATETIME DATETIMEFORMAT="yyyyy-mm-dd" TWELVEHOURFORMAT="NO" RESULTVARIABLE="dt_Yesterday_CCYYMMDD" ADJUSTDAY="-1" /&gt; &lt;AMVARIABLE NAME="startTime"&gt;12:00:00&lt;/AMVARIABLE&gt; &lt;AMVARIABLE NAME="endTime"&gt;23:59:59&lt;/AMVARIABLE&gt; &lt;AMVARIABLE NAME="starting_row"&gt;&lt;/AMVARIABLE&gt; &lt;AMVARIABLE NAME="starting_column"&gt;&lt;/AMVARIABLE&gt; &lt;AMEXCELOPENWORKBOOK WORKBOOK="C:\Documents and Settings\it_automate\Desktop\HEAT Daily Ticket Count.xls" SESSION="HEAT_Daily_Ticket_Count" AM_EMAIL="blbloch@stcharleshealthcare.org;blbloch@stcharleshealthcare.org" /&gt; &lt;AMEXCELACTIVATEWORKSHEET SESSION="HEAT_Daily_Ticket_Count" WORKSHEET="Detail Data" AM_EMAIL="blbloch@stcharleshealthcare.org;blbloch@stcharleshealthcare.org" /&gt; &lt;AMWINDOWFOCUS WINDOWTITLE="Microsoft Excel - HEAT Daily Ticket Count.xls" /&gt; &lt;AMSENDKEY&gt;{CTRL}{END}{ENTER}&lt;/AMSENDKEY&gt; &lt;AMEXCELGETACTIVECELL SESSION="HEAT_Daily_Ticket_Count" ACTION="cellbyposition" CELLROWVARIABLE="starting_row" CELLCOLUMNVARIABLE="starting_column" /&gt; &lt;AMEXCELSETCELL SESSION="HEAT_Daily_Ticket_Count" NEWVALUE="%dt_Yesterday_CCYYMMDD%" CELLREF="A%starting_row%" /&gt; &lt;AMSQLQUERY CONNECTIONSTRING="<removed for security>" RESULTDATASET="dsn_DailyTicketCount"&gt;select count(CallLog.CallID) as TicketCount From HEAT.dbo.CallLog Where CallLog.RecvdDate = '%dt_Yesterday_CCYYMMDD%' and CallLog.RecvdTime Between '%startTime%' and '%endTime%'&lt;/AMSQLQUERY&gt; &lt;AMEXCELDATASETTOCELLS SESSION="HEAT_Daily_Ticket_Count" DATASET="dsn_DailyTicketCount" CELLREF="B%starting_row%" /&gt; &lt;AMSQLQUERY CONNECTIONSTRING="<removed for security." RESULTDATASET="dsn_DailyTicketCount"&gt;select count(CallLog.FCR) as closedFirstContact From HEAT.dbo.CallLog Where CallLog.RecvdDate = '%dt_Yesterday_CCYYMMDD%' and CallLog.RecvdTime Between '%startTime%' and '%endTime%' and CallLog.FCR='Yes'&lt;/AMSQLQUERY&gt; &lt;AMEXCELDATASETTOCELLS SESSION="HEAT_Daily_Ticket_Count" DATASET="dsn_DailyTicketCount" CELLREF="C%starting_row%" /&gt; &lt;AMEXCELACTIVATECELL SESSION="HEAT_Daily_Ticket_Count" CELLREF="D%starting_row%" /&gt; &lt;AMSENDKEY&gt;{ALT}{F8}{ENTER}&lt;/AMSENDKEY&gt; &lt;AMEXCELCLOSEWORKBOOK SESSION="HEAT_Daily_Ticket_Count" /&gt;

Hi Becki,

Are you running the task from the Task Builder or the Task Administrator when you are getting the error? You do want to make sure other instances of Excel are closed in most cases. Also, the code you attached does not appear to be the steps from BPA Server 8. Could you please try attaching the code once more?

Category Survey

-------------------------
Liz Casale
Technical Support Representative
(213) 738-6966
Network Automation, Inc.

--------------------------------------------------------------------------------

AM5 5.5.5.1; AM6 6.2.8.0; AM7 7.1.3.0; AM8 8.0.9.0; AM9 9.0.3.4
BPA7 7.1.3.0; BPA8 8.0.9.0; BPA9 9.0.3.4

Hi,
I was running it from Task Builder. Should I put in a step to kill the excel.exe process? I've reattached the code. Hopefully it's in the correct format. I had copied it to Notepad++ before and it brought along all the escape characters. Sorry about that!

Thanks,
Becki

Category Survey

I'm getting an 'access denied' error trying to attach the code, so I'll put it here:






12:00:00
23:59:59






{CTRL}{END}{ENTER}{LEFT}{LEFT}{LEFT}


select count(CallLog.CallID) as TicketCount
From HEAT.dbo.CallLog
Where CallLog.RecvdDate = '%dt_Yesterday_CCYYMMDD%' and CallLog.RecvdTime Between '%startTime%' and '%endTime%'

select count(CallLog.FCR) as closedFirstContact
From HEAT.dbo.CallLog
Where CallLog.RecvdDate = '%dt_Yesterday_CCYYMMDD%' and CallLog.RecvdTime Between '%startTime%' and '%endTime%' and CallLog.FCR='Yes'



{ALT}{F8}{ENTER}


Attached is the HEAT Daily Ticket Count report.

Thanks!

Category Survey

Becki,

Can you please open the SMC, locate this workflow, right click on the workflow and select Export? Save the workflow, .ampkg. Then attach it to this post. This will help us review your steps/WF properties.

Category Survey

-------------------------
Liz Casale
Technical Support Representative
(213) 738-6966
Network Automation, Inc.

--------------------------------------------------------------------------------

AM5 5.5.5.1; AM6 6.2.8.0; AM7 7.1.3.0; AM8 8.0.9.0; AM9 9.0.3.4
BPA7 7.1.3.0; BPA8 8.0.9.0; BPA9 9.0.3.4

Becki, in doing what Liz requests, don't forget to rename the ampkg file to txt, or zip it, since ampkg files are not welcome as attachments on the forum.

Category Survey AutoMate BPA Server 8 version: Windows version:

-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4

Hi,
Sorry for all the confusion. I originally "thought" I had attached it as a .ampkg file, not realizing that would be a problem. I've zipped it and attached that to the post. Thanks much!

Category Survey

Hi Becki,

Thank you for attaching the code. I'm not able to duplicate the 'read only' message. Could we schedule a GoToAssist session to review this on your machine? Please send a list of your availability to support@networkautomation.com and reference this forum post.

Category Survey

-------------------------
Liz Casale
Technical Support Representative
(213) 738-6966
Network Automation, Inc.

--------------------------------------------------------------------------------

AM5 5.5.5.1; AM6 6.2.8.0; AM7 7.1.3.0; AM8 8.0.9.0; AM9 9.0.3.4
BPA7 7.1.3.0; BPA8 8.0.9.0; BPA9 9.0.3.4

Hi Liz,
I tried to duplicate it yesterday afternoon and I couldn't either. Another user was having a similar problem and she couldn't duplicate it either. All of the Automate machines were rebooted yesterday afternoon as part of weekly maintenance, so perhaps that cleared up whatever was going on. I'm comfortable with saying this problem has resolved itself, and if it comes up again, I'll re-open the post. Thanks so much Liz! Have a great day!
~ Becki

Category Survey