Hello,
Need Help!!
I need to save some of my spreadsheets of one excel file as a single PDF file.
Modified the following code obtained from the internet as per my requirement. However, I want the PDF file to be saved in the same location where my excel file is saved.
can someone please help me in this regard?
Please Login or Register to view this content.
Change this
to thisPlease Login or Register to view this content.
to save the pdf files in the same folder as the XL file.Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
it is giving me Path/File access error
Please Login or Register to view this content.
You have not specified your file name...
Please Login or Register to view this content.
Last edited by sintek; 08-25-2021 at 07:51 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
my file's name will be dynamic and so the location. it will be used by multiple users . so specifying the file name will be difficult
Still need a file name...Even if it is stored in a cell to be referenced...so specifying the file name will be difficult
tried the above solutions but this code is only creating a folder name PDFs on the desktop. it is not creating the pdf file on the source location of the excel file'
Please Login or Register to view this content.
Please Login or Register to view this content.
Still does not solve your Post 5 problem though...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks