> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marc Tompkins > Sent: Saturday, April 19, 2008 1:46 PM > To: tutor@python.org > Subject: Re: [Tutor] Hoping to benefit from someone's experience... >
> > As you might expect, most of the time is spent in Word. It > would probably be faster if I set Visible = False, but for > some reason the macro fails (silently) when I do that, so I > just minimize Word instead to cut down on screen refreshes. > Also, drive U is a Samba share, so there's network latency to > take into account. Even so, 10,231 files took less than 15 > minutes to convert, which I can live with. > This isn't Python related, but it might help those who do Word macros. I think you can use Applications.ScreenUpdating = False at the beginning of your macro. The macro will run a bit faster. It's essentially hiding all the updating to the document(s). You should set it back at the end of your macro: Application.ScreenUpdating = True. Mike _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
