Get file name for email body reference

[justme]

I wold like to reference the Active Workbook file name in the body of the email I am sending out from a button. The sentence is telling people to go to a network location and lookup the name of a file. This is being placed in a worksheet that will be used by many different people. I only need to capture the file name, not the location.

Thanks in advance.

 

[Guitarde]

Just use this code to add it into your button code:
vName = ActiveWorkbook.Name

 

[justme]

Variable not defined???

I put your code under the Dim statements in the module. Then I added & vName outside the quotes in the sentence. I got the error message mentioned above.

the code looks like:

Under the Dim statements I added
vName = ActiveWorkbook.Name


.body = "Dear "
"Please go to this location blah blah " & vName

What is wrong?

 

[Zack Barresse]

Did you "Dim vName As String"?? Please post all your code.

I'd assume off hand (without seeing your code) at the top of your code you have 'Option Explicit' and that means you must declare all your variables.

 

[justme]

You were right.

Thanks.

This project is almost done!

 

[Guitarde]

First declare the variable

DIM vName as string

then

vName = ActiveWorkbook.Name

 

[justme]

Thanks Guitarde.