L
Legacy 98055
Guest
I know it is possible with ADO, but maybe someone here can show me an easier way to accomplish the following.
I have a master workbook which will be in charge of updating multiple other workbooks.
What I would like to do is to update the workbooks without opening them.
I have found multiple examples of updating the open workbook with data from a closed workbook. How about the other way around?
Can I send data to a closed workbook?
If you know the syntax, please post an example of sending info from ActiveWorkbookMaster.xls Range A:1 to ClosedExample.xls cell B:1
I really appreciate the help!
Have a nice day!
Tom
This message was edited by TsTom on 2002-03-26 19:06
I have a master workbook which will be in charge of updating multiple other workbooks.
What I would like to do is to update the workbooks without opening them.
I have found multiple examples of updating the open workbook with data from a closed workbook. How about the other way around?
Can I send data to a closed workbook?
If you know the syntax, please post an example of sending info from ActiveWorkbookMaster.xls Range A:1 to ClosedExample.xls cell B:1
I really appreciate the help!
Have a nice day!
Tom
This message was edited by TsTom on 2002-03-26 19:06