Automatically create a PDF invoice

[philfloyduk]

Hi.

I use an excel spreadsheet with visual basic to manage our domestic appliance repairs and sales business. Currently when a job is completed a paper invoice is generated and an email automatically sent to confirm the details of the repair/ sale delivery. Ideally, the email would have a PDF invoice attached which would save time and money. I have third party PDF software installed, but is there a way to create the file and save it to a specific destination with a specific file name?

I'll be very greatful if anyone can help...

Thanks in advance

Phil

 

[Domski]

I have third party PDF software installed

What is the software you have?

Dom

 

[stefankemp]

and which version of Excel are you using?

 

[philfloyduk]

Hi Dom.

It's Primo PDF

 

[DippNCope]

Something here?
http://www.rondebruin.nl/pdf.htm

 

[Domski]

Never come across Primo PDF so don't know if it can be controlled with VBA. If you're on 2007/10 you should be able to use the code in the link above. If not you might want to have a look at this which uses another free pdf creator.

Dom

 

[philfloyduk]

I've had a play with the code for PDF creator but I'm getting an error when I try to run it:

"Compile error" then "user defined type not defined"

Most of my system has been created with the help from people on this site, my base knowledge of visual basic is quite poor so this means nothing to me! Is this something simple you can help me with or would I be better off upgrading to 2007 and doing it that way?

Thanks again

Phil

 

[philfloyduk]

Oh..... and I'm using 2003.

 

[philfloyduk]

I'd forgotten to check PDFcreator in references....

Appears to work now, just need adjust the code to save the correct thing in the correct place.

Thanks for your help!