View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve_doc steve_doc is offline
external usenet poster
 
Posts: 140
Default Save problem with location

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