+ Reply to Thread
Results 1 to 5 of 5

File - Save as...

  1. 01-17-2017, 04:34 PM #1
    drgkt
    drgkt is offline
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    File - Save as...

    Hi
    What is the code for File - Save as ...

    that will bring up the dialog box...
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 01-17-2017, 04:37 PM #2
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: File - Save as...

    Give this a try:

    Please Login or Register  to view this content.
    this should work too:

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  3. 01-17-2017, 07:19 PM #3
    drgkt
    drgkt is offline
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    Re: File - Save as...

    Both work.
    Thank you!
    Reply With QuoteRegister To Reply
  4. 01-18-2017, 02:58 AM #4
    drgkt
    drgkt is offline
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    Re: File - Save as...

    If I was to include this in the end of an existing macro, is the placement right?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 01-18-2017, 10:22 AM #5
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: File - Save as...

    Seems like a perfectly reasonable place to put it yes.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. file save as tab delimited change to direct file save
    By bkanealy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-13-2016, 02:15 PM
  2. save as which remains the master file and save new file
    By ash3angel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-16-2015, 04:13 AM
  3. Macro needed to open "File Save As" and change save file type
    By blainerhett in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2014, 02:40 PM
  4. Macro to Save As a Copy of the File, Save the Original File, & Overwrite Previous Versions
    By jtal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2013, 02:39 PM
  5. Save as macro that specifies file type, file location and takes file name from three cells
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-13-2013, 10:09 PM
  6. How to: Open file, format data, save file, close file and repeat.
    By thexeber in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-11-2010, 12:56 PM
  7. Excell2003 (SP-1) File > Save and File > Save As.. grayed out
    By Joe Murphy in forum Excel General
    Replies: 0
    Last Post: 03-09-2005, 06:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1