Workbook.Open doesn't leave an open Workbook
What happens when you step through the code (F8's)?
And if you look at the VBE, do you see the project for that workbook?
And you did check under window|unhide to make sure it wasn't hidden?
If you copy the significant portion of that code to a new workbook and run it
there, does it work?
How do you run this macro? Is it just alt-f8 and point and click or what?
Mac Lingo wrote:
Thanks, Dave, for the response.
But the end result of the process is that the Workbook has not been opened
from the code that is not in the Workbook_Open call.
--
Dave Peterson
|