Hi Catherine,
I have a problem when I use the "Save As" Method of the MS Excel Application
object from within Visual Basic. All operations of opening, manipulation of
cells etc work. When I use the Save As method to save it into another file,
the program crashes .
This may be related to a known bug in Excel 2000 regarding the save-as method
and userforms loaded in memory:
http://support.microsoft.com/default...&Product=xlw2K
Regards,
Jan Karel Pieterse
Excel MVP
www.jkp-ads.com