input data from 3 workbooks into a fourth
 

im starting from scratch and not sure how to begin:
i have 3 workbooks; register1.xls,register2.xls, and register3.xls. i want
to be able to import values entered from register 1 2 or 3. into data.xls.
register 1 2 and 3 are on seperate computers, but are networked. any info
would be GREATLY appreciated. thank you in advance

input data from 3 workbooks into a fourth
 

Can you open the three workbooks manually from whatever computer you want to
use? If so, turn on the macro recorder and open them manually. then copy
the data you want into you consolidation workbook.

Then look at the code you record and modify it to suit your needs.

--
Regards,
Tom Ogilvy


"choice" wrote in message
...
im starting from scratch and not sure how to begin:
i have 3 workbooks; register1.xls,register2.xls, and register3.xls. i want
to be able to import values entered from register 1 2 or 3. into
data.xls.
register 1 2 and 3 are on seperate computers, but are networked. any info
would be GREATLY appreciated. thank you in advance

input data from 3 workbooks into a fourth
 

i guess my main question is, the three registers are protected then
unprotected during the macro, then reprotected. will that mess anything up
about the sharing? the data.xls is unprotected.

"Tom Ogilvy" wrote:

Can you open the three workbooks manually from whatever computer you want to
use? If so, turn on the macro recorder and open them manually. then copy
the data you want into you consolidation workbook.

Then look at the code you record and modify it to suit your needs.

--
Regards,
Tom Ogilvy


"choice" wrote in message
...
im starting from scratch and not sure how to begin:
i have 3 workbooks; register1.xls,register2.xls, and register3.xls. i want
to be able to import values entered from register 1 2 or 3. into
data.xls.
register 1 2 and 3 are on seperate computers, but are networked. any info
would be GREATLY appreciated. thank you in advance

input data from 3 workbooks into a fourth
 

I don't work with shared workbooks that much - but I doubt it. If anything,
being shared will prevent you from unprotecting and protecting the
workbooks. So I would go ahead and test it.

--
Regards,
Tom Ogilvy

"choice" wrote in message
...
i guess my main question is, the three registers are protected then
unprotected during the macro, then reprotected. will that mess anything up
about the sharing? the data.xls is unprotected.

"Tom Ogilvy" wrote:

Can you open the three workbooks manually from whatever computer you
want to
use? If so, turn on the macro recorder and open them manually. then
copy
the data you want into you consolidation workbook.

Then look at the code you record and modify it to suit your needs.

--
Regards,
Tom Ogilvy


"choice" wrote in message
...
im starting from scratch and not sure how to begin:
i have 3 workbooks; register1.xls,register2.xls, and register3.xls. i
want
to be able to import values entered from register 1 2 or 3. into
data.xls.
register 1 2 and 3 are on seperate computers, but are networked. any
info
would be GREATLY appreciated. thank you in advance