and another thing...

will using ADO mean that all my team should have ActiveX loaded/enabled in
their system? if yes, it is going to be a problem as all my team do not have
that previlage.

is there any other method?

Thanks,
--
Baapi


"Tom Ogilvy" wrote:

Use ADO.

Macros are stored in workbooks. You can choose which one, but to run a
macro, the workbook containing the macro must be open. It could be opened
read only.

http://www.erlandsendata.no/english/...php?t=envbadac
--
Regards,
Tom Ogilvy


"Baapi" wrote:

Hi,

I've seen all the threads regarding the topic, but all these macros/codes
copy the data from a closed workbook to the active workbook.

I want a macro with following features
1. I do not want to copy the data, instead I want to load an array with the
data from a closed workbook
2. I do not know the amount of data in the closed workbook
3. Macro should run irrespective of whether the workbook is open or closed
4. Macro should be stored outside the workbook so that all the users in the
network should be able to use it

please, help me out of the situation.

Thanks a ton
--
Baapi