| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a path to save a file
I am trying to save a file to a users file on a server I can't get the path
right Dim username As String username = Application.username NUMBERSAVE = Range("AB2") If Application.username = "jauld" Then QUOTENUMBER1 = InputBox("Please enter QUOTE file name to save to Server3", "The Company", "\\server3\jobs\ username\" & NUMBERSAVE) QUOTE = QUOTENUMBER1 & ".XLS" ActiveWorkbook.SaveAs Filename:=QUOTE How do a specify the correct path? oldjay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel - save file - specify path and name | Excel Programming | |||
| Want to Set the File Save As path | Excel Programming | |||
| file save as (path and custom name) | Excel Programming | |||
| get path - save new file - same sub-directory as existing file | Excel Programming | |||
| Save file path in cell | Excel Programming | |||
Threaded Mode
