Hi all,
Apologies if this has already been covered, I've tried searching but cannot find what i need. I am a complete beginner to VBA but hoping someone could help me with some code to create a PDF in the same folder as the excel file with the file name being the contents of cell A1 (which will contain a formula combining some text and a date).
Thanks in advance!
And with what content? The file name in A1 in what sheet? and what sheet will be print?
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Sorry for the lack of info. Id like to print the active sheet with the cell A1 contained within the active sheet. The print margins would be set for the content i'd like printed to PDF (e.g I select the margins in page break preview as the content/margins would vary each time I print)
You need to set up print area.HTML Code:
Great thanks tanasedn!
Last edited by kk1352; 07-14-2021 at 07:08 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks