Errors  
Author Message
DaraLune





PostPosted: Sun Oct 23 07:02:51 CDT 2005 Top

Visual Basic >> Errors Dear All,

Does anyone know of a third party tool that can add error handling code to
all subs/functions in a class or module to a specified format which then can
be customised to deal with the errors likely to be raised at the code?

I have been neglectful in adding error handling code and comments as I go as
the project has now grown and other developers are going to be using my
code. I know that it is bad practice and I have learned my lesson, but any
advice, other than its your own fault, would be most welcome. If I have to
create my own add-in for the future, can anyone suggest how I can
programatically find the start and end of a sub to add the suggested code?

Thanks again.

Alastair MacFarlane

Visual Studio179  
 
 
Ralph





PostPosted: Sun Oct 23 07:02:51 CDT 2005 Top

Visual Basic >> Errors
"Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
news:uPL$EMail@HideDomain.com...
> Dear All,
>
> Does anyone know of a third party tool that can add error handling code to
> all subs/functions in a class or module to a specified format which then
can
> be customised to deal with the errors likely to be raised at the code?
>
> I have been neglectful in adding error handling code and comments as I go
as
> the project has now grown and other developers are going to be using my
> code. I know that it is bad practice and I have learned my lesson, but any
> advice, other than its your own fault, would be most welcome. If I have to
> create my own add-in for the future, can anyone suggest how I can
> programatically find the start and end of a sub to add the suggested code?
>
> Thanks again.
>
> Alastair MacFarlane
>

You can start with MZTools:
http://www.mztools.com/
Which has an excellent price of free.

-ralph



 
 
Alastair





PostPosted: Sun Oct 23 07:13:36 CDT 2005 Top

Visual Basic >> Errors Thanks Ralph,

I have heard it being mentioned on this group before but never looked into
it. I will now. Thanks for your help.

Alastair


"Ralph" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
>
> "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
> news:uPL$EMail@HideDomain.com...
>> Dear All,
>>
>> Does anyone know of a third party tool that can add error handling code
>> to
>> all subs/functions in a class or module to a specified format which then
> can
>> be customised to deal with the errors likely to be raised at the code?
>>
>> I have been neglectful in adding error handling code and comments as I go
> as
>> the project has now grown and other developers are going to be using my
>> code. I know that it is bad practice and I have learned my lesson, but
>> any
>> advice, other than its your own fault, would be most welcome. If I have
>> to
>> create my own add-in for the future, can anyone suggest how I can
>> programatically find the start and end of a sub to add the suggested
>> code?
>>
>> Thanks again.
>>
>> Alastair MacFarlane
>>
>
> You can start with MZTools:
> http://www.mztools.com/
> Which has an excellent price of free.
>
> -ralph
>
>
>


 
 
Ralph





PostPosted: Sun Oct 23 07:50:19 CDT 2005 Top

Visual Basic >> Errors
"Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
> Thanks Ralph,
>
> I have heard it being mentioned on this group before but never looked into
> it. I will now. Thanks for your help.
>
> Alastair
>
>
> "Ralph" <EMail@HideDomain.com> wrote in message
> news:EMail@HideDomain.com...
> >
> > "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
> > news:uPL$EMail@HideDomain.com...
> >> Dear All,
> >>
> >> Does anyone know of a third party tool that can add error handling code
> >> to
> >> all subs/functions in a class or module to a specified format which
then
> > can
> >> be customised to deal with the errors likely to be raised at the code?
> >>
> >> I have been neglectful in adding error handling code and comments as I
go
> > as
> >> the project has now grown and other developers are going to be using my
> >> code. I know that it is bad practice and I have learned my lesson, but
> >> any
> >> advice, other than its your own fault, would be most welcome. If I have
> >> to
> >> create my own add-in for the future, can anyone suggest how I can
> >> programatically find the start and end of a sub to add the suggested
> >> code?
> >>
> >> Thanks again.
> >>
> >> Alastair MacFarlane
> >>
> >
> > You can start with MZTools:
> > http://www.mztools.com/
> > Which has an excellent price of free.
> >
> > -ralph
> >

I just now noticed that you want to write your 'own' Addins (too early here,
only one cup of coffee, smile).

[Warning: Opinion piece follows. <g>]
I used to write my own Addins, but got out of the habit because,
1) they usually turn into non-trivial projects,
2) documentation is scanty and MS documentation is often misleading or just
plain wrong,
3) it became easlier to use a 3rd party editor with 'macro' tools (I used
CodeWright, but there are other better, less expensive ones, out there), and
4) you usually need to do a bit of final massage on the code (ie, OSFA
seldom applied) so attempting to write a 'fully' automated tool, often saved
less time that imagined.

Here is a little book that I found useful. (Surprised to find it still
available) The Extensibilty model changed a bit from VB5 - but most of
Microsoft's documentation errors were repeated with VB6, so this book is
very useful. It also tends to put everything in one place so you can look at
it as a whole.
http://www.amazon.com/exec/obidos/ASIN/1576101673/gridlinxsoftware/102-6720874-9080925

hope this helps,
-ralph


 
 
Alastair





PostPosted: Sun Oct 23 08:13:58 CDT 2005 Top

Visual Basic >> Errors Thanks again Ralph,

I have written a few add-ins for Office 2000 but never for the VB IDE. Maybe
I will look into it more seriously (only when I have more time). Maybe next
centuary! My wife argues that it is Sunday and I should spend some time with
her. Thanks for the support.

Alastair MacFarlane

p.s. Although I am tempted... no, I had better not!

"Ralph" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
>
> "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
> news:EMail@HideDomain.com...
>> Thanks Ralph,
>>
>> I have heard it being mentioned on this group before but never looked
>> into
>> it. I will now. Thanks for your help.
>>
>> Alastair
>>
>>
>> "Ralph" <EMail@HideDomain.com> wrote in message
>> news:EMail@HideDomain.com...
>> >
>> > "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
>> > news:uPL$EMail@HideDomain.com...
>> >> Dear All,
>> >>
>> >> Does anyone know of a third party tool that can add error handling
>> >> code
>> >> to
>> >> all subs/functions in a class or module to a specified format which
> then
>> > can
>> >> be customised to deal with the errors likely to be raised at the code?
>> >>
>> >> I have been neglectful in adding error handling code and comments as I
> go
>> > as
>> >> the project has now grown and other developers are going to be using
>> >> my
>> >> code. I know that it is bad practice and I have learned my lesson, but
>> >> any
>> >> advice, other than its your own fault, would be most welcome. If I
>> >> have
>> >> to
>> >> create my own add-in for the future, can anyone suggest how I can
>> >> programatically find the start and end of a sub to add the suggested
>> >> code?
>> >>
>> >> Thanks again.
>> >>
>> >> Alastair MacFarlane
>> >>
>> >
>> > You can start with MZTools:
>> > http://www.mztools.com/
>> > Which has an excellent price of free.
>> >
>> > -ralph
>> >
>
> I just now noticed that you want to write your 'own' Addins (too early
> here,
> only one cup of coffee, smile).
>
> [Warning: Opinion piece follows. <g>]
> I used to write my own Addins, but got out of the habit because,
> 1) they usually turn into non-trivial projects,
> 2) documentation is scanty and MS documentation is often misleading or
> just
> plain wrong,
> 3) it became easlier to use a 3rd party editor with 'macro' tools (I used
> CodeWright, but there are other better, less expensive ones, out there),
> and
> 4) you usually need to do a bit of final massage on the code (ie, OSFA
> seldom applied) so attempting to write a 'fully' automated tool, often
> saved
> less time that imagined.
>
> Here is a little book that I found useful. (Surprised to find it still
> available) The Extensibilty model changed a bit from VB5 - but most of
> Microsoft's documentation errors were repeated with VB6, so this book is
> very useful. It also tends to put everything in one place so you can look
> at
> it as a whole.
> http://www.amazon.com/exec/obidos/ASIN/1576101673/gridlinxsoftware/102-6720874-9080925
>
> hope this helps,
> -ralph
>
>


 
 
Ralph





PostPosted: Sun Oct 23 08:22:53 CDT 2005 Top

Visual Basic >> Errors
"Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
> Thanks Ralph,
>
> I have heard it being mentioned on this group before but never looked into
> it. I will now. Thanks for your help.
>
> Alastair
>
>
> "Ralph" <EMail@HideDomain.com> wrote in message
> news:EMail@HideDomain.com...
> >
> > "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
> > news:uPL$EMail@HideDomain.com...
> >> Dear All,
> >>
> >> Does anyone know of a third party tool that can add error handling code
> >> to
> >> all subs/functions in a class or module to a specified format which
then
> > can
> >> be customised to deal with the errors likely to be raised at the code?
> >>
> >> I have been neglectful in adding error handling code and comments as I
go
> > as
> >> the project has now grown and other developers are going to be using my
> >> code. I know that it is bad practice and I have learned my lesson, but
> >> any
> >> advice, other than its your own fault, would be most welcome. If I have
> >> to
> >> create my own add-in for the future, can anyone suggest how I can
> >> programatically find the start and end of a sub to add the suggested
> >> code?
> >>
> >> Thanks again.
> >>
> >> Alastair MacFarlane
> >>
> >
> > You can start with MZTools:
> > http://www.mztools.com/
> > Which has an excellent price of free.
> >
> > -ralph
> >

Also don't overlook the ability to create your own project, form, and class
templates. Create a good generic project and save it in...
C:\Program Files\Microsoft Visual Studio\Vb98\Template\Projects
Do the same for other items and place them in subdirectories.

Using a tool such as MZTools makes it a snap to change the names.

Visual Basic Template Manager Add-In:
http://vb.mvps.org/tools/Vb6ControlsAndComponents.asp

-ralph


 
 
Ralph





PostPosted: Sun Oct 23 08:35:22 CDT 2005 Top

Visual Basic >> Errors
"Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
news:%23$EMail@HideDomain.com...
> Thanks again Ralph,
>
> I have written a few add-ins for Office 2000 but never for the VB IDE.
Maybe
> I will look into it more seriously (only when I have more time). Maybe
next
> centuary! My wife argues that it is Sunday and I should spend some time
with
> her. Thanks for the support.
>
> Alastair MacFarlane
>
> p.s. Although I am tempted... no, I had better not!
>

It is NFL Sunday here, so my wife has long since learned to not make any
such unreasonable requests of my time. However, neither will any coding be
done today. <g>

-ralph



> "Ralph" <EMail@HideDomain.com> wrote in message
> news:EMail@HideDomain.com...
> >
> > "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
> > news:EMail@HideDomain.com...
> >> Thanks Ralph,
> >>
> >> I have heard it being mentioned on this group before but never looked
> >> into
> >> it. I will now. Thanks for your help.
> >>
> >> Alastair
> >>
> >>
> >> "Ralph" <EMail@HideDomain.com> wrote in message
> >> news:EMail@HideDomain.com...
> >> >
> >> > "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
> >> > news:uPL$EMail@HideDomain.com...
> >> >> Dear All,
> >> >>
> >> >> Does anyone know of a third party tool that can add error handling
> >> >> code
> >> >> to
> >> >> all subs/functions in a class or module to a specified format which
> > then
> >> > can
> >> >> be customised to deal with the errors likely to be raised at the
code?
> >> >>
> >> >> I have been neglectful in adding error handling code and comments as
I
> > go
> >> > as
> >> >> the project has now grown and other developers are going to be using
> >> >> my
> >> >> code. I know that it is bad practice and I have learned my lesson,
but
> >> >> any
> >> >> advice, other than its your own fault, would be most welcome. If I
> >> >> have
> >> >> to
> >> >> create my own add-in for the future, can anyone suggest how I can
> >> >> programatically find the start and end of a sub to add the suggested
> >> >> code?
> >> >>
> >> >> Thanks again.
> >> >>
> >> >> Alastair MacFarlane
> >> >>
> >> >
> >> > You can start with MZTools:
> >> > http://www.mztools.com/
> >> > Which has an excellent price of free.
> >> >
> >> > -ralph
> >> >
> >
> > I just now noticed that you want to write your 'own' Addins (too early
> > here,
> > only one cup of coffee, smile).
> >
> > [Warning: Opinion piece follows. <g>]
> > I used to write my own Addins, but got out of the habit because,
> > 1) they usually turn into non-trivial projects,
> > 2) documentation is scanty and MS documentation is often misleading or
> > just
> > plain wrong,
> > 3) it became easlier to use a 3rd party editor with 'macro' tools (I
used
> > CodeWright, but there are other better, less expensive ones, out there),
> > and
> > 4) you usually need to do a bit of final massage on the code (ie, OSFA
> > seldom applied) so attempting to write a 'fully' automated tool, often
> > saved
> > less time that imagined.
> >
> > Here is a little book that I found useful. (Surprised to find it still
> > available) The Extensibilty model changed a bit from VB5 - but most of
> > Microsoft's documentation errors were repeated with VB6, so this book is
> > very useful. It also tends to put everything in one place so you can
look
> > at
> > it as a whole.
> >
http://www.amazon.com/exec/obidos/ASIN/1576101673/gridlinxsoftware/102-6720874-9080925
> >
> > hope this helps,
> > -ralph
> >
> >
>
>


 
 
Alastair





PostPosted: Sun Oct 23 08:51:22 CDT 2005 Top

Visual Basic >> Errors Thanks Ralph,

I will check out the site of your link (and by the way the wife says Hi!!!).
It must be the same the Western World over!!!

Alastair

"Ralph" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
>
> "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
> news:EMail@HideDomain.com...
>> Thanks Ralph,
>>
>> I have heard it being mentioned on this group before but never looked
>> into
>> it. I will now. Thanks for your help.
>>
>> Alastair
>>
>>
>> "Ralph" <EMail@HideDomain.com> wrote in message
>> news:EMail@HideDomain.com...
>> >
>> > "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
>> > news:uPL$EMail@HideDomain.com...
>> >> Dear All,
>> >>
>> >> Does anyone know of a third party tool that can add error handling
>> >> code
>> >> to
>> >> all subs/functions in a class or module to a specified format which
> then
>> > can
>> >> be customised to deal with the errors likely to be raised at the code?
>> >>
>> >> I have been neglectful in adding error handling code and comments as I
> go
>> > as
>> >> the project has now grown and other developers are going to be using
>> >> my
>> >> code. I know that it is bad practice and I have learned my lesson, but
>> >> any
>> >> advice, other than its your own fault, would be most welcome. If I
>> >> have
>> >> to
>> >> create my own add-in for the future, can anyone suggest how I can
>> >> programatically find the start and end of a sub to add the suggested
>> >> code?
>> >>
>> >> Thanks again.
>> >>
>> >> Alastair MacFarlane
>> >>
>> >
>> > You can start with MZTools:
>> > http://www.mztools.com/
>> > Which has an excellent price of free.
>> >
>> > -ralph
>> >
>
> Also don't overlook the ability to create your own project, form, and
> class
> templates. Create a good generic project and save it in...
> C:\Program Files\Microsoft Visual Studio\Vb98\Template\Projects
> Do the same for other items and place them in subdirectories.
>
> Using a tool such as MZTools makes it a snap to change the names.
>
> Visual Basic Template Manager Add-In:
> http://vb.mvps.org/tools/Vb6ControlsAndComponents.asp
>
> -ralph
>
>


 
 
Que





PostPosted: Sun Oct 23 11:04:47 CDT 2005 Top

Visual Basic >> Errors Using MZTools, if you want your error message to look like this:

Form1:Form_Load:110
Error 5: Invalid procedure call or argument

Where 110 is the line number the error occurred on, then use the error
handler below, change as needed.

- Download and install MZTools:

http://www.mztools.com/v3/mztools3.htm

- Go to MZTools Options|Error Handler, and paste the following(unwrap as
needed):

On Error GoTo {PROCEDURE_NAME}_Error

{PROCEDURE_BODY}

ExitMe:
On Error GoTo 0
Exit {PROCEDURE_TYPE}
{PROCEDURE_NAME}_Error:
MsgBox "{MODULE_NAME}:{PROCEDURE_NAME}:" & ErL & vbCrLf & "Error " &
Err.Number & ": " & Err.Description
Resume ExitMe

- Go to every form and routine and add an error handler by clicking on the
icon on the tool bar. Add line numbers to each routines as well, which is
another button in MZTools toolbar.

Note that MZTools doesn't offer adding numbers to all routines in one step,
so you have to go to each routine and click on a toolbar button. You may
find Ctrl+DownArrow useful. Other Add-ins lets you do it for the whole
project. If you change your code and add lines, you have to redo it for that
procedure.

MZTools also doesn't change the routine name in the error handler if you
edited the sub/function name, so you either have to change it manually, or
click on the toolbar button to add a second error handler with the correct
name and delete the old one. If you prefer to make the error label with a
fixed name, just change "{PROCEDURE_NAME}_Error" to "ErrorHandler" above.





"Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
news:uPL$EMail@HideDomain.com...
> Dear All,
>
> Does anyone know of a third party tool that can add error handling code to
> all subs/functions in a class or module to a specified format which then
> can be customised to deal with the errors likely to be raised at the code?
>
> I have been neglectful in adding error handling code and comments as I go
> as the project has now grown and other developers are going to be using my
> code. I know that it is bad practice and I have learned my lesson, but any
> advice, other than its your own fault, would be most welcome. If I have to
> create my own add-in for the future, can anyone suggest how I can
> programatically find the start and end of a sub to add the suggested code?
>
> Thanks again.
>
> Alastair MacFarlane
>
>
>


 
 
Alastair





PostPosted: Sun Oct 23 12:12:38 CDT 2005 Top

Visual Basic >> Errors Thanks for the input Que,

I have downloade MZTools and will take into consideration your advice.
Thanks again.

Alastair MacFarlane


"Que" <EMail@HideDomain.com> wrote in message
news:OSx85t%EMail@HideDomain.com...
> Using MZTools, if you want your error message to look like this:
>
> Form1:Form_Load:110
> Error 5: Invalid procedure call or argument
>
> Where 110 is the line number the error occurred on, then use the error
> handler below, change as needed.
>
> - Download and install MZTools:
>
> http://www.mztools.com/v3/mztools3.htm
>
> - Go to MZTools Options|Error Handler, and paste the following(unwrap as
> needed):
>
> On Error GoTo {PROCEDURE_NAME}_Error
>
> {PROCEDURE_BODY}
>
> ExitMe:
> On Error GoTo 0
> Exit {PROCEDURE_TYPE}
> {PROCEDURE_NAME}_Error:
> MsgBox "{MODULE_NAME}:{PROCEDURE_NAME}:" & ErL & vbCrLf & "Error " &
> Err.Number & ": " & Err.Description
> Resume ExitMe
>
> - Go to every form and routine and add an error handler by clicking on the
> icon on the tool bar. Add line numbers to each routines as well, which is
> another button in MZTools toolbar.
>
> Note that MZTools doesn't offer adding numbers to all routines in one
> step, so you have to go to each routine and click on a toolbar button. You
> may find Ctrl+DownArrow useful. Other Add-ins lets you do it for the whole
> project. If you change your code and add lines, you have to redo it for
> that procedure.
>
> MZTools also doesn't change the routine name in the error handler if you
> edited the sub/function name, so you either have to change it manually, or
> click on the toolbar button to add a second error handler with the correct
> name and delete the old one. If you prefer to make the error label with a
> fixed name, just change "{PROCEDURE_NAME}_Error" to "ErrorHandler" above.
>
>
>
>
>
> "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
> news:uPL$EMail@HideDomain.com...
>> Dear All,
>>
>> Does anyone know of a third party tool that can add error handling code
>> to all subs/functions in a class or module to a specified format which
>> then can be customised to deal with the errors likely to be raised at the
>> code?
>>
>> I have been neglectful in adding error handling code and comments as I go
>> as the project has now grown and other developers are going to be using
>> my code. I know that it is bad practice and I have learned my lesson, but
>> any advice, other than its your own fault, would be most welcome. If I
>> have to create my own add-in for the future, can anyone suggest how I can
>> programatically find the start and end of a sub to add the suggested
>> code?
>>
>> Thanks again.
>>
>> Alastair MacFarlane
>>
>>
>>
>
>


 
 
Ken





PostPosted: Sun Oct 23 12:53:53 CDT 2005 Top

Visual Basic >> Errors "Alastair MacFarlane" <EMail@HideDomain.com> wrote in message
news:uPL$EMail@HideDomain.com...
> Dear All,
>
> Does anyone know of a third party tool that can add error handling code to
> all subs/functions in a class or module to a specified format which then
> can be customised to deal with the errors likely to be raised at the code?
>

Others mentioned MZTools... CodeSMART's another add-in that can do this but
it's not free.

Another option is VB Watch. It's a bit expensive but will make your app
nearly bullet proof, even against the good ol' Dr Watson, without changing
the source you're actually working on. It adds all required code during the
compile phase.

"Error messages can include: error description, procedure name, line number,
parameter and variable values, object properties, call stack, screenshot,
run-time library versions, and even execution trace procedure-by-procedure,
line-by-line. Have the users email all this info immediately when an error
happens. This is the fastest way to fix bugs ever discovered."

VB Watch Profiler, Protector, Debugger
http://www.aivosto.com/vbwatch.html


--
Ken Halter - MS-MVP-VB - http://www.vbsight.com
DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm
Please keep all discussions in the groups..


 
 
Ken





PostPosted: Sun Oct 23 13:03:45 CDT 2005 Top

Visual Basic >> Errors "Ken Halter" <EMail@HideDomain.com> wrote in message
news:uk8ZUn$EMail@HideDomain.com...
>
> It adds all required code during the compile phase.


Actually, it's been a while and I remember that it doesn't do it during the
compile phase. Instead, you click "the button" and it'll optionally create a
copy of the project that includes the required code. Either way, it's pretty
cool. (and pretty expensive)

--
Ken Halter - MS-MVP-VB - http://www.vbsight.com
DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm
Please keep all discussions in the groups..


 
 
Carlos





PostPosted: Mon Oct 31 07:37:33 CST 2005 Top

Visual Basic >> Errors "Que" <EMail@HideDomain.com> escribió en el mensaje
news:OSx85t%EMail@HideDomain.com...
> Note that MZTools doesn't offer adding numbers to all routines in one
> step, so you have to go to each routine and click on a toolbar button. You
> may find Ctrl+DownArrow useful. Other Add-ins lets you do it for the whole
> project.

MZ-Tools 3.0 allows to add line numbers to a whole project or file using the
proper context menu in the Project Explorer. I know it is not the most
intuitive thing, but it's explained in the help file and in the FAQ section
on the web site:

http://www.mztools.com/v3/faq.htm#LineNumbering

The user interface to select the scope of operations was improved in
MZ-Tools 4.0 for VS.NET.

You can´t add error handlers to all function with one click, though.

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com



 
 
Carlos





PostPosted: Mon Oct 31 07:45:49 CST 2005 Top

Visual Basic >> Errors I collected many resources for developers of add-ins for several hosts in a
section on my web site:

http://www.mztools.com/resources_addin_developers.htm

I was not aware of that book, I'll add it to the list tomorrow.

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com


"Ralph" <EMail@HideDomain.com> escribió en el mensaje
news:EMail@HideDomain.com...
> I just now noticed that you want to write your 'own' Addins (too early
> here,
> only one cup of coffee, smile).
>
> [Warning: Opinion piece follows. <g>]
> I used to write my own Addins, but got out of the habit because,
> 1) they usually turn into non-trivial projects,
> 2) documentation is scanty and MS documentation is often misleading or
> just
> plain wrong,
> 3) it became easlier to use a 3rd party editor with 'macro' tools (I used
> CodeWright, but there are other better, less expensive ones, out there),
> and
> 4) you usually need to do a bit of final massage on the code (ie, OSFA
> seldom applied) so attempting to write a 'fully' automated tool, often
> saved
> less time that imagined.
>
> Here is a little book that I found useful. (Surprised to find it still
> available) The Extensibilty model changed a bit from VB5 - but most of
> Microsoft's documentation errors were repeated with VB6, so this book is
> very useful. It also tends to put everything in one place so you can look
> at
> it as a whole.
> http://www.amazon.com/exec/obidos/ASIN/1576101673/gridlinxsoftware/102-6720874-9080925
>
> hope this helps,
> -ralph
>
>