Import Data from Closed Workbook

M

markus

I have several files named Rep1 to Rep8
I have another file called Group that I would like to use
to certain pieces of data from each book and place them on
a sheet in this new workbook. I only want to use VB. I
tried to use:

Worksheets("SR").Range("A8").Value = Workbooks
("Rep1").Worksheets("Calculator").Range("D1").Value
Worksheets("SR").Range("A9").Value = Workbooks
("Rep2").Worksheets("Calculator").Range("D1").Value

But this only works when the corresponding workbook is
open. Unfortunatley I cant have all 8 Rep workbooks open
at the same time. Is there vb to work around this behavior?

Thanks
 

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

How to reference a cell from anther workbook without opening it 0
I need a little more specific help. 1
sumif or if statement, pls help 0
error trying to sort data 4
Error on IF statement 3
Save As and new workbook new name used in existing code 8
Copy data from workbook 2 to workbook 3 mystery! 2
Select range from unopened workbook 7

Top