Schedule Macros problem

[dainova]

Hi, all

I was looking how to schedule Macros and find this handy thread:
http://www.mrexcel.com/forum/excel-q...pen-excel.html
(Task scheduler + VB script to auto open excel)

I tried to do exactly same on 2007, and 2010 and failed, tried all version posted in there,
but have this error:
C:\xxx\myScript.vbs(9, 1) Microsoft Office Excel: Cannot run the macro 'AddTimeInColumn'.
The macro may not be available in this workbook or all macros may be disabled.



I found that when this vbs open book1.xlsx it doesn't bring personal.xlsb or there is some other reason, I don't have AddTimeInColumn in my macros menu, but it's in module of personal.xlsb,(not workbook though) probably because of <Private> or using parameter??

can anybody make it run or point why mine is not working?
I'm W7, tried office 2007, and 2010, ran thru all troubleshooting as checking Disable list, Enable Macros, Enable vbs script, tried xlsx and just .xls.

Thanks
Mario

[judgeh59]

you can also set the main macro in your excel file to Auto_Open and then launch the excel file from the scheduler....you could just copy the macro from your personal.xlsb area to the new project and that should find the macro....also, if you set the main macro to Auto_Open and you need to troubleshoot the file you have to hit <Ctrl-Break> to get to the VBA Project....HTH....

Edit....if you are running in 2007/2010 you might want to save the file as an .XLSM