Save worksheet automatically as pdf with same filename

[Koenie01]

At the moment I use a macro to SaveAs .xls. This works great. Problem is, in the future I need to save the sheet as a pdf file (cause its much more difficult to change values).
The filename should stay the same as the existing excelfile (at the moment also happening). Macro's from the original file are also deletet in the extracted file.
This is what I have and, as said, works great but it seems I'm not capable to change this for pdf:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

I've tried several posibilities like:

Please Login or Register  to view this content.

But all I've tried doesn't work. Anyone ideas?

[6StringJazzer]

You nearly had it with the last one.

Please Login or Register  to view this content.

[Koenie01]

Thanks for your answer but ...
Seems still to give a problem. Complete line highlighted in yellow. Don't know what's wrong.

[6StringJazzer]

When a line is highlighted in yellow, an error message pops up. What is the error message?

[6StringJazzer]

Did you set a value for MyFileName?

[Koenie01]

No it doesn't give an error message and no didn't set a value. I also don't know how to fix the saving location.
Cause I'm new here, I don't know how to do this:
Please do not duplicate threads. If you have posted the question in the free forum already, please PM a mod / admin to delete / close the thread for you so you can repost in the Commercial services subforum. Thank you - Admins

I want to put it on the commercial services place. Wanna put max. 30$ on it.

[Koenie01]

Already bought this.

[6StringJazzer]

Thread closed.