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