Save new pdf when move to next data in a range
I created a print_range which data will be replacing in the raw data at the back. what i need is each set of data will print pdf in print range once. wrote below but it keeps refreshing the first PDF file without printing a new pdf. would you please point out my mistake and how i can make it work?
Please Login or Register to view this content.
Last edited by teireii; 07-25-2017 at 09:53 PM.
Hello
Please put your codes between code tags
I don't know what do you mean exactly but I guess the following ..
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
thank you! sorry, i'm not very familiar with the posting quote.
what i'm saying is inside the for loop, the export as pdf export 1 PDF and keeps on refreshing the same pdf file instead of export a new pdf based on the next row.
hi Yasser, i tried with your code, it works at the first time.
when i run it again, the fname didn't change. the i keeps changing but i need fname to be change as well.
is it the vba variant issue? it didn't change the variant - fname.
HTML Code:
Last edited by teireii; 07-25-2017 at 02:11 AM.
guess it's the variant update issue in excel that cannot solved...therefore, i used another sub to change name as well as move to the folder i wanted.
thanks a lot!
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks