How to show user % complete for time-consuming task?
in [Word VBA]
|
Prev: Automatically entering a number of tables when prompted.
Next: Template- when saved as a new document remove macros
From: Michael Bednarek on 28 Apr 2010 21:39 On Wed, 28 Apr 2010 17:38:19 +1000, "Doug Robbins - Word MVP" wrote in microsoft.public.word.vba.general: >"Michael Bednarek" wrote: >> On Mon, 26 Apr 2010 22:25:29 -0400, Jay Freedman wrote in >> microsoft.public.word.vba.general: >> >>>On Tue, 27 Apr 2010 11:54:43 +1000, Michael Bednarek wrote: >>> >>>>On Mon, 26 Apr 2010 07:49:02 -0700, Lloyd Catlett wrote in >>>>microsoft.public.word.vba.general: >>>> >>>>>"Michael Bednarek" wrote: >>>>> >>>>>> On Fri, 23 Apr 2010 10:23:02 -0700, Lloyd Catlett wrote in >>>>>> microsoft.public.word.vba.general: >>>>>> >>>>>> >I've a sub that takes as much as 2 minutes to complete all work and >>>>>> >return >>>>>> >control to user. I can easily calculate the % progress and want to >>>>>> >display >>>>>> >it (with updates) to let the user know something is really happening. >>>>>> > >>>>>> >I created a textbox that I make visible and can change the >>>>>> >textbox.value as >>>>>> >the % complete changes. The only way I can get the textbox.value to >>>>>> >update >>>>>> >is to do a userform.RePaint, but the flickering of the userform is >>>>>> >distracting. >>>>>> > >>>>>> >Any suggestions for another way? >>>>>> >>>>>> Have you tried the "Microsoft ProgressBar Control 6.0" from "Microsoft >>>>>> Windows Common Controls 6.0" (mscomctl.ocx)? I've used that a number >>>>>> of >>>>>> times. Some instructions at >>>>>> http://www.la-solutions.co.uk/content/MVBA/MVBA-ProgressBar.htm . >>>>> >>>>>I've tried this, but where I define frm as a new frmProgressBar I get >>>>>error >>>>>"user-defined type not defined"; I guess this means I need to add a >>>>>reference. If this is my problem, do you know which reference I need to >>>>>add? >>>> >>>>As I wrote before, it works here when I add a reference to "Microsoft >>>>Windows Common Controls 6.0" (mscomctl.ocx). >>> >>>Unless you had Visual Basic 6.0 or someone distributed mscomctl.ocx >>>with a VB 6.0 application, or (in violation of the EULA) you >>>downloaded the file from someplace on the web, you won't have that >>>file. Read the Overview section of >>>http://www.microsoft.com/downloads/details.aspx?FamilyId=25437D98-51D0-41C1-BB14-64662F5F62FE&displaylang=en. >> >> I believe your are incorrect. >> >> One: all our office PCs have mscomctl.ocx, and only 2 have VB installed, >> but all have Microsoft Office Professional V-11 installed. >> >> Two: quoting from http://support.microsoft.com/kb/280662 : >> "These components (web controls from mscomctl.ocx) are included with the >> Microsoft Office Standard Suite and the Microsoft Office Professional >> Suite, as well as with Microsoft Access." >> >> Three: In the MSOF11 distribution, there's a file MSCOMCTL.OCX in >> ZS561401.CAB and in FILES\ACCRT\ACCESSRT.CAB . >> >> Four: I'm not in the habit of "downloading files from someplace on the >> web" and I find that suggestion offensive. >> >> I consider it rude and libellous to accuse correspondents whose record >> and reputation in these fora is not difficult to ascertain of such >> criminal behaviour. > >Jay did not actually accuse you of doing something in violation of a EULA. >That was just one of the ways that he mentioned that it might have been >obtained. There were other legitimate means by which it may have been >installed. [snip] Quote: Unless you had Visual Basic 6.0 or someone distributed mscomctl.ocx with a VB 6.0 application, or (in violation of the EULA) you downloaded the file from someplace on the web, you won't have that file. Jay Freedman. Mon, 26 Apr 2010 22:25:29 -0400 If the above was an incomplete list of legitimate means to obtain mscomctl.ocx and if the "you" was meant as substitute for the impersonal pronoun "one", then the post was pointless. I haven't seen any pointless posts by Jay, so I assume this post also has a point. In determining the point, I read what was written: "Unless "VB" or "App" or "illegal": "you won't have that file." transformed: "You can only have that file" if "VB" or "App" or "illegal". I know I don't have "VB" or "App", so I must have the file illegally. If the point of the post was that Jay wanted to know whether mscomctl.ocx was present on the OP's (Lloyd Catlett) PC, the post failed. -- Michael Bednarek http://mbednarek.com/ "POST NO BILLS" |