Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I use the following lines to save data to a file: ActiveWorkbook.SaveAs FileName:=NewFileName, _ FileFormat:=xlText, _ CreateBackup:=False It stores the file in the same directory as the input file that I have pointed out with the lines: WholeFileName = Application.GetOpenFilename _ (FileFilter:=Filt, _ FilterIndex:=FilterIndex, _ Title:=Title) My question is how I can store the file one level up, in the directory above? Can I type in the file name with path and everything as NewFileName? Best regards, /Sören |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I save Excel subtotals without saving hidden (Level 3) r | Excel Worksheet Functions | |||
Closing files and saving files | Excel Worksheet Functions | |||
Using macro to convert single level BOM to Multi Level BOM | Excel Programming | |||
moving .xla files and top level tech information | Excel Programming | |||
Why, when I create workbook-level name does it jump it to Sheet-level ? | Excel Programming |