+ Reply to Thread
Results 1 to 3 of 3

Macro to open "save as"

  1. 12-02-2015, 05:43 PM #1
    horsefish01
    horsefish01 is offline
    Forum Contributor
    Join Date
    05-20-2015
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    307

    Macro to open "save as"

    Anyone have a macro that Will open "save as" on activeworksheet and make me save sheet as csv.

    So All i need is to choose destination
    Reply With QuoteRegister To Reply
  2. 12-02-2015, 07:08 PM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to open "save as"

    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 12-03-2015, 03:17 AM #3
    Alf
    Alf is offline
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Macro to open "save as"

    You could try this macro and see if that works for you.

    Please Login or Register  to view this content.
    Alf
    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. VBA to Automate the a click on the "Open,Save,Save As" Windows Internet Explorer Dialog
    By rs311 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2014, 08:53 AM
  2. 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
  3. Need macro to disable "Save" and "Save as" buttons
    By Anforya in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-20-2013, 01:06 PM
  4. macro to open click "Save as" in intrnet explorer pop up
    By crobledo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2013, 11:06 AM
  5. [SOLVED] Macro to get worksheets to save to new workbook with OPEN workbooks .PATH & " " as name.
    By NicksDad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2012, 08:07 PM
  6. Open "Save As" dialogue with "xls" as the default
    By whatsthatbeeping in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 01-18-2011, 11:19 AM
  7. [SOLVED] Possible to change default "All Open Workbooks" to "This Workbook" in macro dialogue box?
    By StargateFanFromWork in forum Excel General
    Replies: 0
    Last Post: 01-04-2006, 06:55 PM
  8. [SOLVED] set up a command button or macro for open file to "save as"
    By Mo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2005, 07:19 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