Trying to build reference to external, web-based sheets

[Error trying to sort in a Macro]

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

 

[Peo Sjoblom]

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"

 

[Error trying to sort in a Macro]

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

Thanks for your help

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"

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