Ok I know this has been sort of covered but none of the other threads answered my quesitons. Thank you in advance for reading this questions, it is kind of long.
I have a macro that I need to run daily when no one is logged on to the workstation (Windows 2000/Windows NT both OS's). I use the Scheduler tool in "My Computer" to open an Excel workbook by running the .xls file. This automatically opens the workbook. I use the auto_open sub to run the macro on open. The macro then opens another file, formats the text in the spreadsheet, transfers some data to the original workbook, closes the second file with out saving, saves the orginal file, final closing the Excel app with Application.Quit.
Now the macro runs fine if I schedule it to run when I am logged on to my Workstation. It opens the file does it's thing and closes the App. The problem is when I tried to run it off line. The task begins, but when I log back on to check if it worked the task is still running. If I was to try and open the file (with out killing the task) I get a message that I am accessing it and would I like to open it read-only. When I kill the app then I can then open the file.
I tried to same thing using a simpler macro (just put "1234" in the first cell) and it opens the file, adds the data, savs it but the task was still running when I logged in.
Does anyone know if what I am trying with the more advanced macro is possible, if so what can I do to make it work. Thank you again for read this long explaination and thanks for any help you can give.
I have a macro that I need to run daily when no one is logged on to the workstation (Windows 2000/Windows NT both OS's). I use the Scheduler tool in "My Computer" to open an Excel workbook by running the .xls file. This automatically opens the workbook. I use the auto_open sub to run the macro on open. The macro then opens another file, formats the text in the spreadsheet, transfers some data to the original workbook, closes the second file with out saving, saves the orginal file, final closing the Excel app with Application.Quit.
Now the macro runs fine if I schedule it to run when I am logged on to my Workstation. It opens the file does it's thing and closes the App. The problem is when I tried to run it off line. The task begins, but when I log back on to check if it worked the task is still running. If I was to try and open the file (with out killing the task) I get a message that I am accessing it and would I like to open it read-only. When I kill the app then I can then open the file.
I tried to same thing using a simpler macro (just put "1234" in the first cell) and it opens the file, adds the data, savs it but the task was still running when I logged in.
Does anyone know if what I am trying with the more advanced macro is possible, if so what can I do to make it work. Thank you again for read this long explaination and thanks for any help you can give.