input data from 3 workbooks into a fourth

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

is there a code to wait? 1
Run code from another workbook 7
Combining several workbooks into one file 4
Copy cell data from workbook based on user input 7
Link to workbooks 2
Copy Data from Closed File to Existing File 0
All Workbook Saved except This Workbook - Part2 3
How to copy a worksheet from one workbook to another in vb6 6

Back
Top