Saving as pdf in the same location with the same file name

Hello,
I need to make a macro that would save an opened excel file to the same location and the same file name, just as pdf (if it would "save" the original file and closed the workbook as well, that'd be a bonus! ).
How do I do it?
I recorded my macro (save as pdf), and tried to use ThisWorkbook.Path & ActiveWorkbook.Name , but I can't get it to work (I have never used VBA before, so I have no idea what I'm doing)
Help please ?

Please Login or Register  to view this content.

Thank you so much. Works a charm!
That's amazing.
Is there a way to stop a "file has changed , are you sure you want to save" prompt to say yes automatically ?
If not, that's still absolutely amazing, thank you!

I do apologise.
If I open a file (excel) and change something in it, and then use your macro it saves pdf, and closes an excel file. I'll get a prompt "want to save your changes to..."

Attachment 867804

Is there any way to automatically say "save" in the macro
(I'm really sorry to bother you with that, it's really not a big deal I can really live with that, but I'm curious..)

:D So simple. Amazing! Thank you so much once more !