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!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA, save as PDF 1

Status
Not open for further replies.
June1975

June1975

Programmer
Jul 22, 2003
35
GB
Does anyone know how any VBA Excel code to save a Excel Worksheet as a PDF.?

I would aslo like to print each page on a worksheet as a PDF.

So for example if I did a print preview on a worksheet that was 6 pages long I would like to create 6 PDF documents rather than one.

What VBA code would I use to do this?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Open Word as ReadOnly 1
Replies
6
Views
581
Chriss Miller
C
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
4K
dhookom
dhookom
thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
668
combo
combo
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
1K
hermanlaksko
hermanlaksko
thanhthanh12
  • Locked
  • Question
How disable save and save as in word vba?
Replies
1
Views
326
macropod
macropod

Part and Inventory Search

Sponsor

Back
Top