LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I save Excel subtotals without saving hidden (Level 3) r Judy Stumpf Excel Worksheet Functions 0 February 13th 07 03:55 PM
Closing files and saving files dan Excel Worksheet Functions 0 August 15th 06 04:07 AM
Using macro to convert single level BOM to Multi Level BOM andrew_chong Excel Programming 0 February 7th 06 08:57 PM
moving .xla files and top level tech information blakieto Excel Programming 1 June 17th 04 04:02 AM
Why, when I create workbook-level name does it jump it to Sheet-level ? Charles Jordan Excel Programming 1 November 5th 03 08:43 PM


All times are GMT +1. The time now is 01:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"