Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access Reports To Adobe PDF Via VBA code?
btalon, This post if for Excel VBA but I think it could be useful for Access as well: thread223-416162- azh
- Post #21
- Forum: Microsoft: Access Modules (VBA Coding)
-
Excel to PDF Using Visual Basic
I used the wrong filename is the send keys command. It should read: Application.SendKeys ("c:\myPostScript.ps{TAB}~") It now works fine.- azh
- Post #21
- Forum: Adobe: Acrobat
-
Excel to PDF Using Visual Basic
I had to add the following line before the .PrintOut line to get it working in Excel 97: Application.SendKeys ("c:\myPDF.pdf{TAB}~") The VBA help in Excel 97 says: PrintToFile Optional Variant. True to print to a file. Microsoft Excel prompts the user to enter the name of the output...- azh
- Post #20
- Forum: Adobe: Acrobat
