Forum Discussion
Macro to save as PDF with auto filename as cell value - gives Compile error - Syntax error
I have previously used a macro to call PDF Creator to save an invoice created in excel 365. However, it uses the old version of PDF Creator, because the new one has totally different methodology, nam...
Well!
I posted elsewhere, and got a reply. Someone had copied and pasted my code from the post and it worked for them.
So I copied and pasted my code from the post into my macro, and it worked.
But the code in my post had been copied and pasted from my original macro, where it didn't work.
So the exact same text, copied and pasted twice, worked when the original didn't.
To mess up is human. To really muck it up beyond belief requires a computer.
I posted elsewhere, and got a reply. Someone had copied and pasted my code from the post and it worked for them.
So I copied and pasted my code from the post into my macro, and it worked.
But the code in my post had been copied and pasted from my original macro, where it didn't work.
So the exact same text, copied and pasted twice, worked when the original didn't.
To mess up is human. To really muck it up beyond belief requires a computer.