need excel vba help wtith making pdf files

nailgunner · 28 Dec 2010

I did read the original question, so this is for the others who might be reading the posts.

There is another option. If you have the drive space for the program, Open Office has a nice tab that will quickly convert and save an Excel file as a PDF. Done it a few times and it takes about 5 seconds.

Irene · 29 Dec 2010

I cannot see the reason to use VBA at all.

Save the spreadsheet as a PDF file, by selecting from the drop-down menu.
Open the pdf file and select the printer.

Am I really missing something here?
.
.

mikedl · 29 Dec 2010

Hi, Irene. I do it to save steps. One chunk of VBA code converts it to a PDF, saves it to a file, prints it and prepares a blank email with the file attached.

Irene · 29 Dec 2010

mikedl said:

Hi, Irene. I do it to save steps. One chunk of VBA code converts it to a PDF, saves it to a file, prints it and prepares a blank email with the file attached.

Thanks for the explanation, Mike. I was beginning to think I was losing it.

At my time in life, the pressure for speed is significantly reduced.
Still, it's good to learn something new every day - and I certainly do on this forum.