Issue with automatically saving a file to a folder on my desktop

I have a quote program that i have put together with a lot of help from asking questions on these forums. I have a save as button on my sheet and would like to automatically save a backup .xlms file to a specific folder on my desktop. I would like to have it save the file name from 2 seperate fields in one workbook. Example: Customer Name & Job Name. The other issue is that it takes me to an excel filer first before taking me to the option of entering the file name and creating a backup .xlms file. Can someone look at this code and tell me what I need to do? I have been teaching myself VBA programming for the last 3 months and I am still not fluent in this language. Anything will help!

Please Login or Register  to view this content.

Here's the SaveAs method text from the help file:

Please Login or Register  to view this content.

Hi pcm,

This is how I'd insert the helpfile code:

Please Login or Register  to view this content.

But if you want B13 & B17 to be the filename:

Please Login or Register  to view this content.

And, you'd probably want to close it so that you'd be back in the one you backed up.

Please Login or Register  to view this content.