Need a function to access data in closed workbooks

Hi,

I have a two-part question.

I am trying to produce a summary workbook that accesses data from 100+ closed workbooks.

Previously I used indirect.exe but I can’t find a working version of morefunc online anymore.

I can access closed workbooks with this function :

='C:\Documents and Settings\o\My Documents\[WEEK90A.xls]Monday'!A1

So question one would be: How can I edit this function to make “WEEK90A.xls”, “Monday” and “A1” refer to indirect values held in a helper sheet called “workings”?

Eg workings!a1 contains the text “Week90”
workings!b1 contains the text “Monday”
workings!c1 contains the text “A1”

Question number two would be: Does anyone have a working version of morefunc they could put on the site as an attachment?

Thanks in advance

Thanks Tony,

Does this version work for you, because I am getting "runtime error 216 at 000032c0" when I try to run setup?

This is the same problem I get with the versions I've downloaded recently. I assumed there was something wrong with them but if this version works for you it might be a problem with my pc setup (I recently reinstalled windows).

Would it be possible for someone to post the actual dll(s) or alternatively has anyone had and solved the runtime error?

Cheers

Thanks for getting back to me.

Morefunc worked before I re-installed everything so I guess I need to look at my pc set-up (I'm guessing it's a service pack or anti-virus issue).

Problem is now solved, thanks for your help.

Apparently the setup program as issues with large hard drives (i just went from a 10GB to an unpartitioned 2TB).

I ran the the setup at an internet cafe then put the files in the appropriate folders once I got home.