Pdf Printing through Primo pdf
 

i am trying to print some of spread sheets to pdf. i have recoded a macro
that trigers the print command but i still have to manually enter the file
name and save location where pdf file will be saved. I just want to a
automate this system. any sugesstions? i want macro to take the file name and
the folder name from the cell in the worksheet and save it and pdf it at that
location.
Thanks

Pdf Printing through Primo pdf
 

You will need PDF Creator from SourceForge as opposed to Primo but this
should work for you...

http://www.excelguru.ca/node/21

I have both PDF writers and I prefer PDF Creator for whatever that is worth...
--
HTH...

Jim Thomlinson


"soma" wrote:

i am trying to print some of spread sheets to pdf. i have recoded a macro
that trigers the print command but i still have to manually enter the file
name and save location where pdf file will be saved. I just want to a
automate this system. any sugesstions? i want macro to take the file name and
the folder name from the cell in the worksheet and save it and pdf it at that
location.
Thanks