+ Reply to Thread
Results 1 to 2 of 2

SaveAs in macro, add path

  1. #1
    Registered User
    Join Date
    02-02-2012
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2011
    Posts
    16

    SaveAs in macro, add path

    I use a macro to SaveAs after Ive done a lot to the workbook. I want to save it to another location using the path to that location, How?
    Here is a sample of what I'm using now to save the file. It puts it where the original was.
    Please Login or Register  to view this content.
    My desired path is like
    Users/geneo/Documents/Patterns/RadPatData/RawData/
    and the file name is Bookname

  2. #2
    Valued Forum Contributor smuzoen's Avatar
    Join Date
    10-28-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    610

    Re: SaveAs in macro, add path

    Try - will check to see directory exists
    Please Login or Register  to view this content.
    Last edited by smuzoen; 02-08-2012 at 09:15 PM.
    Hope this helps.
    Anthony
    Pack my box with five dozen liquor jugs
    PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1