Good Afternoon all
I'm trying to convert and save a variable range, Worksheet "Data" row "R1: Z" into a PDF file, I have been trying the code below, however when I run it I'm receiving runtime error and message "Document Not Saved" with the last 4 lines of code highlighted in yellow
Could someone please point out where I am going wrong
Appreciated
jim
Please Login or Register to view this content.
Last edited by JamesT1; 08-16-2023 at 06:02 PM.
Try changing the "/" to "-" in the date part and possibly the ":" needs to change as well
Thanks Dave
Still getting the same results
Jim
Re: Convert range to PDF and save
So somewhat bad within the path and / or the filename, easy to solve just activating the Macro Recorder and operating manually …
Re: Convert range to PDF and save
Another thing which could be wrong :
what is the active worksheet according to the missing worksheet of Cells(Rows.Count, "R").End(xlUp) ?!
Evening all
This isn't working because of the file 'FName' name but I can't figure out why this isn't working
If I only use the date and time, it works well,, correct path, correct range and names the file with the date and time
As soon as I reference a cell it stops working,, even if I only use the cell ref without the date and timePlease Login or Register to view this content.
Please Login or Register to view this content.
I've figured it out
Its the contents of the refence cell..... It has ":" in it and I didn't notice it,,, this caused the issue...
Many thanks for your help earlier guys
Regards
jim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks