Code snippet storage

[Ken McLennan]

G'day there One & All,

A quick query that may have been discussed herre, but that I'm
unaware of.

I was just wondering whether there was a plug in, or macro set, or
some form of addon that allows a user to store snippets of code to be
reused in later projects. I had in mind that in the VB Editor one could
assign macros to selected key combinations and just insert the desired
lines of code.

Is there any such thing? I know there are other IDE's and editors
that can do this sort of thing, but is there anything available for the
MS Editor that comes with Excel?

Or can you do that anyway but I've never found out how?

See ya
Thanks in advance,
Ken McLenan
Qld, Australia

 

[Amedee Van Gasse]

G'day there One & All,

A quick query that may have been discussed herre, but that I'm
unaware of.

I was just wondering whether there was a plug in, or macro set, or
some form of addon that allows a user to store snippets of code to be
reused in later projects. I had in mind that in the VB Editor one
could assign macros to selected key combinations and just insert the
desired lines of code.

Is there any such thing? I know there are other IDE's and editors
that can do this sort of thing, but is there anything available for
the MS Editor that comes with Excel?

Or can you do that anyway but I've never found out how?

See ya
Thanks in advance,
Ken McLenan
Qld, Australia

If you use OOP using Class modules, you can re-use these objects.

 

[Tom Ogilvy]

Nothing in the VB editor in Excel that supports this requirement. That
said, you could probably program something to do it. The developer version
of excel include Microsoft scode librarian software.

http://msdn.microsoft.com/library/d...n-us/modcore/html/deoriusingcodelibrarian.asp

 

[Ken McLennan]

G'day there Tom,

Nothing in the VB editor in Excel that supports this requirement. That

Sigh... I was afraid that would be the case.

said, you could probably program something to do it. The developer version
of excel include Microsoft scode librarian software.

Unfortunately, I don't have access to that version. Nor do I have
the skill to write such a thing. I guess I'll just have to make do with
the old "cut & paste".

See ya,
thanks for answering
Ken McLennan
Qld, Australia

 

[Ken McLennan]

G'day there Amedee,

If you use OOP using Class modules, you can re-use these objects.

I'm still working on that. I understand the concept from the
little I've read of Python, but I've yet to do anything with VB classes
in Excel. I've not needed to really, none of my projects were of such a
nature that it was desirable. That will be changing shortly, as I've got
a couple of biggies I've been asked to work on in the office. (I'm not
an XL guru, just an enthusiast who's prepared to do it in his own time
for no money <g> ).

See ya
Ken McLennan
Qld, Australia

 

[CJM]

Have a look at the mztools VBE add-in (https://www.mztools.com). One of
the features it provides is the ability to store code templates, and
assign shortcut keys to the templates for quick insertion. Sounds like
the sort of thing you're after, and it provides a truckload of other
really useful functionality.

Regards,

CJM

 

[Tom Ogilvy]

I don't believe it is on a secure server, so the url is

http://www.mztools.com/

and for the OP, it is free, so if that meets your needs, good choice.

 

[CJM]

Yeah, disregard the URL I had, typo on my part. Cheers Tom.

CJM

 

[Ken McLennan]

G'day there CJM,

Have a look at the mztools VBE add-in (https://www.mztools.com). One of
the features it provides is the ability to store code templates, and
assign shortcut keys to the templates for quick insertion. Sounds like
the sort of thing you're after, and it provides a truckload of other
really useful functionality.

Thanks very muchly for that. It certainly does sound like what I'm
after. So much like it that I now have it installed and it's lookin'
goooood...

Hmm... crappy accent there. Be that as it may, I'm going to spend
the weekend playing with the addin. There seems to be more there than I
need, but useful stuff that I hadn't thought of. The office can just
wait a few more days for their spreadsheet. After all, they've managed
this long without it. A few more days won't hurt =).

See ya,
and thanks very much again
See ya
Ken McLennan
Qld, Australia

 

[Ken McLennan]

G'day there Tom,

I don't believe it is on a secure server, so the url is

http://www.mztools.com/

and for the OP, it is free, so if that meets your needs, good choice.

Quite correct. That's exactly where it is. Downloaded without a
problem, installed without a hitch and is now working fine. As I said to
CJM, I'll play with it over the weekend and get to work afterwards =).

Thanks for your assistance, it's greatly appreciated.

BTW, MZTools looks like a great piece of kit. I'm sure it will be
indispensible within a short time.

See ya
Ken McLennan
Qld, Australia