Opening and Closing workbooks

J

Jase

Hi All

I currently have a problem with a program I have (well
that's why we write here now)

What happens is one workbook opens another workbook and
then the original workbook is closed. However when I do
this because the code originated in the original workbook
as soon as it is closed I get an object-defined error.
That is to say the code can not continue to execute as I
have removed the root macro that is running the operation.

Does anyone know how to get around this?

Thanks in advance
Jase
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top