-
1
- #1
Hi all
This may hopefully be useful to someone as I have just had to deal with it.
When using ActiveWorkbook.SaveAs in XL2000 it was crashing my VB app and the error handler did not capture it either. It worked fine in XL2003. There was not already a file with the same name (as the file name is unique everytime - I check anyway and delete it in case
).
Anyway, I used ActiveWorkbook.SaveCopyAs and hey presto it worked in both XL2000 and XL2003.
Good luck!
Rob
This may hopefully be useful to someone as I have just had to deal with it.
When using ActiveWorkbook.SaveAs in XL2000 it was crashing my VB app and the error handler did not capture it either. It worked fine in XL2003. There was not already a file with the same name (as the file name is unique everytime - I check anyway and delete it in case
).Anyway, I used ActiveWorkbook.SaveCopyAs and hey presto it worked in both XL2000 and XL2003.
Good luck!
Rob
