Can't reopen macro-generated file

  • Thread starter Thread starter Ion Chalmers Freeman
  • Start date Start date
I

Ion Chalmers Freeman

Hi!
I wrote a macro in Excel 2000. It conspires with querytables and
what not to pull some data out of access, do a little processing,
attach data to plots, copy pages, what have you.
It then saves the file with a generated name, and leaves the file
open.
I can not open the file if I close it.
(1) If I close and try to reopen it, Excel crashes after the 'enable
macros' and 'open as read only' questions, regardless of the answer.
(2) If I save it with a new name, and close and try to reopen that,
Excel crashes after the 'enable macros' question (as it is no longer
read-only recommended.)
(3) If I leave it open, and copy it to my windows & office XP
computer, Excel XP crashes at the time as per (1).
(4) Excel can recover it, but it discards the plots, which is bad.
(5) If I open it with OpenOffice and save it, it works great. So, I
have a cumbersome workaround.
What's going on here? How do I diagnose this problem? More to the
point, how do I correct it?
Thanks!
ion
 
This was due to my use of QueryTables. I did the data access
programmatically using ADO in VBA, and it worked great. Just goes to
show, the GUIs don't work for some people.
ion
 
Back
Top