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.
Has anyone seen this before? My Help Desk is not Helping.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
Bookmarks