Hi,
I am using excel 2016 (o365), and i used to have a similar formula on another job on excel 2013, but somehow i can't grasp where it fails...
here's my script
The red section is highligted in yellow, and i get the error "document not saved"
Please Login or Register to view this content.
Clues?
Assign the filename to a string variable and take a look at it. Is it valid?
Entia non sunt multiplicanda sine necessitate
What did your debug.print for the following expression
evaluate to?Please Login or Register to view this content.
Like this maybe.
Please Login or Register to view this content.
Last edited by bakerman2; 02-18-2017 at 02:40 AM.
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.
If i set the debug print Range to a name instead the code will work, BUT no pdf is created.
Ok filename issue mostly... if i take off the custom naming, and put "test" for example, the pdf will be produce, but with the excel document name, and not my custom name.
i dunno what to do at this point :S
I guess it all depends on what's in the cells you use to make the name of the pdf-file. You probably use a sign that's not allowed to create a filename.
Can you give example what a name looks like ?
it's just name of the person, and the date. it will output like
xatomicx team - John doe - February 2017
What i'm surprised is that even if i used a fixed name file, it will output as the excel file name anyway, but in pdf.
Does
make a difference?Please Login or Register to view this content.
Where would i put that?
Please Login or Register to view this content.
This works perfectly fine for me.
Please Login or Register to view this content.
.Range("A1:K42").ExportAsFixedFormat 0, fpHTML Code:
Red line is debugger highlighted yellow line when i get the "document not saved"
This is just not possible so I'm beginning to have serious doubts that o365 supports this method of exporting to Pdf.
now i think about it, I can save as pdf, but pretty sure pdf is not in the export, can made it save as instead of export?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks