Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Capturing the Excel File name in a cell in the same workbook

Status
Not open for further replies.
mastro78

mastro78

Programmer
Apr 10, 2007
70
0
0
US
What I'd like to do is have the file name of the Excel worksheet/workbook I'm using to capture the name of itself in a cell in a hidden worksheet.

Please advise, thank you!
 
Sort by date Sort by votes
From the MSOffice FAQs: faq68-2561

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kapok1
  • Locked
  • Question
add all the files under the same folder including the subfolder, all sheets in worbook included
Replies
2
Views
74
kapok1
kapok1
huiettcm
  • Locked
  • Question
Catching the Mouse Click Error in Modal User Form
Replies
1
Views
118
strongm
strongm
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
159
SkipVought
S
M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
129
mintjulep
M
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
145
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top