+ Reply to Thread
Results 1 to 2 of 2

Need to help adjusting VBA code to print/PDF sheets individually

  1. #1
    Forum Contributor
    Join Date
    02-18-2020
    Location
    Ottawa, ON
    MS-Off Ver
    Professional Plus 2010
    Posts
    139

    Lightbulb Need to help adjusting VBA code to print/PDF sheets individually

    Hi All,

    I recently got some help on here to add some VBA code to my workbook. The VBA code converts my workbook sheets to a single PDF file and then sends them to me in an email (or at least prepares the email for me to send). What I want to fix is, instead of the entire workbook showing up on one single PDF sheet, I want each sheet in my workbook to be converted to it's own individual PDF file, and then to have all of those PDF files to be emailed to me. Is this possible to do? Here is the code that someone on here wrote for me:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert ByteMarks's Avatar
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    3,119

    Re: Need to help adjusting VBA code to print/PDF sheets individually

    Does this work for you?

    Please Login or Register  to view this content.
    Last edited by ByteMarks; 04-17-2024 at 10:22 AM.

+ 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. Replies: 2
    Last Post: 03-28-2024, 12:19 AM
  2. [SOLVED] Multiple Sheets (457 sheets) that must be transferred individually in a closed workbook
    By Jarvin24 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-31-2023, 01:14 AM
  3. [SOLVED] adjusting code merge & summing values across sheets for two columns instead of one column
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-12-2022, 05:45 AM
  4. adjusting code search in multiple sheets using by inputbox
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2020, 02:17 AM
  5. [SOLVED] Create sheets and export them individually as CSV
    By chiidzzz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-01-2017, 09:11 AM
  6. Replies: 1
    Last Post: 09-24-2016, 08:05 AM
  7. Numbering sheets individually
    By Xander Crews in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 03-24-2016, 04:43 PM

Tags for this Thread

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