Hi,
I am trying to use Indirect on a closed workbook, but having some trouble.
this is the name of the workbook that is closed
What I need it to do is use that name but use the indirect function for the "17-10" part of the file name
Please Login or Register to view this content.
I can't seem to figure it out. Tried to use indirect and link each part of the name of the workbook ie.but that doesn't seem to work.Please Login or Register to view this content.
In K2:
="17-10"
then use it like this:
=INDIRECT("'[INVOICE "&K2&".xlsx]Sheet1'!$M$47")
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Unfortunately that doesn't seem to work, I had tried that previously. Do I need to put folder path or something in the formula as the workbook is closed? I get a #REF error
Last edited by groundin; 08-03-2017 at 11:53 PM.
It does work if the workbook is open, but not when closed
Thanks for your help
INDIRECT only works on open files, not closed files, perhaps the Morefunc add-in will be of use here?
http://www.ashishmathur.com/tag/morefunc/
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks