+ Reply to Thread
Results 1 to 4 of 4

Publish Excel Page as PDF with Filter

  1. #1
    Forum Contributor
    Join Date
    09-12-2015
    Location
    Okinawa, Japan
    MS-Off Ver
    2013
    Posts
    178

    Publish Excel Page as PDF with Filter

    I have this bit of code I use to publish Excel pages to a PDF and then it is attached to an email. It works great except it captures everything on the target Excel page to include fields with a value of 0 which I would like for it to filter out. Not sure if this is even possible. Here is the code for the PDF:

    Please Login or Register  to view this content.
    I have another section of code that PRINTS the target Excel sheets, but has a filter to eliminate the fields with 0. It looks like this:
    Please Login or Register  to view this content.
    Is it possible to publish the target Excel pages to a PDF with the filter in place?
    Your help and expertise is appreciated.

    Ken

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Publish Excel Page as PDF with Filter

    When a page is setup like you want it (Filter, Print Area, etc etc) it will be exported as PDF in that way.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    09-12-2015
    Location
    Okinawa, Japan
    MS-Off Ver
    2013
    Posts
    178

    Re: Publish Excel Page as PDF with Filter

    Thank you Keebellah for the reply. As this generates usually about 20 different PDF files, I was looking for it to be somewhat automated across all pages in lieu of going to each page and filtering prior to generating the PDF.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Publish Excel Page as PDF with Filter

    Well you write a macro to do this

+ 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. Publish as web page
    By htmeltel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2017, 10:58 AM
  2. Replies: 0
    Last Post: 09-04-2014, 11:03 PM
  3. publish summary sheet of excel in existing html page
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2014, 01:04 AM
  4. Publish - Page Setup
    By Jon_Sarge in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2008, 11:04 PM
  5. How to publish an Excel worksheet as a Web page including heading
    By captainbr in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-11-2006, 12:35 PM
  6. Web Page Publish Area
    By lmf232s in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2005, 06:09 PM
  7. [SOLVED] Difference between Publish and Save As Web Page in Excel 2002
    By johng36 in forum Excel General
    Replies: 2
    Last Post: 02-04-2005, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1