Retrieve Formulas like Hyperion Ones

[tioilmo]

Hi everybody,

I am trying to find something to substitute the Hyperion retrieve formulas I have being using in Excell (based in a Add-in).

Note : The Hyperion is an financial application hardly used to store information in tables oragnized by period,accounts,entitities,categories etc...

Just to explain better :

I'd like to get a single information located in a different worksheet or Access database giving some parameters inside a function. The parameters should include name of the file,path of the file,name of the worksheet in the file,cell address. If the source information were located in an Access database I will need to give the name of the table or query and the field names instead of worksheet and cell address.

Note that the parameters should be stored in some cells in the current worksheet. So the function must only include the cells where these parameters are stored making it a dinamic function. When I change one or more of these parameters the function must update the result in the cell where the function were input.

The idea is to store a single information in a cell using a dinamic function like I usualy do using the Hyperion retrieve functions. It sounds like an Address function.

The idea is simple but until now nobody gave me a satisfatory unswer.

Let me give you an example : supose in cells A1, A2, A3 and A4 I have these parameters :
A1 : The address of the file
A2 : The name of the file
A3 : The worksheet of the file / or table/query of an Access file
A4 : One cell of the worksheet / the field name of an Access table

The function should be something like this : GETINFO (A1;A2;A3;A4)

Do I need create an user function in VBA or Excel have some function ready available to be used ?

Thanks for your help in advance.

Tio Ilmo

[Carim]

Hi,

Chip has already solved this problem with a UDF ...
http://www.cpearson.com/excel/GetInfo.htm

[tioilmo]

Hei Carim,

Nice to know you and thanks for your prompty reply.

Note that the situation is quite different :

I've already have, the path of file, the name of the file, the name of the worksheet, the cell address etc.. stored in the current worksheet in some different cells. What I need is using these parameters get an information.

The solution you gave me only returns different informations of a single cell modifing the function "getinfo". Like path, name of file, etc...

The idea is using several cells with the parameters above get one information stored in one cell or a range of cells.

Thanks again.

Tio Ilmo (I am Brazilian, sorry for the English)

[Carim]

Ok then ... You do have to write your own UDF tailored to your specific requirement ...

[tioilmo]

I am quite new in VBA, could you help me ?

Can you help me adapt the getinfo function to face my needs ?

Thank you in advance ...

Tio Ilmo

[Carim]

Hi,

All of us are glad to help ...
Be precise in describing your objective...
If you are new to writing a UDF, it is practically speaking, writing a macro ...