- Joined
- 5/17/06
- Messages
- 133
- Points
- 28
Does anyone know is it possible to pass cell values between different workbooks, and using VBA resides in one workbook to manipulate and perform calculations in other workbook?
When I say pass value that means not to use the COPY AND PASTE methods.
ie. the active book is called mybook.xls and all the VBA codes are in it. And I would like all the calculation result to be stored on a file yourbook.xls
Workbook("yourbook.xls").Worksheets("there").Cells(i, j) = Workbook("mybook.xls").Worksheet("here").Cells(i, j)
I tried it won't work.
You can use that method to pass cell values in different sheets within the same book.
But I never see any book mentioned about between different books.
Thanks a lot.
When I say pass value that means not to use the COPY AND PASTE methods.
ie. the active book is called mybook.xls and all the VBA codes are in it. And I would like all the calculation result to be stored on a file yourbook.xls
Workbook("yourbook.xls").Worksheets("there").Cells(i, j) = Workbook("mybook.xls").Worksheet("here").Cells(i, j)
I tried it won't work.
You can use that method to pass cell values in different sheets within the same book.
But I never see any book mentioned about between different books.
Thanks a lot.