Dustin,

I tried both of those suggestions and they didn't work? Any more ideas? Is
there any other information I can provide you with to narrow down the problem?

Thanks

Adam Bush

"dustinbrearton via OfficeKB.com" wrote:

If you also put a call to your Sub that you want to run in the Workbook_Open
sub it should continue on with the code. Try adding an error handler to the
code and see if that doesn't help.

On Error Resume Next

wrote:
I'm trying to use workbook.open to open another file and then I want this
other file to automatically run a macro. This other macro starts by closing
out the original file and then running a bunch of other code. I tried using
a Workbook_Open sub but as soon as the code closes the original file it just
stops running. I've tried everything I can think of but I cannot come up
with a solution. I need to open a specified file, then use this file to
close the original and run other code. Any ideas?

Thanks

Adam Bush

--
Message posted via http://www.officekb.com