Before it is placed in the workbook, it is in a record set. You might have
to do a little of your own code writing. Use that as an example.

I don't think you need ActiveX enabled.

--
Regards,
Tom Ogilvy


"Baapi" wrote in message
...
Tom,

The code looks like that it copies a known range of data from closed
workbook.

What I'm looking for is to compare the data from a closed workbook with
the
data in the activesheet and highlight the cells with matching values. I do
not want to copy the data onto my excel sheet

The closed workbook will be maintained by me (add/delete etc.. everyday)
and
my team members will run macros on their machines to highlight data in
their
workbooks.

Will your earlier answer suffice my requirements?

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