Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving files one level up
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving files one level up
Dim myPath as string
dim wkbk as workbook dim WholeFileName as variant '... WholeFileName = Application.GetOpenFilename _ (FileFilter:=Filt, _ FilterIndex:=FilterIndex, _ Title:=Title) if wholefilename = false then exit sub end if set wkbk = workbooks.open(filename:=wholefilename) mypath = wkbk.path newfilename = mypath & "\..\" & "whateverstring.txt" ======= If you remember your old DOS commands, this is equivalent to: cd .. to go up one level. (You may want to add a check to make sure you weren't in the root folder of the drive--so you couldn't go up a level.) Sören_Marodören wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |