+ Reply to Thread
Results 1 to 4 of 4

Macro to save file as PDF

  1. 07-22-2021, 10:57 AM #1
    cyee
    cyee is offline
    Forum Contributor
    Join Date
    09-02-2010
    Location
    singapore
    MS-Off Ver
    MS365
    Posts
    287

    Macro to save file as PDF

    Hi All,

    I got following code from one of the expert here.
    However, i would like to modify it to save as PDF i/o xlOpenXMLWorkbook.
    How can i modify the save as portion?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 07-22-2021, 03:43 PM #2
    ranman256
    ranman256 is offline
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,192

    Re: Macro to save file as PDF 

    Please Login or Register  to view this content.
    Last edited by davesexcel; 07-27-2021 at 02:55 PM.
    Reply With QuoteRegister To Reply
  3. 07-22-2021, 04:00 PM #3
    Vraag en antwoord
    Vraag en antwoord is offline
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Macro to save file as PDF

    Could be a bit simpler depending on what you want

    Please Login or Register  to view this content.
    Messages have been translated from Dutch to English by means of google translate.
    Reply With QuoteRegister To Reply
  4. 07-22-2021, 09:48 PM #4
    cyee
    cyee is offline
    Forum Contributor
    Join Date
    09-02-2010
    Location
    singapore
    MS-Off Ver
    MS365
    Posts
    287

    Re: Macro to save file as PDF

    Thank you very much. It works perfectly now.
    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. 1 macro to Save as w file name + progressive number & another save as for next data entry
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-08-2019, 06:38 PM
  2. [SOLVED] Macro to save file by employee and save as PDF in path
    By jw01 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-18-2017, 11:39 AM
  3. [SOLVED] Need to loop a macro to save images to file - but save to user defined directory.
    By superfurry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2015, 07:49 AM
  4. Macro to Auto save a backup copy in a seperate location OR save file with a pop up
    By kdsanderson30 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2014, 12:38 PM
  5. 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
  6. 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
  7. 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

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