Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi gurus
(I know many of you are :-) How do I sav a file on a network server I am not mapped up to? I must provide a username and password. How do I set in username and password for the server into the code??? v_FULLPATH_FILE_NAME =\\servername\driveletter$\folder\subfolder \filename" Application.ScreenUpdating = False Inst.Copy ' name of the sheet With ActiveSheet.Parent Application.DisplayAlerts = False .SaveAs Filename:=v_FULLPATH_FILE_NAME, FileFormat:=xlText .Close SaveChanges:=False Application.DisplayAlerts = True MsgBox "Data saved" End With Application.ScreenUpdating = True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
a Macro to "save as" filename from a cell on the sheet and then pr | Excel Discussion (Misc queries) | |||
"filename is locked for editing by username" | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
is it possible to disable "save" prompt in excel file on web server? | Excel Discussion (Misc queries) | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions |