Hi,
I have earlier posted one query and have resolved the issue. Here i need an additional help to print pdf only one sheet.
In receipt sheet when will show in print preview will show from A1 to I32 and i need only this one page will print PDF automatically in the folder F:/Student Record/ and file name will be names cells of E6. Thanks.
Select A1:I32 and go to Page Setup > Print Area > Set Print Area
Then
Please Login or Register to view this content.
Hi,
I am confusing about this code. You mean i have to do the page setup manually r you right. There is no option to select auto create pdf. Thanks.
Since you always want to print the same cells it is better to select the print area manually. There's no advantage to doing it in code, and if you ever need to change it you don't have to touch the code. I would only use code for that in cases where you have to determine the print areas dynamically.
I do not understand what you mean by that. You are already using ExportAsFixedFormat in other parts of your code so I assume you know how to use it. If my answer is not clear please be more specific about what you need.There is no option to select auto create pdf
If you want
This is just an example
Please Login or Register to view this content.
Dear Hungt Sir thank you so much. I have tried it my file and running superb.
Not to take away from the already suggested solutions.
Another possibility where you do have to set the print range.
Change references as required.
Please Login or Register to view this content.
The inherent weakness of the liberal society: a too rosy view of humanity.
Thanks Mr. Joli. This also works fine for me and looks nice. Confuse to use which code. Thanks again for your effort to help.
Which code to use is up to you. But do you see the difference?
Run both codes from post #5 and post #7. Don't see the difference? Check this way:
1. Open the file from post #1 -> paste my code from post #5 -> Change "Sub SaveAsPDF" to "Sub hungt" -> SaveAs -> hungt.xlsm
2. Open the file from post #1 again -> paste the code from post #7 -> correct the code to match your data:
3. Run sub hungt and sub Or_So_MaybePlease Login or Register to view this content.
Compare the sita.PDF and sita_new.PDF files.
Don't see any difference?
Hungt Sir, I am using your code now and working fine without any error. Actually i have not found any difference in both of the codes. Both codes tried and both are save in the mentioned folder.
For me there is such a difference
Yes Sir. I have not noticed it. Now see this difference while your code of pdf is only one page. I am using your code as given earlier and not noticed the second code clearly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks