Hey-now
I have a macro that I do some stuff to a file that the macro opens. Then I do save as. Then close the workbook that I just manipulated and saved. Then it goes and does stuff to other files.
That works when I run it all from the same instance of excel.
But I need to run the file remotely so I can do the work then close the file and reopen it.
I got that part worked out too. The problem is that when running the macro remotely it runs fine till it saves the file and then has to close it. My remote instance of Excel crashes.
If I comment out the close line everything works well.
My question is how should I be closing the files so I dont crash my remote instance of excel?
Below is the Code: I am starting Excel with, opening the workbook with the macro that I want to run.
Any help is appreciated
Bookmarks