show VBA source line numbers

Hi all,

does somebody know how I could get shown the source code
line numbers at the VBA editor? I can see the current line
where the cursor is but I would need every line numbered...

Thanks in advance and have a nice day!

Best regards

Markus

Markus

Download MZTools for VBA 3.0 from Quintero. A must have!
http://www.mztools.com/download/mztoolsvba.zip

Among MANY other options it does have the option
to set and remove linenumbering.

It's free, but I'm sure Carlos will appreciate
"incomings" on his PayPal account.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Markus Scheible wrote :

> Hi all,
>
> does somebody know how I could get shown the source code
> line numbers at the VBA editor? I can see the current line
> where the cursor is but I would need every line numbered...
>
> Thanks in advance and have a nice day!
>
> Best regards
>
> Markus

Hi unknown,

thanks for the tip, I already got the info about this
tool... unfortunately it is not allowed to install other
software at our computers - so is there no possibility to
get the line numbers without any extra tool?

TIA

Markus

>-----Original Message-----
>Markus
>
>Download MZTools for VBA 3.0 from Quintero. A must have!
>http://www.mztools.com/download/mztoolsvba.zip
>
>Among MANY other options it does have the option
>to set and remove linenumbering.
>
>It's free, but I'm sure Carlos will appreciate
>"incomings" on his PayPal account.
>
>
>--
>keepITcool
>| www.XLsupport.com | keepITcool chello nl | amsterdam
>
>
>Markus Scheible wrote :
>
>> Hi all,
>>
>> does somebody know how I could get shown the source
code
>> line numbers at the VBA editor? I can see the current
line
>> where the cursor is but I would need every line
numbered...
>>
>> Thanks in advance and have a nice day!
>>
>> Best regards
>>
>> Markus
>.
>

Markus,
i'm not that unknown here.. i go by the name keepITcool <g>

administrators... wont allow anything on user machines while at the
same time THEY run eDonkey on their own machines....

maybe it's not allowed.. but have they blocked it? The 'only' thing you
need to install MZtools is to be able to use regsvr32 to register the
DLL.


As an alternative you need to write /find a procedure for the line
numbering. Among the tons of tools I managed to unearth 1 code snippet
from Google...

From Bernie Deitrick (no less!):
http://xlbysteph.free.fr/aideinforma...oterlignes.txt

Are you allowed access to VBObject model?
Check Macro/Security/Trusted Sources there's a checkbox at the bottom.


hth...


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Markus Scheible wrote :

> Hi unknown,
>
> thanks for the tip, I already got the info about this
> tool... unfortunately it is not allowed to install other
> software at our computers - so is there no possibility to
> get the line numbers without any extra tool?
>
> TIA
>
> Markus
>
> > -----Original Message-----
> > Markus
> >
> > Download MZTools for VBA 3.0 from Quintero. A must have!
> > http://www.mztools.com/download/mztoolsvba.zip
> >
> > Among MANY other options it does have the option
> > to set and remove linenumbering.
> >
> > It's free, but I'm sure Carlos will appreciate
> > "incomings" on his PayPal account.
> >
> >
> > --
> > keepITcool
> > > www.XLsupport.com | keepITcool chello nl | amsterdam
> >
> >
> > Markus Scheible wrote :
> >
> >> Hi all,
> >>
> >> does somebody know how I could get shown the source
> code
> >> line numbers at the VBA editor? I can see the current
> line
> >> where the cursor is but I would need every line
> numbered...
> >>
> >> Thanks in advance and have a nice day!
> >>
> >> Best regards
> >>
> >> Markus
> > .
> >

Markus,
I've just had a look at the code from that link,..
but it's ratherr basic and probably not what you want.

Be VERY carefull running it...

I may attempt something of my own. I'll post back when I've something
worthwhile.





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


keepITcool wrote :

>
> Markus,
> i'm not that unknown here.. i go by the name keepITcool <g>
>
> administrators... wont allow anything on user machines while at the
> same time THEY run eDonkey on their own machines....
>
> maybe it's not allowed.. but have they blocked it? The 'only' thing
> you need to install MZtools is to be able to use regsvr32 to register
> the DLL.
>
>
> As an alternative you need to write /find a procedure for the line
> numbering. Among the tons of tools I managed to unearth 1 code snippet
> from Google...
>
> From Bernie Deitrick (no less!):
> http://xlbysteph.free.fr/aideinforma...oterlignes.txt
>
> Are you allowed access to VBObject model?
> Check Macro/Security/Trusted Sources there's a checkbox at the bottom.
>
>
> hth...
>
>
> --
> keepITcool
> > www.XLsupport.com | keepITcool chello nl | amsterdam
>
>
> Markus Scheible wrote :
>
> > Hi unknown,
> >
> > thanks for the tip, I already got the info about this
> > tool... unfortunately it is not allowed to install other
> > software at our computers - so is there no possibility to
> > get the line numbers without any extra tool?
> >
> > TIA
> >
> > Markus
> >
> > > -----Original Message-----
> > > Markus
> > >
> > > Download MZTools for VBA 3.0 from Quintero. A must have!
> > > http://www.mztools.com/download/mztoolsvba.zip
> > >
> > > Among MANY other options it does have the option
> > > to set and remove linenumbering.
> > >
> > > It's free, but I'm sure Carlos will appreciate
> > > "incomings" on his PayPal account.
> > >
> > >
> > > --
> > > keepITcool
> > > > www.XLsupport.com | keepITcool chello nl | amsterdam
> > >
> > >
> > > Markus Scheible wrote :
> > >
> > >> Hi all,
> > >>
> > >> does somebody know how I could get shown the source
> > code
> > >> line numbers at the VBA editor? I can see the current
> > line
> > >> where the cursor is but I would need every line
> > numbered...
> > >>
> > >> Thanks in advance and have a nice day!
> > >>
> > >> Best regards
> > >>
> > >> Markus
> > > .
> > >

Here is the entire thread from that exchange. There may be more to "mine"
there:

http://groups.google.co.uk/groups?hl...40consumer.org

--
Regards,
Tom Ogilvy


"keepITcool" <xrrcvgpbby@puryyb.ay> wrote in message
news:xn0dxpqbdd59luw004keepitcoolnl@msnews.microsoft.com...
>
> Markus,
> i'm not that unknown here.. i go by the name keepITcool <g>
>
> administrators... wont allow anything on user machines while at the
> same time THEY run eDonkey on their own machines....
>
> maybe it's not allowed.. but have they blocked it? The 'only' thing you
> need to install MZtools is to be able to use regsvr32 to register the
> DLL.
>
>
> As an alternative you need to write /find a procedure for the line
> numbering. Among the tons of tools I managed to unearth 1 code snippet
> from Google...
>
> From Bernie Deitrick (no less!):
> http://xlbysteph.free.fr/aideinforma...oterlignes.txt
>
> Are you allowed access to VBObject model?
> Check Macro/Security/Trusted Sources there's a checkbox at the bottom.
>
>
> hth...
>
>
> --
> keepITcool
> | www.XLsupport.com | keepITcool chello nl | amsterdam
>
>
> Markus Scheible wrote :
>
> > Hi unknown,
> >
> > thanks for the tip, I already got the info about this
> > tool... unfortunately it is not allowed to install other
> > software at our computers - so is there no possibility to
> > get the line numbers without any extra tool?
> >
> > TIA
> >
> > Markus
> >
> > > -----Original Message-----
> > > Markus
> > >
> > > Download MZTools for VBA 3.0 from Quintero. A must have!
> > > http://www.mztools.com/download/mztoolsvba.zip
> > >
> > > Among MANY other options it does have the option
> > > to set and remove linenumbering.
> > >
> > > It's free, but I'm sure Carlos will appreciate
> > > "incomings" on his PayPal account.
> > >
> > >
> > > --
> > > keepITcool
> > > > www.XLsupport.com | keepITcool chello nl | amsterdam
> > >
> > >
> > > Markus Scheible wrote :
> > >
> > >> Hi all,
> > >>
> > >> does somebody know how I could get shown the source
> > code
> > >> line numbers at the VBA editor? I can see the current
> > line
> > >> where the cursor is but I would need every line
> > numbered...
> > >>
> > >> Thanks in advance and have a nice day!
> > >>
> > >> Best regards
> > >>
> > >> Markus
> > > .
> > >

Tom,

thanks for that thread. Stephen Bullen's contribution there looks like
what I was in the process of building. (Process aborted now)

I do have MZtools anyway, but it looks to me as a logical xtra for
Stephen's smart indenter?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote :

> Here is the entire thread from that exchange. There may be more to
> "mine" there:
>
> http://groups.google.co.uk/groups?hl...4254.43D6A425%
> 40consumer.org

> thanks for the tip, I already got the info about this
> tool

Na toll. Jetzt wirf ihm vielleich noch vor, er hätte dein Crossprosting
gefälligst lesen sollen!



arno

Originally Posted by keepITcool

Markus

Download MZTools for VBA 3.0 from Quintero. A must have!

How can I install it without beeing admin?

I successfully extracted all files:

"app" folder:
MZTools3.chm
MZTools3vba.dll
MZTools3vbaToDeploy.dat
sample.xsl

"embedded" folder:
CompiledCode.bin
***.isl (language files)
WizardImage.bmp
WizardSmallImage.bmp


Now what?