This short snippet of code was designed to create a data portal between two open instances of Excel. The purpose of doing so is two fold:
1) to transfer the data realtime
2) to allow for two simultaneous executions of code
The code below develops two errors when it gets to the COPY FROM....COPY TO code line:
1) Microsoft is waiting for another application to complete an OLE action
2) Copy method of class failed
Any ideas on why I am getting these errors would be appreciated. My main purpose is to be able to make data available, in one session of excel, to another session so that only the newest data is carried over and appended to the database.
![]()
Please Login or Register to view this content.
Bookmarks