PC Review


Reply
Thread Tools Rate Thread

Check if Workbook fully loaded...

 
 
Matt
Guest
Posts: n/a
 
      16th Jul 2009
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: How to tell when Outlook is fully loaded Dave Vespa [MSFT] Microsoft Outlook Program Addins 0 26th Sep 2008 12:10 AM
How to tell when Outlook is fully loaded? Stuart Parker Microsoft Outlook Program Addins 4 24th Sep 2008 12:50 PM
How to check if a subform is fully loaded? ScardyBob Microsoft Access Form Coding 5 21st Aug 2006 05:03 PM
How to check that mail is fully loaded Sanjay Singh Microsoft Outlook VBA Programming 0 30th Mar 2006 07:08 AM
Check Excel's state to see if a workbook is loaded in App Chris w. Microsoft Excel Programming 3 24th Feb 2005 11:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:33 AM.