Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting data from one spreadsheet to another
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting data from one spreadsheet to another
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... -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Don Fuller" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Collate data from one spreadsheet into another spreadsheet | Excel Worksheet Functions | |||
Can I pull data from a spreadsheet to another spreadsheet | Excel Discussion (Misc queries) | |||
How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
summarize data from one spreadsheet to other spreadsheet | Excel Worksheet Functions | |||
How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming |