+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Excel Help please in Technical; Is there a way to automate saving multiple sheets as individual PDF files? I have a document which is around ...
  1. #1

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    12,310
    Thank Post
    1,673
    Thanked 2,023 Times in 1,470 Posts
    Blog Entries
    2
    Rep Power
    457

    Excel Help please

    Is there a way to automate saving multiple sheets as individual PDF files?

    I have a document which is around 16-20 sheets (depending on which month it is), and naming the PDF file the same as the sheet it is saving. It is a hassle saving each sheet every month, and was wondering if there was a way I can expedite the process.

    No downloadable programs, just a plain VBS script should do the job nicely.

  2. #2

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    12,310
    Thank Post
    1,673
    Thanked 2,023 Times in 1,470 Posts
    Blog Entries
    2
    Rep Power
    457
    IF anyone was looking at sorting this, I resolved it.

    Code:
    Sub PDF_IndividualSheets()
    Dim page As Worksheet
    Dim title As String
    Dim location As String
    
    location = "C:\"
        
        For Each page In Worksheets
            title = page.Name
            
            ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=location & title _
                , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
                :=False, OpenAfterPublish:=False
                
        Next
    End Sub
    (Change the location as needed)

  3. Thanks to nephilim from:

    mac_shinobi (15th August 2014)

  4. #3

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,946
    Thank Post
    3,479
    Thanked 1,095 Times in 1,008 Posts
    Rep Power
    372
    Handy to know - thanks for that



SHARE:
+ Post New Thread

Similar Threads

  1. Excel help please?
    By reggiep in forum General Chat
    Replies: 9
    Last Post: 1st June 2012, 01:33 PM
  2. Excel custom function help please!
    By stupidusagi in forum Office Software
    Replies: 12
    Last Post: 2nd October 2011, 06:42 PM
  3. [MS Office - 2003] Excel expert required - Help please
    By elsiegee40 in forum Office Software
    Replies: 14
    Last Post: 17th May 2010, 09:23 AM
  4. Web page in open office or Excel help please.
    By MrWestwood in forum Office Software
    Replies: 0
    Last Post: 1st May 2009, 12:34 PM
  5. more excel help needed please
    By RabbieBurns in forum Office Software
    Replies: 10
    Last Post: 7th September 2008, 12:53 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •