|
|
|
|
#1
07-15-2014, 12:22 PM
|
|||
|
|||
I tried the code Bob gave me and it works except it goes to my C Drive and I want the path to be another network drive. How do I write that in.
Path = J:\ProgramOps\Exceptions Masters & Data\JPM\ Code:
Sub Saveandget()
FileName = Application.GetSaveAsFilename
MsgBox (FileName)
ThisWorkbook.saveas (FileName)
Sheets("UPDATE").Select
ActiveWindow.SelectedSheets.Delete
End Sub
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro to save as pdf with ability to choose save as folder
|
rvessio | Word VBA | 4 | 07-25-2016 12:37 PM |
|
Outlook 2010 Macro Save as MSG, Choose Destination, set default filename
|
rslck | Outlook | 1 | 06-19-2014 10:16 AM |
|
Save As Macro that changes the file name also
|
rosscortb | Word VBA | 5 | 05-19-2014 08:40 AM |
| How do I save a Word file with a macro for distribution? | leemoreau | Word VBA | 3 | 10-04-2013 08:06 AM |
|
Word Macro: Save file as text with current file name
|
jabberwocky12 | Word VBA | 2 | 10-22-2010 12:23 PM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode