Deactivating Excel's ScreenUpdating in VB OLE automation routine 
Author Message
 Deactivating Excel's ScreenUpdating in VB OLE automation routine

Hi all

I'm sure a lot of you guys use VB to fill Excel sheets and experienced
how slow this works when screen updating is activated. So you probably
found a way to turn this off. Excel online vb help says it's as simple
as setting application.ScreenUpdating to false. Unfortunately this has
NO EFFECT at all.
I use Win95, Excel97 and VB 5.0

Is this a known bug and could someone please post or mail a workaround?

this doesn't work :

dim mbill as object

  Set mbill = CreateObject("Excel.Sheet")
  mbill.Application.Visible = True

  mbill.Application.Workbooks.Open "D:\DAT\BILLSAMPLE.XLS"
  mbill.Application.Windows("BILLSAMPLE.XLS").Activate

  mbill.Application.ScreenUpdating = False       '!!!!!!!!!!!!!!!!

  GenerateBill 'code that fills my sheet

  mbill.Application.ScreenUpdating = True        '!!!!!!!!!!!!!!!!

Thanks a lot in advance!

Roger Grilli




Mon, 17 Jan 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ScreenUpdating won't stay deactivated.

2. Calling Excel's Close method w/ OLE Automation

3. Can't disable ScreenUpdating in Excel

4. Excel OLE very slow, can't pass by ref into Excel Macro from VB

5. Excel Ole automation with VB.NET

6. Help on OLE Automation (VB 4.0 to Excel 97)

7. VB OLE Automation to Excel

8. VB, OLE Automation and Excel

9. Accessing empty Excel cells via OLE automation from VB 3.0

10. Using OLE controls in Excel'95 VB

11. Catching events fired by OLE control in Excel'95 VB

12. Using OLE controls in Excel'95 VB

 

 
Powered by phpBB® Forum Software