Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to specify save PATH in macro?
Hi, heres the code i have so far, I have tried many different methods to
specify a save path, but the dialog box keeps defaulting to "c:\my Documents". Any help would greatly be appreciated. ************* Sub CustomSaveAs() Dim res As Variant, sName As String With Worksheets("SA009_Prepsheet") sName = .Range("G4").Text & " - " & .Range("C13").Text End With res = Application.GetSaveAsFilename(InitialFileName:=sNa me, fileFilter:="Excel Workbook Files (*.xls), *.xls") If res = False Then Exit Sub ActiveWorkbook.SaveAs Filename:=res End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to specify save PATH in macro?
First this
Dim MyPath As String Dim SaveDriveDir As String SaveDriveDir = CurDir MyPath = "C:\Data\" ChDrive MyPath ChDir MyPath Then you code Then set it back ChDrive SaveDriveDir ChDir SaveDriveDir -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ch33baman2" wrote in message ... Hi, heres the code i have so far, I have tried many different methods to specify a save path, but the dialog box keeps defaulting to "c:\my Documents". Any help would greatly be appreciated. ************* Sub CustomSaveAs() Dim res As Variant, sName As String With Worksheets("SA009_Prepsheet") sName = .Range("G4").Text & " - " & .Range("C13").Text End With res = Application.GetSaveAsFilename(InitialFileName:=sNa me, fileFilter:="Excel Workbook Files (*.xls), *.xls") If res = False Then Exit Sub ActiveWorkbook.SaveAs Filename:=res End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to specify save PATH in macro?
Thanks Ron. All i really needed was ChDir "c:\savedir", but i never inserted
it near enough to the top of the script, and therfore i never worked. I inserted as the first line & bingo. Thanks tons. "Ron de Bruin" wrote: First this Dim MyPath As String Dim SaveDriveDir As String SaveDriveDir = CurDir MyPath = "C:\Data\" ChDrive MyPath ChDir MyPath Then you code Then set it back ChDrive SaveDriveDir ChDir SaveDriveDir -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ch33baman2" wrote in message ... Hi, heres the code i have so far, I have tried many different methods to specify a save path, but the dialog box keeps defaulting to "c:\my Documents". Any help would greatly be appreciated. ************* Sub CustomSaveAs() Dim res As Variant, sName As String With Worksheets("SA009_Prepsheet") sName = .Range("G4").Text & " - " & .Range("C13").Text End With res = Application.GetSaveAsFilename(InitialFileName:=sNa me, fileFilter:="Excel Workbook Files (*.xls), *.xls") If res = False Then Exit Sub ActiveWorkbook.SaveAs Filename:=res End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to create a path and save a workbook in it | Excel Discussion (Misc queries) | |||
Save as cell with path | Excel Programming | |||
Macro to create "path" for save | Excel Discussion (Misc queries) | |||
Want to Set the File Save As path | Excel Programming | |||
save as path | Excel Discussion (Misc queries) |