Nachtklavier
New Member
- Joined
- Mar 4, 2023
- Messages
- 4
- Office Version
- 2013
- Platform
- Windows
Hi there,
I am using formulas in workbook A to get data from workbook B.
Within the formulas the name of Workbook B as well as the object name are displayed:
My question is: (how) can the "LongFileName" be replaced with something more short, e.g. a reference in workbook A called "RefData", which contains the long file name?
My goal is to keep the formulas as short and clean as possible.
Thank you for any suggestion.
I am using formulas in workbook A to get data from workbook B.
Within the formulas the name of Workbook B as well as the object name are displayed:
Excel Formula:
=vlookup( [@number], 'LongFileNameWithExtension'!TableName[#Data], ... )
My question is: (how) can the "LongFileName" be replaced with something more short, e.g. a reference in workbook A called "RefData", which contains the long file name?
My goal is to keep the formulas as short and clean as possible.
Thank you for any suggestion.