AnsweredAssumed Answered

vrf AW: AW: Reading Excel range into VEE

Question asked by detlef.baranski on May 8, 2003
Hi Warren,
maybe i mixed some things i my brain- getting older you know - with all
these new Object stuff.
The trick in Excel is to switch all work on the screen off so that you have
no screen refreshes anymore- this speeds Excel really...
try that:

Application.ScreenUpdating = False

Sorry that i am not 100 % sure- did not have access to my books currently.

Otherwise have a look to some Excel forums...
Trick to speed Excel Macros ....


Best regards,
detlef





-----Ursprngliche Nachricht-----
Von: Pickles, Warren [mailto:Warren.Pickles@tycoelectronics.com]
Gesendet: Donnerstag, 8. Mai 2003 14:11
An: VEE vrf
Betreff: [vrf] RE: AW: Reading Excel range into VEE


Tried that.  I would have thought it would speed things up, but it didn't
seem to make any difference in this case.  Thanks anyway.
Warren

-----Original Message-----
From: Baranski, Detlef [mailto:Detlef.Baranski@PILKINGTON.de]
Sent: 08 May 2003 11:39
To: VEE vrf
Subject: [vrf] AW: Reading Excel range into VEE


Excel gets damned slow in visible mode.
Just switch the visible mode off and after use of your routine on again.

ExcelApp.Visible = TRUE; Its slow ;-(

ExcelApp.Visible = FALSE; It gets fast

Best regards,
detlef

This message and any attachments are confidential, for the exclusive use of
the addressee and may be legally privileged. Any other distribution, use or
reproduction is unauthorised and prohibited. If you have received this
message in error, please notify the sender immediately and delete the
message from your system.

Visit our internet site at http://www.pilkington.com

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@it.lists.it.agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes