Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if Workbook fully loaded...
Hello,
In my Access database I am loading a very large Excel Workbook. It takes about three minutes for the workbook to load, so even though the xlapp and workbook reference are immediate, it takes quite along time for the workbook to display. I was wondering if there was something (maybe a property) I can check to see if the workbook is fully loaded. So far I've checked workbooks.count 0 and xlApp.visible but both are true right away, even though the workbok is not fully loaded or visible. Thanks for any help. Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if Workbook fully loaded...
Hi Matt, This doesn't exactly answer your question but you could try one of the below approaches to enforce a delay in your code until the workbook is/should be loaded: Code: -------------------- 'see the VBE help files for more details ie the necessary arguments Application.CalculateFull Application.OnTime Application.Wait -------------------- hth Rob Matt;419671 Wrote: Hello, In my Access database I am loading a very large Excel Workbook. It takes about three minutes for the workbook to load, so even though the xlapp and workbook reference are immediate, it takes quite along time for the workbook to display. I was wondering if there was something (maybe a property) I can check to see if the workbook is fully loaded. So far I've checked workbooks.count 0 and xlApp.visible but both are true right away, even though the workbok is not fully loaded or visible. Thanks for any help. Matt -- broro183 Rob Brockett. Always learning & the best way to learn is to experience... ------------------------------------------------------------------------ broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116775 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I open a workbook, cell protection is not fully active | Excel Worksheet Functions | |||
How to check if Software is loaded on a users C: drive | Excel Programming | |||
Check Excel's state to see if a workbook is loaded in App | Excel Programming | |||
How check if form is loaded? | Excel Programming | |||
Unhiding workbook when loaded | Excel Programming |