Trying to build reference to external, web-based sheets
 

I am trying to build an automatic reference to an external workbook.

E.g. using the formula
='http://www.geocities.com/gunther7039/[betonsportslines.xls]Sheet1'!$F$7

returns the value '9'

What I need to do is be able to build the link dynamically and have it
return the proper data.

I want to be able to is separate the link into 3 parts, build it into a cell
and have it return the data

E.g. The below data would be in cells A1:A3 (Because the middle cell, A2,
will change to a different directory)

='http://www.geocities.com/gunther
7039
/[betonsportslines.xls]Sheet1'!$F$7

What I tried to do was concatenate(A1:A3) and return the data through either
a direct or indirect reference, but it just returns a #Value error.

Any help?

Thanks

Ken

Trying to build reference to external, web-based sheets
 

You can use INDIRECT if the other workbook is open, if not you would need
VBA


MOREFUNC (google it) has a function called INDIRECT.EXT that let you do this
on a closed workbook



--


Regards,


Peo Sjoblom


"Error trying to sort in a Macro"
om wrote in message
...
I am trying to build an automatic reference to an external workbook.

E.g. using the formula
='http://www.geocities.com/gunther7039/[betonsportslines.xls]Sheet1'!$F$7

returns the value '9'

What I need to do is be able to build the link dynamically and have it
return the proper data.

I want to be able to is separate the link into 3 parts, build it into a
cell
and have it return the data

E.g. The below data would be in cells A1:A3 (Because the middle cell,
A2,
will change to a different directory)

='http://www.geocities.com/gunther
7039
/[betonsportslines.xls]Sheet1'!$F$7

What I tried to do was concatenate(A1:A3) and return the data through
either
a direct or indirect reference, but it just returns a #Value error.

Any help?

Thanks

Ken

Trying to build reference to external, web-based sheets
 

Now it is giving me a #REF error. I tried workbooks on the web and on my
local machine.

Thanks for your help

"Peo Sjoblom" wrote:

You can use INDIRECT if the other workbook is open, if not you would need
VBA


MOREFUNC (google it) has a function called INDIRECT.EXT that let you do this
on a closed workbook



--


Regards,


Peo Sjoblom


"Error trying to sort in a Macro"
om wrote in message
...
I am trying to build an automatic reference to an external workbook.

E.g. using the formula
='http://www.geocities.com/gunther7039/[betonsportslines.xls]Sheet1'!$F$7

returns the value '9'

What I need to do is be able to build the link dynamically and have it
return the proper data.

I want to be able to is separate the link into 3 parts, build it into a
cell
and have it return the data

E.g. The below data would be in cells A1:A3 (Because the middle cell,
A2,
will change to a different directory)

='http://www.geocities.com/gunther
7039
/[betonsportslines.xls]Sheet1'!$F$7

What I tried to do was concatenate(A1:A3) and return the data through
either
a direct or indirect reference, but it just returns a #Value error.

Any help?

Thanks

Ken