Issue Printing to PDF using a Command Button and VBA

[PandaPlaza1277]

Hello,

I'm running into an issue printing a specific hidden spreadsheet to PDF using a Command Button. I've managed to make this code work in another workbook of mine and I've even had this code work a number of times in this spreadsheet (maybe 4 times or so earlier on). For some reason, it does not consistently work. I've spent a good amount of time searching for answers and verifying the code that seems to be in question, but as far as I can tell, the input is correct. The error seems to be occurring with the "OpenAfterPublish:=True" line of code. Does anyone have any ideas what could be going wrong?

 

[PandaPlaza1277]

Update - I was able to get the "? pdffile" code to work. It now displays "...\Desktop\301600 - Summary Analysis - 8/4/2022.pdf", just like it should. After the adjustments, I had to close out the workbook and reopen it to be able to rerun the "? pdffile" code in the Immediate Window.
However, the same issue persists with the printing function.

 

[Domenic]

You'll need to replace those forward slashes ( / ) with some other character, maybe a dash ( - ) instead. So, for example, assuming that the format for your date is "m/d/yyyy", replace...

SumAn.Range("C10").Value

with

Format(SumAn.Range("C10").Value, "m-d-yyyy")

Change the format accordingly.

Hope this helps!

 

[Domenic]

My apologies, earlier in this thread when I listed the illegal characters for a filename, I forgot to include the forward slash and the backslash. I have edited that post to include these characters.

 

[PandaPlaza1277]

My apologies, earlier in this thread when I listed the illegal characters for a filename, I forgot to include the forward slash and the backslash. I have edited that post to include these characters.

AHA!!! That was it! The code was referencing a cell (C10), which was formatted as a date, and using either the special character "/" or "-".
I switched the cell C10 to the General format and adjusted the formula in the cell to use the TEXT("m.d.yy") function and it's working now!
Thank you so much!!!