As an Excel Macro novice I understand it is possible to link (e.g.) Excel to Access (or vice versa), but can one invoke Excel twice on the same computer and then link files between them?
Why? I have a Macro that runs continuously and updates web data in real time... fetches data and updates charts... but unfortunately it flickers with every update (about once/second) and this is utterly unbearable to my eyes.
Note: Since my Excel macro includes code both in the Workbook and in a Module, any other Excel program I open in that Excel application also flickers at the same rate. Thus, for doing anything else in Excel at the same time I invoke Excel again and nothing there flickers.
In Summary, is there a way that I could run the flickering program in one Excel application and from another Excel fetch a data table at a lower frequency... view my updated charts there, etc?
Thanks,
Tom
PS - If you are interested in continuously running macros (or that run at specified times) you can search this forum for rodrigt, to see my other thread (Do-Loop...)
Bookmarks