Bob,

I have tried the log, but will try your tips to refine. And will try editor debugging as well.

Thanks for the ideas.

Rob

I have a macro that opens a file, saves it as a new format and closes the file. It will run through 5 or 10 files just fine, then it stops. Any tips on debugging? Is there a step-through option? I tried recording the log, but can see nothing of interest. I have hundreds of files to do, so would like...

Dick,

I bet you're right that the path is in the filename string. I'll get rid of it and try it. Thanks again for the help. BTW, macro security is not a problem (actually the way it works in excel IS a problem, just not mine at the moment!).

Thanks!

Rob

Dick, I like the diea, but at least in the following implementation it locks up Excel. // file open dialog box in Excel, filled with file name from list Press ALT Send>fo Release ALT WaitWindowOpen>Open Send>file_names_%k% Wait 0.5 Press ALT Send>o Release ALT Let>openfile=file_names_%k% WaitWindowO...

Problem occurs in macro scheduler before I get to run the macro. Another way to say it is that the macro sometimes fires off too soon--gotta stop macro scheduler from sending the Excel CTRL-w command until the file is loaded.

Hi, The following script loads all files in a folder sequentially and runs an excel macro on the files. Problem is that I don't seem to have control on how long it waits while loading the file. Some files get the CTRL-W command inserted in a random field, while some CTRL-W causes the macro to execut...

I have a macro that works great on a file. Now I would like it to cycle through all files in a folder, open the file, execute existing macro code, close the file, then open the next one.

Any suggestions on where to start?