Excel timed automation..

[Tortus]

Hello,
Ok, here it goes..
Every morning I run a batch file that moves .txt files from one system to another.
Once the .txt files are moved, they are sorted within excel VIA. marco’s.
Is there a way to kick these macro’s off within the excel sheets without having to open them? I have no idea and I could be just dreaming here, but it sure would be nice. One thing I encounter while running these macros is a pop-up message asking if I want to update other sheets that are linked.
So am I dreaming or could this be possible?
If it is possible to run the macros automatically, then I can work on the automation of the batch file.

[Leith Ross]

Hello Tortus,

The macros can only run if the workbook they are in is open. It is a security measure. You can however turn the messages off asking to update the links.

Turning Off Update Link Messages
1. With the workbook open, Click on Edit > Links... on the main menu bar.
2. A dialog titled Edit Links will be displayed.
3. In the bottom left corner click the button Startup Prompt...
4. Choose the bottom option button labeled Don't display the alert and updates the links

Sincerely, Leith Ross

[mudraker]

Macro's cannot run unless the workbook they are in is open


Can you have your batch file open Excel & a specific workbookwhen it has finished moving the files around

The opened workbook could contain a Workbook_Open macro that will run everytime the book is opened.


Another option is to have a master macro that moves the files & then opens the other books to run the macro's as required

[Tortus]

Well, I have to log in to a separate system to run the batch file. For security network security reasons, I can’t place the excel workbooks on that system. I might be able to give the batch file a path to another drive that is a VPN link between the two systems and in that path I could maybe have a simple marco to Chdir and open the other workbooks. Wow... that’s confusing, but that helped me somewhat. If I can get this to work, I'll repost. Thanks!