ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pearson's Progress Bar (https://www.excelbanter.com/excel-discussion-misc-queries/49061-pearsons-progress-bar.html)

Bill Martin

Pearson's Progress Bar
 
I've been using Pearson's Progress Bar happily for awhile, but I have a
question. Whenever I use it in a new project I always have to go in manually in
the VBE to tell it to reference the ProgressReporter.DLL file.

Is there some way to just tell Excel once to always link to this file? Or is
there some reason that I wouldn't want to link to it if I'm not using it in a
particular file?

Thanks...

Bill

Dave Peterson

If you create a workbook that doesn't require that reference and you share the
workbook with others who don't have that .dll file, then you could be breaking
something.

If you don't share with anyone, then I would suspect some sort of overhead
payment for having a reference checked -- even if you don't use it.

I think I'd create a workbook that has that reference set (maybe nothing else in
it). Then just open that workbook and do a File|saveas right away.

Actually, I'd just set the reference manually <vbg. It would take me longer to
find that workbook than to just check that reference!

Bill Martin wrote:

I've been using Pearson's Progress Bar happily for awhile, but I have a
question. Whenever I use it in a new project I always have to go in manually in
the VBE to tell it to reference the ProgressReporter.DLL file.

Is there some way to just tell Excel once to always link to this file? Or is
there some reason that I wouldn't want to link to it if I'm not using it in a
particular file?

Thanks...

Bill


--

Dave Peterson

Bill Martin

Dave Peterson wrote:
If you create a workbook that doesn't require that reference and you share the
workbook with others who don't have that .dll file, then you could be breaking
something.

If you don't share with anyone, then I would suspect some sort of overhead
payment for having a reference checked -- even if you don't use it.

I think I'd create a workbook that has that reference set (maybe nothing else in
it). Then just open that workbook and do a File|saveas right away.

Actually, I'd just set the reference manually <vbg. It would take me longer to
find that workbook than to just check that reference!

Bill Martin wrote:

I've been using Pearson's Progress Bar happily for awhile, but I have a
question. Whenever I use it in a new project I always have to go in manually in
the VBE to tell it to reference the ProgressReporter.DLL file.

Is there some way to just tell Excel once to always link to this file? Or is
there some reason that I wouldn't want to link to it if I'm not using it in a
particular file?

Thanks...

Bill


-----------------------

Thanks Dave. I do appreciate the tool, but sometimes I forget to link it.

Bill


All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com