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

Save problem with location
 

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

Save problem with location
 

Thanks for the reply

2nd question
Is it possible to specify the Save as location and the file overwrite
function from VBA, and if so how?



"FSt1" wrote:

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

Save problem with location
 

Using

application.displayalerts = False

before the save command will prevent the pop-up asking for
confirmation... don't forget to turn it back on afterwards!


--
pianoman
------------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...o&userid=33712
View this thread: http://www.excelforum.com/showthread...hreadid=548366

Save problem with location
 

Workbook.SaveCopyAs(fileName) solved the problem for me.