Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Jens,
A couple of tips to speed up your program. 1) ScreenUpdating = False (will run faster as screen doesn't need to be updated.) 2) Visible = False (If you don't need it on screen) 3) With appWord.Application.ActiveDocument.Paragraphs(1).R ange.Font .Name = "Arial" .Size = BRIEF_FONTGROESSE_ADRESSE_KLEIN End With (All the other settings are the default values so don't need to be set unless you're changing them) There are other ways to speed it up, like changing the For Next loops to Do loops. One of the Excel MVPs (Can't remember which one, but Google will find it) has a web page dedicated to speeding up VBA. Although this is specifically for Excel, most of the recommendations will apply to Word VBA as well. HTH Henry "Jens 'Kluesi' Kluesener" wrote in message ... Hi Sorry for my crossposting. I found this NG after I posted the question in microsoft.public.excel. I do my best next time. I have got created an Excel Script that creates a Word Document. A bill. But for only 8 bill entries the script needs to much time. For this entries it works about 30 secounds. If you want to help me look at this page: www.kluesener.info/excel.html And if you find anything that saves time please tell me how I can do it better. Sorry for my bad english Many Thanks Jens |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving changes to option to apply all the time. | Excel Discussion (Misc queries) | |||
automatically put date and time on the cells when saving ? | New Users to Excel | |||
Saving in 2007 and 2003 formats at the same time | Excel Discussion (Misc queries) | |||
Saving files in two different formats at the same time | Excel Discussion (Misc queries) | |||
Saving a time stamp with a macro? | Excel Programming |