Saving ActiveSheet as PDF

[UAL225]

Hi all,

Creating a sub to save the active sheet as a PDF with the file name as "Warta Sklepik Invoice #:E4" as a PDF on my desktop. I have nearly all of it working except the actual saving as a PDF. Any pointers where I went wrong here? I keep getting a syntax error.

Please Login or Register  to view this content.

[jolivanes]

If you change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Does that make a difference?

[mjr veverka]

... I keep getting a syntax error ...

Try:

Please Login or Register  to view this content.

Don't use "Name" as a variable name, it's reserved word in vba.
Don't use ":" in the filename.

[Logit]

.
Another method:

Please Login or Register  to view this content.

[jolivanes]

These 4 lines can be shortened from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and these 3 lines

Please Login or Register  to view this content.

can be replaced by to

Please Login or Register  to view this content.

I see that the first suggestion has been mentioned already.

[UAL225]

It did not make a difference :-/

[UAL225]

Thanks for these shorter methods! I prefer using the longer way to I can see where the code breaks! But I did update the code to make it shorter.

[UAL225]

Got it to work with this method and a little tweaking!

[Logit]

.
You are welcome. Glad to help.