Prev: Automatically entering a number of tables when prompted.
Next: Template- when saved as a new document remove macros
From: Lloyd Catlett on 26 Apr 2010 10:49
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?
--
L. Catlett


"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 .
>
> --
> Michael Bednarek http://mbednarek.com/ "POST NO BILLS"
> .
>
From: Michael Bednarek on 26 Apr 2010 21:54
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).

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"
From: Jay Freedman on 26 Apr 2010 22:25
On Tue, 27 Apr 2010 11:54:43 +1000, Michael Bednarek
<ROT13-zo(a)gtz.pbz.nh> 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.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
From: Michael Bednarek on 27 Apr 2010 21:42
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.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"
From: Doug Robbins - Word MVP on 28 Apr 2010 03:38
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.

In my case, it appears that the file was installed as part of the Roxio Easy
Media Creator software as it is only in a folder under that application that
it appears.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Michael Bednarek" <ROT13-zo(a)gtz.pbz.nh> wrote in message
news:fbuet5dpiek1gnigjd5u1p742nikf82vkh(a)4ax.com...
> 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.
>
> --
> Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Automatically entering a number of tables when prompted.
Next: Template- when saved as a new document remove macros