Setting an using a variable to a closed excel workbook

[tweeterisu]

First time poster here! I've searched and looked but cannot find a way to get this to work.

I need to reference a value from a closed excel file without using the morefunc addin or vba.

One way I can make it work but it's not ideal is hardcoding the string path for every cell

Example:

='http://url address/[filename.xlsx]Sheet1'!M7


Ultimatley, I would like to put a variable for url and for filename.

Any help would be greatley appreciated.

Thanks,
Matt

 

[tweeterisu]

So I got it to display within my file



="'"&(url&filename)&"'!cell"

it gives me the same structure as one that works as mentioned before but it does not return the value.

Am I missing something?

First time poster here! I've searched and looked but cannot find a way to get this to work.

I need to reference a value from a closed excel file without using the morefunc addin or vba.

One way I can make it work but it's not ideal is hardcoding the string path for every cell

Example:

='http://url address/[filename.xlsx]Sheet1'!M7


Ultimatley, I would like to put a variable for url and for filename.

Any help would be greatley appreciated.

Thanks,
Matt

 

[tweeterisu]

No suggestions from anyone?