Getting data from one spreadsheet to another

[Don Fuller]

I have created a VB function that will pull numerical data from
specific cells in different spreadsheets and place the data in my main
status spreadsheet. Everything works fine, but I am getting data from
my status spreadsheet instead of the spreadsheets on the server.
Basically, I am pulling that data from the local source instead of the
remote sources. Below is the portion of my function that is not
working properly.

If Cells(TestCaseRow, 1) = "a" Then ColumnA = ColumnA +
Cells(TestCaseRow, 20)
If Cells(TestCaseRow, 1) = "b" Then ColumnB = ColumnB +
Cells(TestCaseRow, 20)
If Cells(TestCaseRow, 1) = "c" Then ColumnC = ColumnC +
Cells(TestCaseRow, 20)

I need to get the path to the remote spreadsheets into the statements
above. Any help will be greatly appreciated.

Don

 

[Dick Kusleika]

Don

When you use the Cells property unqualified, it's the same as using

ActiveSheet.Cells(...

You need to create an object variable that points to the sheet that you
want, then qualify all your Cells properties with that variable.

Dim sh As Worksheet

Set sh = Workbooks("Book1.xls").Worksheets(1)

If sh.Cells(TestCaseRow etc...