View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sören_Marodören Sören_Marodören is offline
external usenet poster
 
Posts: 18
Default 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