Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a workbook to a specific directory
Hello,
Could someone please help amend my macro code so that when it is run, the SaveAs window pops up and automatically selects the desired directory location in my macro? Sub Save_to_Dir() ' 'Save to Dir ' Dim MyPath As String Application.ScreenUpdating = False MyPath = "G:\WLMAEWCSPO\LMU\LOGISTICS PREPAREDNESS SYSTEMS\LOGISTICS SYSTEMS\LOGSYS3\LOCAL PURCHASE\ON-LINE DEMAND REQUESTS\" MyPath = Application.GetSaveAsFilename End Sub Any help would be greatly appreciated. Kind regards, Chris. *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving xls in specific directory | Excel Programming | |||
Saving file to specific directory | Excel Programming | |||
Saving into new directory | Excel Discussion (Misc queries) | |||
Saving to same directory | Excel Programming | |||
Saving one specific worksheet in a workbook | Excel Programming |