S
soma
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
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