[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1168
  • Last Modified:

Convert excel spreadsheet to PDF using VBA

I have a spreadsheet where i want to save 2 of the X numer of tabs to PDF using VBA. I have Adoboe acrobat 7 installed so to do it manually i just select the sheets and hit the "convert to Adobe PDF" button
0
dsvince
Asked:
dsvince
  • 3
  • 2
1 Solution
 
oceanbeachCommented:
have you tried using excel's macro recorder?

tools --> macro --> record new macro.
0
 
dsvinceAuthor Commented:
Thanks had already tried that but the "Convert to Adobe PDf" did not register in the VBA code. So I need some actual code.
0
 
DolGuldurCommented:
If you redo the macro but instead of using Adobe Macro to convert, go to File -> Print -> Adobe PDF, does it work?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
dsvinceAuthor Commented:
Thanks, So simple yet so effective, just didnt think to do it that way
0
 
dsvinceAuthor Commented:
just for the record the VBA

Application.ActivePrinter = "Adobe PDF on Ne00:"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
        "Adobe PDF on Ne00:", Collate:=True
0
 
DolGuldurCommented:
Glad I could help!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now