+ Reply to Thread
Results 1 to 3 of 3

Save as box to open in file path & name located in specific cells

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    London England
    MS-Off Ver
    Office 365
    Posts
    69

    Save as box to open in file path & name located in specific cells

    I would like help to produce a macro that will open a SAVE as box in the file location located in CELL AX5 and the suggested filename as what is populated within CELL AQ5

    The reason I would like it to be a save as box is that I would like the user to have the option to rename the file.

    Thanks in advance

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,517

    Re: Save as box to open in file path & name located in specific cells

    Assuming [ax5] has path separator at the end, e.g. c\:abc\xyz\
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-07-2014
    Location
    London England
    MS-Off Ver
    Office 365
    Posts
    69

    Re: Save as box to open in file path & name located in specific cells

    Superstar! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Save As to a specific file path...
    By 7hc784hdi in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-07-2017, 07:36 PM
  2. [SOLVED] Save sheet as PDF with specific file path
    By KEDENNIS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2016, 07:32 PM
  3. [SOLVED] vba to save document to specific file path
    By shaz0503 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-19-2014, 08:16 PM
  4. Automatically open a file in a specific file path when another sheet is opened
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2014, 11:05 AM
  5. Trying to Open Files Not Located in Specified Path
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2013, 12:40 AM
  6. Save file with specific name and ask user for the path
    By kammariarun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2013, 05:19 PM
  7. Open WB located in an unknown path - VBA
    By ElmerS in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 06-22-2009, 04:01 PM

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