• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

Excel VBA

Hi everybody,

I'd like to speed up my application. How to turn on/off the window refreshing while the data processing (unfortunately I have forgot).

with best regards

Janos
0
kacor
Asked:
kacor
  • 3
  • 2
  • 2
  • +1
1 Solution
 
SteinerCommented:
Use:
Application.ScreenUpdating=False
0
 
Rog DManager Inforamtion SystemsCommented:
Another way to do this would be to not make the application visible until all updates are made.  At the end of the procedure.

Rog
0
 
kacorretiredAuthor Commented:
Hi Steiner and Rog,

thamks for your aid

with best regards

Janos
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
SteinerCommented:
No problem, that's what we are here for (besides for asking own questions of course).
And thanks for the grade!

Greetings
Steiner
0
 
kacorretiredAuthor Commented:
Hi Steiner,
you know earlier I made a lot of ExcelVBA macros (even of over 1000 lines - this was the german version) but I really forgot this command. Thanks again

wbr
Janos
0
 
venkatravi_78Commented:
if you r not using early binding then why dont u use it. early binding will make the process faster than the late one.

try this if u r not using this:

dim <variable name> as Excel.application
'this uses the previous instance of the excel application if any running
set <variable name>=getobject(,"excel.application")
'this where we create the object.
set <variable name>=createobject("excel.application")

regular code....

this will help a lot
0
 
kacorretiredAuthor Commented:
hi venkatravi_78,

thanks for the idea!

regards

Janos
0
 
venkatravi_78Commented:
did u get it working....
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now