Print to File...

[garden_rael]

Is there a way to make a macro to print to PDF or to a file and give an specific name to the file to be printed?
Can a Macro Change the name of the sheet? and then print a file with that name?

Thank you!!!
<!-- / message -->

 

[Domski]

The answer to both questions would be yes but would need some more detail. How you would go about it depends on the software you are using to create the pdf file. Are you using Adobe Pro?

Dom

 

[garden_rael]

It's Adobe Acrobat 7.0 Standard
I try to open it using the createobject command, but didn't work.. couldn't find the regisitry name to call it...

Now... even if I didn't have PDF... you can always print to a file can you?
I tried it... and It looks like a web page or something like that...


Any ideas?

 

[Domski]

This might give you some ideas: http://www.mrexcel.com/forum/showthread.php?t=193347&highlight=pdf&page=2

Dom

 

[garden_rael]

I'll try it out right away =)

Thank you very much!

 

[garden_rael]

I tried it, but I get an error on


Dim mypdfDist As New PDFDistiller


mypdfDist.FileToPDF tempPSFileName, tempPDFFileName, ""

What could it be?

 

[Domski]

Did you install the Distiller VBA Library?

'Dom Hill, June 2008
'This code has only been tested with Adobe Acrobat 6.0 Professional
'For this code to work the Adobe Distiller VBA library must be enabled
'Select Tools...References in the VBA editor and check it from the list

I've not used Acrobat 7.0 Standard but assume it comes the same.

Dom

 

[garden_rael]

It worked like charm!

thank you very much!