Excel exporting PDF with two periods in file name, i.e. ''xyz..pdf"

I am using the following code:

Please Login or Register  to view this content.

to successfully export a sheet to PDF. However, it apperas to be adding one period to save as ''all files'' and then another to save as a pdf. I know this is a small issue, but it's irritating and I have programs that rely on uniform filenames to run.

Any help is appreciated. Thanks!

I tried that, and unfortunately that makes it not show a default save name at all. I think the problem then is the redundancy of

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Is there any way to use what you wrote, but get rid of the "Type:=" etc?

Yes, yours would work, but I want it to bring up the saveas dialog box with the filepath/filename default as I entered.