+ Reply to Thread
Results 1 to 13 of 13

open save as dialogue box

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    open save as dialogue box

    hi guys

    i dont know if this is possible but here goes.
    id like a macro button to open the save as dialogue box

    i would like the filename to be generated as cell B2 ( in this case Q01202 ) then "costing sheet" and then cell b4 in this case (smith)
    so it would open the save as dialogue box and already have "Q01202 costing sheet - Smith" in the file name box

    on top of that i would also like the destination folder to be set directly to dropbox rather than desktop or any other folder.

    would appreciate your help

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: open save as dialogue box

    If you already know all the parameters that make up the file name why do you need the dialogue? You simply use the SaveAs function...

    If you need to determine the location of the Dropbox folder then a simple search will get you the code to do that.

  3. #3
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: open save as dialogue box

    i have several folders in dropbox and would still do that manually to ensure it goes in the right place

    the main thing is the filename so i dont have to bother. lazy me

  4. #4
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: open save as dialogue box

    bump bump bump

  5. #5
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: open save as dialogue box

    so i dont have to bother....
    An amazing thing to post in a free forum where you depend on other people 'bothering' to give their time to help you.

    You have all the information you need to compile the file name, what's the problem?

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: open save as dialogue box

    To start with.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  7. #7
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: open save as dialogue box

    cytop with all due respect your attitude is a bit of a problem.
    I would suggest that you have read what i meant in the wrong manner.
    What i was trying to get at was so that i dont have to bother typing in the filename every single time i use the sheet.
    I am more than courteous on here and always give good feedback when help has been given even to those that havent been able to help.
    If you still believe that you didnt read it wrongly then thats your problem this time.
    Life is too short to harbour grudges and hang on something that may well have been misinterpreted so i wish you a good day.

  8. #8
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: open save as dialogue box

    Hi Bakerman

    Thank you that is great and fills the filename in exactly as requested but when i run the macro it doesnt actually save anywhere?
    ive tried the desktop and saving to specific folders but it seems to just disappear into the ether

  9. #9
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: open save as dialogue box

    Yes, I probably do have a problem. But, after wasting time on threads (and sometimes a lot of time) where the OP simply wouldn't do anything for themselves, to see a comment like "so i dont have to bother" is a little like a red rag. As it mentions on the Rules page (but as a general comment only): "Sarcasm is fun but dangerous"

    However, you are right - after 20+ years of freely giving help I've come to the end of my time on forums. This is the last forum I am active in so I wish you well in your future posting career.

  10. #10
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: open save as dialogue box

    Cytop
    i wouldnt know where to start with the code that bakerman put together for me hence why i asked in the forum.
    I appreciate everyone that helps me and that includes you so dont take it to heart.
    Maybe it was the wrong choice of words but i knew what i meant but you didnt.
    Keep helping those less educated than you because we all do really thank you for it.
    come on group hug. there is a lot worse things happening in this world today than a few words being read wrong.

  11. #11
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: open save as dialogue box

    A quick look at the help on GetSaveAsFilename will show you the dialog does not actually save the file but only returns the filename.

    Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.
    so you need a few more lines of code to actual save the file if user provided the information and did not cancel the dialog

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  12. #12
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: open save as dialogue box

    absolutely fantastic
    Thanks you so much Andy

  13. #13
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: open save as dialogue box

    Glad to help and thanks for rep+.

+ 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. VBA to open "Save As" Dialogue box whenever file is opened
    By enwoznick in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-29-2016, 06:23 PM
  2. Save the open sheet in a path with a save as dialogue box and also create two folders
    By Biplab1985 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2015, 05:19 PM
  3. [SOLVED] Macro to open the save as dialogue box
    By Skumby in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-19-2015, 02:58 AM
  4. [SOLVED] VBA - Open Save As dialogue box - to save named range
    By Jabba69 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-10-2014, 10:34 AM
  5. Command button to open Save As dialogue box for new spreadsheet and copy data.
    By valhallaone in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-20-2013, 07:08 PM
  6. VBA/Macro Code needed to open 'Save As' dialogue box and set the file type to CSV
    By daleski in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2013, 12:58 PM
  7. [SOLVED] VBA code to 'click' Open in the Open or Save dialogue box on a webpage?
    By bensox in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-31-2012, 05:40 AM

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