File name into a variable

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

In an excel macro, how can I place the name of the file I
am working on into a variable?

Thanks for your help in advance,
Tim
 
The code gives the name of the VB file, not the excel
file. Is there a way to give the name of the excel file?
 
The code gives the name of the VB file, not the excel
file. Is there a way to give the name of the excel file?
Click to expand...
???????

Public Sub myFile()
Dim s As String
s = ThisWorkbook.Name
MsgBox (s)
End Sub
 
No it does not. It gives the name of the excel file. "ThisWorkbook" means "this excel file". Please try out the code before replying, as you mislead other users.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening a list of Excel files and run a macro in each 17
Number and names of courses may change later 3
How to create a bubble chart with more than 2 variables 0
Utility to flatten/import X12 834 file into Excel 3
[EASY] I'll become mad ' & "" in variables 2
Simple Variable to someone 5
in a macro how to make a part of the formula a variable 3
vba: attach a variable name to a selected range 4

Back
Top