Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All...........
This code basically works, but saves to the "Excel default" directory rather than to the directory the file came from......I want both saves to go right back in to the same directory the file came from.......wherever that might be. How can I force this please? Sub NewSaveArchive() CurrentPath = CurDir archivepath = CurrentPath + "\" 'Default Directory WorkBookName = ActiveWorkbook.Name Fname = archivepath Fname = Fname + Worksheets("INFO").Range("AH8").Value Fname = Fname & Format(Time, "_hh_mm_ss") & Format(Date, "_Mmm_dd_yyyy") Sheets("StaffingMatrixGF").Select Range("a1").Select Application.DisplayAlerts = False ActiveWorkbook.SaveAs Fname Fname = CurrentPath + "\" + WorkBookName ActiveWorkbook.SaveAs Fname Application.DisplayAlerts = True End Sub Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change current directory to the directory that the workbook loads from! | Excel Programming | |||
Force use of the Default Directory | Excel Programming | |||
How do I force an Excel macro to ask me which file and directory? | Excel Discussion (Misc queries) | |||
How to force current directory | Excel Programming | |||
changing current directory to that of the current open file | Excel Programming |