Re: how to print to pdf?

Tech-Archive recommends: Speed Up your PC by fixing your registry


"jlorga" <jlorga.23gjxo@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:jlorga.23gjxo@xxxxxxxxxxxxxxxxxxxxxxxx

Hi, i'm new to vb stuff and i need fill an Excel *** with some data
from XML files and then i need to print that *** to a .pdf file. And
doing this from a .hta application.

I do everything and i have a macro in the excel *** that do this:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True,
PrToFileName:=filename

And in the Excel application i call this macro with the run command,
like this:
ExcelAppA.run "print2pdf"
And with this everything works, but the thing is that i need to pass
the filename as a parameter to the macro, and when i do that i don't
get any errors, but i also don't get any .pdf file.
I print the filename with the entire path, and i'm sure it's ok.

I need this for yeasterday, so if anyone can halp me on this? Is there
any way to do it without a macro, like calling the printOut method from
the .hta application?

Thanks,

Thare are several pdf creator programs that work as a printer.
The one I like is here :
http://sourceforge.net/projects/pdfcreator/
Once installed, your code can just choose the pdfcreator printer.
HTH


.

Quantcast