hi,
the save command saves the document to the last known place that it was
saved. to save it to another location, you will need to add a second "save
as" command. it would be recomended to use the save as command to save the
document to the network drive then save as again to your c drive.
my documents is on your c drive. desktop is just an icon shortcut to your c
drive.

regards
FSt1

"steve_doc" wrote:

Hi all

In testing my latest Excel project I have encountered the following problem.
Please could someone shed some light on this?

In my project I use wb.Save to save the data and not rely on the user to
save it.
This works fine if using the application locally ie. My Documents or Desktop.

When the application is stored on a network, wb.Save creates a version of
the workbook in My Documents (which has updated info in it).

Would I need to explore wb.SaveAs to save to a network drive or is there
another way around this??

Thanks in advance for any answers
Steve