Windows 10: Can you help me with a Task scheduler - excel macro issue?

I created a script to open a MS Excel spreadsheet at a fixed time 2:05 pm MT each day and run a macro that copies a field representing the current daily closing stock value and paste it into the same worksheet at another location allowing me to keep a history of my stock picks.

The macro works correctly when I execute it from the worksheet by running the macro or using the shortcut cntl-s.

I created a command that Task Scheduler will initiate daily at 2:05 pm. Using .bat and .vbs scripts to open the MS Excel file and run the macro that will copy a field with the latest stock values for a set of stocks that I am tracking and then past those values into the next set of vacant cells that I designate in the spreadsheet.

The result is intended to be a daily running record of end of day stock values. I use 2:05 pm because I am in the mountain time zone.

The problem I am observing is, that when executed by the task scheduler, the data copied into the updated field is the same data as the previous days data and not the current value. This happens only when executed automatically from the Task Scheduler. When I execute that macro from the spreadsheet it records the data correctly.

Following are the details and the excel file. [COLOR=rgba42, 0, 170, 1]Comment: It appears I am unable to include the example excel file with this as an attachment. I am happy to provide it if I'm informed of how to do it. [/COLOR]



I appreciate any help you can provide in debugging what I have done so that it runs properly. Currently I am updating it manually by running the macro shortcut Cntl -s.

Thank you,

Ken

The action in Task Scheduler is "



Following are the scripts that I have created:




"C:\Users\kenmo\Desktop\stockrecorder.vbs"






Using Visual Basic Studio:

Set xlxsApp=CreateObject"Excel.Application"

xlxsApp.Visible=true

Set xlxsworkbook=xlxsApp.Workbooks.Open"E:\My Investments\My Personal Stock Picks with macro1.xlsm"

xlxsApp.RunStockRecorderDaily

MS Microsoft Macro:

Sub StockRecorderDaily
'
' StockRecorderDaily Macro
'
' Keyboard Shortcut: Ctrl+s
'

Range"H3:H7".Select
Selection.Copy
Range"B20".EndxlToRight.Offset0, 1.Select
ActiveSheet.Paste
Range"A1".Select
End Sub

:)

 

Task Scheduler with error message The selected task »CreateChoiceProcessTask« no longer exists

Hi,

Thank you for posting your query on Microsoft Community. Let me assist you.

I suggest you to clear the task from Task Scheduler using the below steps and check if the issue still persists.

Steps:-

• Type Task Scheduler on Search bar.
• Click on Task Scheduler Library.
• Select the particular task and right click on it.
• Select End.

Hope this information is helpful. Please do let us know if you need further assistance, we’ll be glad to assist you.

 

Task Scheduler does not Run task on schedule

When I invoke a task with your command line then the Excel macro does what it is supposed to do, provided that

• I invoke the task under the same account as my current foreground account, and
• I click the radio button to run the task only when the user is logged on.

If either of these conditions is not met then Excel hangs in the background, as can be seen by the console command TaskList.exe.

 

[SOLVED] Schedule Tasks not able to open excel file

I have changed user's workgroup to be administrator, but when I run schedule task under user account, it only open Excel Application and fail to open file. It does not seem to be right issue, would it be correct?

Even through I assign schedule task and run under administrator
account, but it only open Excel Application and fail to open file.

Do you have any suggestions on what wrong it is?

Thank you very much for any suggestions (^v^)