I have a macro enabled workbook with multiple worksheets that I want to save individually in PDF format. I have many other workbooks where I utilize the same basic code as I've included in this workbook with no issues, but I continue to get an error when trying to run it in this workbook. I've spent hours trying to isolate the issue but can't figure out.
Attached an example version of the workbook for reference. What am I doing wrong? Any help is appreciated!!
Example Macro Error.xlsm
Seemed to work OK for me. Are you sure that you are pointing it to save in an existing folder? There is usually a user ID between Users and Desktop.
Martin
I suspect you just need the user name between "users" and "desktop:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks