+ Reply to Thread
Results 1 to 3 of 3

Popup to save file as PDF

  1. #1
    Registered User
    Join Date
    04-25-2014
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    69

    Popup to save file as PDF

    Hello,

    I have a macro that saves files as PDFs. However, I also have a blank sheet where I canīt use the formula, so I want it to save as a PDF by asking me for the file name. What would I replace the sFile line with so that the save as box would pop up and allow me to choose my own name?

    Thanks!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Popup to save file as PDF

    Why not bring up a box just before the save, and then use the variable in your save routine? Something like:

    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.

  3. #3
    Registered User
    Join Date
    04-25-2014
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Popup to save file as PDF

    Thanks! I had to change it to sFile, but it works!

+ 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. popup alert message during the worksheet open and continuous work on the sheet popup jump
    By shailkam2001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2014, 10:24 AM
  2. [SOLVED] Problem with File Available For Editing popup..
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-19-2014, 03:10 PM
  3. Replies: 1
    Last Post: 09-05-2013, 02:39 PM
  4. Chosing a file from a popup using VBA
    By mwalshe99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2012, 12:04 PM
  5. Disable Save Workbook popup
    By Scott buckwalter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2005, 11:05 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