Print to PDF using VBA

[Ash3d]

Hey guys!

I'm fairly new to VBA so forgive me if I sound all confused. I have a worksheet in excel which I need to print out as a PDF file. Is there any way I can do this? Is there a function I can use to output the information on the sheet as a PDF file in VBA?

Please let me know!

Thanks!

-Ash

 

[sachavez]

What version of Excel are you using?

Hey guys!

I'm fairly new to VBA so forgive me if I sound all confused. I have a worksheet in excel which I need to print out as a PDF file. Is there any way I can do this? Is there a function I can use to output the information on the sheet as a PDF file in VBA?

Please let me know!

Thanks!

-Ash

 

[Ash3d]

What version of Excel are you using?

Ms Excel 2010

 

[sachavez]

You don't need vba to print to PDF.

Click on File,
then select Save & Send,
then select Create PDF/XPS Document,
then check options (only active sheet),
then Publish

 

[Ash3d]

Actually, you're right! I could just automate the process using a macro.

Thanks!

And I apologize for my lack of common sense . Its been a long day.

You don't need vba to print to PDF.

Click on File,
then select Save & Send,
then select Create PDF/XPS Document,
then check options (only active sheet),
then Publish

 

[DetroitDavid]

I have an add-on question to this thread. I need to produce reports from Excel for several hundred clients, all numbered 001 through 400+.

On my report I’m viewing 1 cell on another sheet that pulls this information in. This is done with the following: =CONCATENATE("ID# ",'Master -Data'!A67,)

The Save As dialog comes up with the file name. I want to append this with the client number without the ID# (actually SpaceDashSpaceClientnumber).

So, Monthly Client Report June 2013.xlsx would show in the Save As dialog as Monthly Client Report June 2013 - 001.xlsx

Is there an easy way to do this?

TIA-DD