Hey guys can u help me here?
I am using the indirect function to get data from another workbook, but when I write thw whole path of the workbook it dosent work. What do I do wrong?
=INDIRECT("'C:\Users\abcd\Desktop\Test\[Test Trackingsheet2014.xlsx]TYC-011'!$D$90")
thanks for your help and have a nice weekend, this site is awesome.
Why do you think you need the INDIRECT function - that is a static reference. You can simply use:
Formula:
'C:\Users\abcd\Desktop\Test\[Test Trackingsheet2014.xlsx]TYC-011'!$D$90
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi!
Thanks for your answers I use indirect because parts of the reference is built up from other cells, I have just simplified it for the question. For instance I am using a mid() function to find the sheet name.
Is there another way to build up a reference name and get data from a closed workbook?
Regards
Also, I assume you know that INDIRECT won't work if the source workbook is closed?
Regards
You can use =indirect with a closed workbook using the morefunc add-in. See below.
http://www.ashishmathur.com/tag/indirect-ext/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks