+ Reply to Thread
Results 1 to 1 of 1

Print to PDF only works for some users

  1. #1
    Registered User
    Join Date
    10-26-2022
    Location
    Dallas
    MS-Off Ver
    Excel 365
    Posts
    1

    Print to PDF only works for some users

    Hi All, thanks for the add.

    I've created a very simple macro that scrolls through a couple hundred clients, creates an invoice for each, and prints to pdf. It works fine for me - anyone can open the PDFs. However, when the user runs the macro, the resulting PDFs cannot be opened. Same file, name, directory, everything. You get an error message : "Adobe Acrobat Reader could not open 'xxx.pdf' because it is either not a supported file type or because the file has been damaged". We're both on Office 365, but we're both remote and have different network connectivity.

    Sub Print_to_PDF()

    CurPDF = Range("Curr_PDF_Name").Value
    Sheets("Data").Select
    ActiveWindow.ActiveSheet.PrintOut Copies:=1, Collate:=True, _
    IgnorePrintAreas:=False, Printtofile:=True, PrtoFileName:=CurPDF
    Sheets("Main").Select

    End Sub
    Has anyone seen this before? My Help Desk is not Helping.
    Last edited by Seckert99; 10-26-2022 at 01:59 PM.

+ 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. [SOLVED] VBA print range works on PC, but not on Mac?
    By kingofcamden in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2019, 10:49 AM
  2. Macro button works for 2010 users, but not 2013
    By jspatten in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2015, 03:11 PM
  3. [SOLVED] macro needed for allocating works to users based on criteria
    By excelhelpseeker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2015, 02:29 PM
  4. Replies: 1
    Last Post: 03-27-2014, 02:08 PM
  5. [SOLVED] Ensure DTPicker works for all users
    By Dragman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2013, 05:56 PM
  6. [SOLVED] Print area only works on my PC!
    By ERD123 in forum Excel General
    Replies: 1
    Last Post: 07-18-2006, 12:55 PM
  7. [SOLVED] macro works for some users and doesn't for others
    By Pooja in forum Excel General
    Replies: 2
    Last Post: 10-27-2005, 04:05 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