Start and End Excel files.

[fred3]

I have a large number of Excel files. Each one gathers download data and they all feed a summary worksheet.
There are so many of these files that one cannot open all of them at the same time. I don't know why as the computer has plenty of RAM.
But, running them sequentially would be fine.

The files already have Auto_Open macros that take care of all the necessary operations .. except closing.
I'd prefer to not have the macro also close the file unless it could be conditional. That's so I can open and work on the file if necessary. But maybe I could use CTRL-BRK to stop it before it closes should I need to work on it / them?

Another approach might be to run 5 or 10 of them and then close Excel and start the next batch of 10, etc. But that might make some files different and there is great benefit in having them all the same.
Well, unless closing Excel from outside would be a possibility.

I'm not averse to doing a little programming but I need to know I'm headed in a reasonable direction.

Any suggestions how to do this? I've read a bit about this but the real issue doesn't seem to be solved or at least a solution that's easy to find.

[alansidman]

How about an input box that asks if you would like to close the file. If yes, then close the file, if no then exit sub.

[fred3]

The thing is supposed to run without interaction from start to finish. Now, if the input box entry were YES by default with a wait time associated with it then that would work. But, I'm not well versed in building such a thing.

[mgs73]

I have several spreadsheets that open, run macros and close automatically when run as administrator, but when opened as another user (i.e. me) they open normally. (Or I may put a condition like if it is opened before 7AM then run the macros and close, otherwise open normally). In most cases I do this, the spreadsheets are run as scheduled tasks overnight (before 7AM).

Try something like this in Workbook_Open

Please Login or Register  to view this content.

You'll also need to put this function in a Code Module

Please Login or Register  to view this content.

[fred3]

The Function didn't seem to work for some reason.
I'd like to pursue the time of day approach.

[mgs73]

Oops... I missed something important! Add the first line to your code, and it should then work.

Please Login or Register  to view this content.

Here's a version of the Workbook_Open code I use to run by time.

Please Login or Register  to view this content.