help!!

[Catherine Jones]

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 .
The problem is complicated because we do not get the message from the IDE or
when we step through. We do not get the message with the executable on
certain machines. Unfortunately it is happening on all machines at our
customer end. am using Visual Basic 6.0 with MS Excel Libraray 8.0 for the
development. The customer is using MS Office 2000.

Can somebody help me on this. This is urgent.

 

[Dave Peterson]

First thing I'd do is to find out what the cause of the crash is. Do the users
all have write capability to the location you want to save?

Does that location actually exist for your customer? Are you pointing to a
mapped drive that hasn't been mapped by some users?