+ Reply to Thread
Results 1 to 2 of 2

Save sheet to PDF without using print spooler

  1. #1
    Registered User
    Join Date
    07-21-2021
    Location
    Florida
    MS-Off Ver
    Win 10
    Posts
    1

    Save sheet to PDF without using print spooler

    Hi,
    I need some help with saving a sheet to PDF. Due to Microsoft Vulnerability Advisory the print spooler on Windows Server2012 will be disabled.
    So I can't run below code. I looked and googled but could not find a alternative to the below. Thank you for helping.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,192

    Re: Save sheet to PDF without using print spooler

    oWS.ExportAsFixedFormat _
    Type:=xlTypePDF, _
    FileName:= "c:\folder\sc.pdf", _
    Quality:=xlQualityStandard, _
    IncludeDocProperties:=True, _
    IgnorePrintAreas:=False, _
    OpenAfterPublish:=False

+ 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. VBA to save sheet as print area
    By chris1888 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-25-2020, 06:52 AM
  2. Save As / Print PDF using sheet name as file name
    By wine gums in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-30-2020, 11:58 AM
  3. Print each sheet to PDF Printer NOT Using Save as PDF Function
    By esposit513 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2018, 05:23 PM
  4. Save multiple sheet/print sheet with one command button
    By GJR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2014, 03:06 PM
  5. Windows XP : What is print spooler service?
    By alicefred in forum Microsoft Windows Help
    Replies: 3
    Last Post: 02-21-2012, 08:57 AM
  6. Selecting Columns to print or save to another sheet
    By sanlen in forum Excel General
    Replies: 0
    Last Post: 08-27-2010, 12:00 AM
  7. save sheet & print automaticly
    By roots in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2006, 11:30 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