Hi,
I have an open active workbook (called Data Collection) collecting real time data via an add in from an internet server.Another workbook (called Todays Workbook) is also open and has linked cells to Data Collection.
When I activate Todays Workbook it stops the code from running in Data Collection. Is it possible to have Todays Workbook activated while still running the code in Data Collection.
Being very new to VBA. Help would be much appreciated. Thank you.
Last edited by shumba; 06-14-2010 at 04:15 AM.
Not sure why you have cells in a workbook linked to an addin.
Post the code or attach the workbooks
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
RoyUK,Originally Posted by royUK
Thank you for your time. Here is the code.
This code is for the Data Collection workbook and runs fine when this workbook is activated. However when Today's workbook is activated the the code stops at
Please Login or Register to view this content.
Please Login or Register to view this content.
I have added two lines of code at the beginning of the Sub Timer Procedure.
and one line at the end before StartTimer2Please Login or Register to view this content.
Thanks to all those who have read and replied.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks