LinkBack URL
About LinkBacks
Good day to all.
I have the bellow code, but urgenlty need a little ammendment. Now it is printing out, but would like to save in PDF (in defined directory) with name from column J.
Please Login or Register to view this content.
Good day to all.
I have the bellow code, but urgenlty need a little ammendment. Now it is printing out, but would like to save in PDF (in defined directory) with name from column J.
Please Login or Register to view this content.
Can you use your macro recorder and save it as a PDF? Once you have a code it can then be edited to save as a specific range.
Re: VBA code update - save as PDF based on value
Good day,
no cannot because I need that file name is from selected range. For example pls check attached files. For each customer has to generate a file and name it as customer name - in these case "CUSTOMER 1", "CUSTOMER 2", ecc...
excel sample:
EXAMPLE.xlsx
generated files:
1.pdf
2.pdf
3.pdf
Many THANKS
I repeat from my previous thread,
Once you have a code it can then be edited to save as a specific range.
Re: VBA code update - save as PDF based on value
Good day,
pls find attached bellow code. Now it is saving based on J4 value, but would like as per my previous post. Many thanks for help.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks