Code to add message box

Greetings, All.

What line of code would I need to add to the Save As code below to make a message box pop up that says "Your file has been saved as "whatever the filename is""? (The code saves the file as a filename based on the contents of a cell, I want the box to tell the user the name and location of the file.)

Please Login or Register  to view this content.

Thanks in advance for any help.

Hi there,

The information you need is within the VBA ThisWorkbook.FullName script. Knowing that, here's (hopefully) what you're after:

Please Login or Register  to view this content.

HTH

Robert

Thank you, Robert.

I didn't expect it to be anything nearly as involved. I don't know anything about variables, but I guess that's why I'm posting questions and you're posting answers.

Have a good one.

What if I just want the message box to read:

"Your file has been saved as (Cell H18.value)"

The last part being, or course, the actual value of cell H18, and without the parenthesis.

Not worried about the directory, as it is hard coded and won't change.

Can I do this by just adding one line of code?

Never mind. I got it.

It did only take one line of code, like this.

Please Login or Register  to view this content.

Thanks.