Parse VB/VBA Code

**Tom van Stiphout** · Nov 12 '05, 03:15 PM

Re: Parse VB/VBA Code

On Sun, 12 Oct 2003 11:47:26 +0300, "Illya Havsiyevych"
<gavsi@ukr.ne t> wrote:

Perhaps you are referring to the Eval function?
-Tom.

[color=blue]
>Hello
>
>How easily parse VB/VBA code by VB/VBA code ?
>Is any ready solutions ?
>
>Thank's,
>illya
>[/color]

TC · Nov 12 '05, 03:16 PM

Re: Parse VB/VBA Code

What are you trying to achieve?

TC

"Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
news:bmb41d$2sf 6$1@news.wnet.u a...[color=blue]
> Hello
>
> How easily parse VB/VBA code by VB/VBA code ?
> Is any ready solutions ?
>
> Thank's,
> illya[/color]

**Illya Havsiyevych** · Nov 12 '05, 03:17 PM

Re: Parse VB/VBA Code

hi

I'm trying to parse VBA code like compiler do
Than export function/sub declaration (aka prototype) to xml together with
comments to be ready to auto generate HTML help files for VBA/VB code
modules.

For now I'm using all functions from VBIDE.CodeModul e Object.
Have some progress. Can send current

illya

"TC" <a@b.c.d> wrote in message news:1066039150 .717984@teuthos ...[color=blue]
> What are you trying to achieve?
>
> TC
>
>
> "Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
> news:bmb41d$2sf 6$1@news.wnet.u a...[color=green]
> > Hello
> >
> > How easily parse VB/VBA code by VB/VBA code ?
> > Is any ready solutions ?
> >
> > Thank's,
> > illya[/color]
>
>
>[/color]

**Steve Jorgensen** · Nov 12 '05, 03:17 PM

Re: Parse VB/VBA Code

I have just done some research on this subject, and it turns out that to do
it right, you need to buy a license for VBA integration. This is the only
way to get the DLLs that give you access to the same information that
AutoSense has. Without that, you can theoretically do what you want (as
you have started to do), but it's up to you to pares everything correctly
such determining as what's a comment (did you know a comment can line-wrap
with " _"?). Also, if you want to know where a reference such as a
function call is resolved (other UDF, external library, VB key word, etc.)
....

I haven't checked the price on the VBA integration license yet, but I
assume it's not cheap.

On Mon, 13 Oct 2003 19:07:40 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
wrote:
[color=blue]
>hi
>
>I'm trying to parse VBA code like compiler do
>Than export function/sub declaration (aka prototype) to xml together with
>comments to be ready to auto generate HTML help files for VBA/VB code
>modules.
>
>For now I'm using all functions from VBIDE.CodeModul e Object.
>Have some progress. Can send current
>
>illya
>
>"TC" <a@b.c.d> wrote in message news:1066039150 .717984@teuthos ...[color=green]
>> What are you trying to achieve?
>>
>> TC
>>
>>
>> "Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
>> news:bmb41d$2sf 6$1@news.wnet.u a...[color=darkred]
>> > Hello
>> >
>> > How easily parse VB/VBA code by VB/VBA code ?
>> > Is any ready solutions ?
>> >
>> > Thank's,
>> > illya[/color]
>>
>>
>>[/color]
>[/color]

**Illya Havsiyevych** · Nov 12 '05, 03:17 PM

Re: Parse VB/VBA Code

Hello

Thank You for Your comments.
But I'm not going to buy this license.
Also I'm not going to parse all code -
just procedure declarations block with previous attached comments
to export them into XML and then auto generate HTML help :)

'_' is not a problem just need to find <space>_

A lot of function from VBIDE.CodeModul e are used

I'm using some my own spec for comments and I'm parsing code according to my
spec by using only VBA code.

Format
=====
<Comments>
<Property?Funct ion?Sub Declaration>

Comments
========
'Context ID: value

'Desc Line 1

'Desc Line 2

'...

'Desc Line N

'

'Parameters:

'===========

'Param 1 - one line desc

'Param 2 - one line desc

'...

'Param N - one line desc

'

'Return Values:

'==============

'value 1 - one line desc

'value 2 - one line desc

'...

'value N - one line desc

'

'Remarks:

'========

'Remarks Line 1

'Remarks Line 2

'...

'Remarks Line N

comments to comments
=============== =
Each comment line start from ', No Rem is possible.
Empty Lines inside comments block are possible but ignored
No Mandatory
Words Context ID Parameters, Return Values, Remarks are reserved.
No comments at line where Parameters, Return Values, Remarks are possible.
Lines with '======== or '-------- are ignored.

Procedure Declaration
=============== =
[Public|Private| Friend]
Property Get?Property Let?Property Set?Function?Su b
name ([ArgList]) [as ReturnType]

"Steve Jorgensen" <nospam@nospam. nospam> wrote in message
news:28mlov8kq7 cp5g0neo5ep7rae r3r7v5mgq@4ax.c om...[color=blue]
> I have just done some research on this subject, and it turns out that to[/color]
do[color=blue]
> it right, you need to buy a license for VBA integration. This is the only
> way to get the DLLs that give you access to the same information that
> AutoSense has. Without that, you can theoretically do what you want (as
> you have started to do), but it's up to you to pares everything correctly
> such determining as what's a comment (did you know a comment can line-wrap
> with " _"?). Also, if you want to know where a reference such as a
> function call is resolved (other UDF, external library, VB key word, etc.)
> ...
>
> I haven't checked the price on the VBA integration license yet, but I
> assume it's not cheap.
>
> On Mon, 13 Oct 2003 19:07:40 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
> wrote:
>[color=green]
> >hi
> >
> >I'm trying to parse VBA code like compiler do
> >Than export function/sub declaration (aka prototype) to xml together with
> >comments to be ready to auto generate HTML help files for VBA/VB code
> >modules.
> >
> >For now I'm using all functions from VBIDE.CodeModul e Object.
> >Have some progress. Can send current
> >
> >illya
> >
> >"TC" <a@b.c.d> wrote in message news:1066039150 .717984@teuthos ...[color=darkred]
> >> What are you trying to achieve?
> >>
> >> TC
> >>
> >>
> >> "Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
> >> news:bmb41d$2sf 6$1@news.wnet.u a...
> >> > Hello
> >> >
> >> > How easily parse VB/VBA code by VB/VBA code ?
> >> > Is any ready solutions ?
> >> >
> >> > Thank's,
> >> > illya
> >>
> >>
> >>[/color]
> >[/color]
>[/color]

**Steve Jorgensen** · Nov 12 '05, 03:17 PM

Re: Parse VB/VBA Code

On Mon, 13 Oct 2003 20:42:22 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
wrote:
[color=blue]
>Hello
>
>Thank You for Your comments.
>But I'm not going to buy this license.
>Also I'm not going to parse all code -
>just procedure declarations block with previous attached comments
>to export them into XML and then auto generate HTML help :)
>
>'_' is not a problem just need to find <space>_[/color]

Well, I brought this up as one example of something that you might not know
and get wrong that the integration components would handle correctly. I'm
sure there are other strange cases that neither you or I are aware of, and
these will result in bugs the first time your code encounters them. Still,
I'm sure you can probably get close enough for most code just parsing the
text. VBIDE does (as I'm guessing you know) get you as far as telling you
where the code for each procedure starts and ends which is a big help.

**Randy Harris** · Nov 12 '05, 03:17 PM

Re: Parse VB/VBA Code

If I may ask, sir. Where does VBIDE.CodeModul e come from?

"Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
news:bmeo6l$21l t$1@news.wnet.u a...[color=blue]
> Hello
>
> Thank You for Your comments.
> But I'm not going to buy this license.
> Also I'm not going to parse all code -
> just procedure declarations block with previous attached comments
> to export them into XML and then auto generate HTML help :)
>
> '_' is not a problem just need to find <space>_
>
> A lot of function from VBIDE.CodeModul e are used
>
> I'm using some my own spec for comments and I'm parsing code according to[/color]
my[color=blue]
> spec by using only VBA code.
>
>
> Format
> =====
> <Comments>
> <Property?Funct ion?Sub Declaration>
>
> Comments
> ========
> 'Context ID: value
>
> 'Desc Line 1
>
> 'Desc Line 2
>
> '...
>
> 'Desc Line N
>
> '
>
> 'Parameters:
>
> '===========
>
> 'Param 1 - one line desc
>
> 'Param 2 - one line desc
>
> '...
>
> 'Param N - one line desc
>
> '
>
> 'Return Values:
>
> '==============
>
> 'value 1 - one line desc
>
> 'value 2 - one line desc
>
> '...
>
> 'value N - one line desc
>
> '
>
> 'Remarks:
>
> '========
>
> 'Remarks Line 1
>
> 'Remarks Line 2
>
> '...
>
> 'Remarks Line N
>
>
> comments to comments
> =============== =
> Each comment line start from ', No Rem is possible.
> Empty Lines inside comments block are possible but ignored
> No Mandatory
> Words Context ID Parameters, Return Values, Remarks are reserved.
> No comments at line where Parameters, Return Values, Remarks are possible.
> Lines with '======== or '-------- are ignored.
>
>
> Procedure Declaration
> =============== =
> [Public|Private| Friend]
> Property Get?Property Let?Property Set?Function?Su b
> name ([ArgList]) [as ReturnType]
>
>
>
>
> "Steve Jorgensen" <nospam@nospam. nospam> wrote in message
> news:28mlov8kq7 cp5g0neo5ep7rae r3r7v5mgq@4ax.c om...[color=green]
> > I have just done some research on this subject, and it turns out that to[/color][/color]
[color=blue]
> do[color=green]
> > it right, you need to buy a license for VBA integration. This is the[/color][/color]
only[color=blue][color=green]
> > way to get the DLLs that give you access to the same information that
> > AutoSense has. Without that, you can theoretically do what you want (as
> > you have started to do), but it's up to you to pares everything[/color][/color]
correctly[color=blue][color=green]
> > such determining as what's a comment (did you know a comment can[/color][/color]
line-wrap[color=blue][color=green]
> > with " _"?). Also, if you want to know where a reference such as a
> > function call is resolved (other UDF, external library, VB key word,[/color][/color]
etc.)[color=blue][color=green]
> > ...
> >
> > I haven't checked the price on the VBA integration license yet, but I
> > assume it's not cheap.
> >
> > On Mon, 13 Oct 2003 19:07:40 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
> > wrote:
> >[color=darkred]
> > >hi
> > >
> > >I'm trying to parse VBA code like compiler do
> > >Than export function/sub declaration (aka prototype) to xml together[/color][/color][/color]
with[color=blue][color=green][color=darkred]
> > >comments to be ready to auto generate HTML help files for VBA/VB code
> > >modules.
> > >
> > >For now I'm using all functions from VBIDE.CodeModul e Object.
> > >Have some progress. Can send current
> > >
> > >illya
> > >
> > >"TC" <a@b.c.d> wrote in message news:1066039150 .717984@teuthos ...
> > >> What are you trying to achieve?
> > >>
> > >> TC
> > >>
> > >>
> > >> "Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
> > >> news:bmb41d$2sf 6$1@news.wnet.u a...
> > >> > Hello
> > >> >
> > >> > How easily parse VB/VBA code by VB/VBA code ?
> > >> > Is any ready solutions ?
> > >> >
> > >> > Thank's,
> > >> > illya
> > >>
> > >>
> > >>
> > >[/color]
> >[/color]
>
>
>
>[/color]

**Steve Jorgensen** · Nov 12 '05, 03:17 PM

Re: Parse VB/VBA Code

It is installed with MS Office, and it appears under Tools -> References as
"Microsoft Visual Basic for Applications Extensibility 5.3. If you check
that reference, VBIDE references are available from your code.

On Mon, 13 Oct 2003 18:00:28 GMT, "Randy Harris" <randy@SpamFree .com>
wrote:
[color=blue]
>If I may ask, sir. Where does VBIDE.CodeModul e come from?[/color]

**Illya Havsiyevych** · Nov 12 '05, 03:17 PM

Re: Parse VB/VBA Code

Hello

Yes, You are right here.
You can take a look into what I have
Of course If You wish

Thank's again
illya

"Steve Jorgensen" <nospam@nospam. nospam> wrote in message
news:a1qlovsc3l 50snq1qsvnr26pd 82l8dv8o5@4ax.c om...[color=blue]
> On Mon, 13 Oct 2003 20:42:22 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
> wrote:
>[color=green]
> >Hello
> >
> >Thank You for Your comments.
> >But I'm not going to buy this license.
> >Also I'm not going to parse all code -
> >just procedure declarations block with previous attached comments
> >to export them into XML and then auto generate HTML help :)
> >
> >'_' is not a problem just need to find <space>_[/color]
>
> Well, I brought this up as one example of something that you might not[/color]
know[color=blue]
> and get wrong that the integration components would handle correctly. I'm
> sure there are other strange cases that neither you or I are aware of, and
> these will result in bugs the first time your code encounters them.[/color]
Still,[color=blue]
> I'm sure you can probably get close enough for most code just parsing the
> text. VBIDE does (as I'm guessing you know) get you as far as telling you
> where the code for each procedure starts and ends which is a big help.
>[/color]

**Steve Jorgensen** · Nov 12 '05, 03:17 PM

Re: Parse VB/VBA Code

I'm pleased you are willing to share your code, and I'm anxious to take a
look at it, but this group does not allow binary attachments. If you can
put this in a Web site, and post a link, that would be a better way of
generously sharing your code.

On Mon, 13 Oct 2003 21:50:01 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
wrote:
[color=blue]
>this message also posted as
>HTML Help Tool - Draft
>============== ====
>
>
>Hello All
>
>Here is draft of HTML Help tool as Access AddIn
>Tested with Access 2000, XP on Win2k and XP
>
>Install
>====
>1) Put all from To_ProgramFiles _MicrosoftOffic e_Office.zip
>into c:\Program Files\Microsoft Office\Office
>
>CTHELPPARSE.md e - VBA Code parse library
>CTHELPXML.md e - XML create/parse library
>CTUTIL.mde - utilities library
>vbahelp.xsd - XML Scheme for output XML
>
>2) Put all from To_AddIn.zip to Access AddIn Folder
>I have it as c:\Documents and Settings\Admini strator.COMP\Ap plication
>Data\Microsoft \AddIns
>
>CTHELPADDIN.md e - Access AddIn
>
>3) Start Access. GoTo Tools->Add-Ins->Add-In Manager
>Install CTHELPADDIN AddIn
>
>4) Open Any mdb maybe with comments like in Spec
>and try to use AddIn
>
>Format
>=====
><Comments>
><Property/Function/Sub Declaration>
>
>Comments
>========
>'Context ID: value
>'Desc Line 1
>'Desc Line 2
>'...
>'Desc Line N
>'
>'Parameters:
>'===========
>'Param 1 - one line desc
>'Param 2 - one line desc
>'...
>'Param N - one line desc
>'
>'Return Values:
>'============= =
>'value 1 - one line desc
>'value 2 - one line desc
>'...
>'value N - one line desc
>'
>'Remarks:
>'========
>'Remarks Line 1
>'Remarks Line 2
>'...
>'Remarks Line N
>
>comments to comments
>============== ==
>Each comment line start from ', No Rem is possible.
>Empty Lines inside comments block are possible but ignored
>No Mandatory
>Words Context ID Parameters, Return Values, Remarks are reserved.
>No comments at line where Parameters, Return Values, Remarks are possible.
>Lines with '======== or '-------- are ignored.
>
>
>Thanks
>illya
>
>"Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
>news:bmeo6l$21 lt$1@news.wnet. ua...[color=green]
>> Hello
>>
>> Thank You for Your comments.
>> But I'm not going to buy this license.
>> Also I'm not going to parse all code -
>> just procedure declarations block with previous attached comments
>> to export them into XML and then auto generate HTML help :)
>>
>> '_' is not a problem just need to find <space>_
>>
>> A lot of function from VBIDE.CodeModul e are used
>>
>> I'm using some my own spec for comments and I'm parsing code according to[/color]
>my[color=green]
>> spec by using only VBA code.
>>
>>
>> Format
>> =====
>> <Comments>
>> <Property?Funct ion?Sub Declaration>
>>
>> Comments
>> ========
>> 'Context ID: value
>>
>> 'Desc Line 1
>>
>> 'Desc Line 2
>>
>> '...
>>
>> 'Desc Line N
>>
>> '
>>
>> 'Parameters:
>>
>> '===========
>>
>> 'Param 1 - one line desc
>>
>> 'Param 2 - one line desc
>>
>> '...
>>
>> 'Param N - one line desc
>>
>> '
>>
>> 'Return Values:
>>
>> '==============
>>
>> 'value 1 - one line desc
>>
>> 'value 2 - one line desc
>>
>> '...
>>
>> 'value N - one line desc
>>
>> '
>>
>> 'Remarks:
>>
>> '========
>>
>> 'Remarks Line 1
>>
>> 'Remarks Line 2
>>
>> '...
>>
>> 'Remarks Line N
>>
>>
>> comments to comments
>> =============== =
>> Each comment line start from ', No Rem is possible.
>> Empty Lines inside comments block are possible but ignored
>> No Mandatory
>> Words Context ID Parameters, Return Values, Remarks are reserved.
>> No comments at line where Parameters, Return Values, Remarks are possible.
>> Lines with '======== or '-------- are ignored.
>>
>>
>> Procedure Declaration
>> =============== =
>> [Public|Private| Friend]
>> Property Get?Property Let?Property Set?Function?Su b
>> name ([ArgList]) [as ReturnType]
>>
>>
>>
>>
>> "Steve Jorgensen" <nospam@nospam. nospam> wrote in message
>> news:28mlov8kq7 cp5g0neo5ep7rae r3r7v5mgq@4ax.c om...[color=darkred]
>> > I have just done some research on this subject, and it turns out that to[/color]
>> do[color=darkred]
>> > it right, you need to buy a license for VBA integration. This is the[/color][/color]
>only[color=green][color=darkred]
>> > way to get the DLLs that give you access to the same information that
>> > AutoSense has. Without that, you can theoretically do what you want (as
>> > you have started to do), but it's up to you to pares everything[/color][/color]
>correctly[color=green][color=darkred]
>> > such determining as what's a comment (did you know a comment can[/color][/color]
>line-wrap[color=green][color=darkred]
>> > with " _"?). Also, if you want to know where a reference such as a
>> > function call is resolved (other UDF, external library, VB key word,[/color][/color]
>etc.)[color=green][color=darkred]
>> > ...
>> >
>> > I haven't checked the price on the VBA integration license yet, but I
>> > assume it's not cheap.
>> >
>> > On Mon, 13 Oct 2003 19:07:40 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
>> > wrote:
>> >
>> > >hi
>> > >
>> > >I'm trying to parse VBA code like compiler do
>> > >Than export function/sub declaration (aka prototype) to xml together[/color][/color]
>with[color=green][color=darkred]
>> > >comments to be ready to auto generate HTML help files for VBA/VB code
>> > >modules.
>> > >
>> > >For now I'm using all functions from VBIDE.CodeModul e Object.
>> > >Have some progress. Can send current
>> > >
>> > >illya
>> > >
>> > >"TC" <a@b.c.d> wrote in message news:1066039150 .717984@teuthos ...
>> > >> What are you trying to achieve?
>> > >>
>> > >> TC
>> > >>
>> > >>
>> > >> "Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
>> > >> news:bmb41d$2sf 6$1@news.wnet.u a...
>> > >> > Hello
>> > >> >
>> > >> > How easily parse VB/VBA code by VB/VBA code ?
>> > >> > Is any ready solutions ?
>> > >> >
>> > >> > Thank's,
>> > >> > illya
>> > >>
>> > >>
>> > >>
>> > >
>> >[/color]
>>
>>
>>
>>[/color]
>
>[/color]

**Illya Havsiyevych** · Nov 12 '05, 03:18 PM

Re: Parse VB/VBA Code

will try a little bit later
Do You know not very bad free hosting ?

"Steve Jorgensen" <nospam@nospam. nospam> wrote in message
news:ht1mov04h3 vvhv2moj3sqi2no lb6ch07ei@4ax.c om...[color=blue]
> I'm pleased you are willing to share your code, and I'm anxious to take a
> look at it, but this group does not allow binary attachments. If you can
> put this in a Web site, and post a link, that would be a better way of
> generously sharing your code.
>
> On Mon, 13 Oct 2003 21:50:01 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
> wrote:
>[color=green]
> >this message also posted as
> >HTML Help Tool - Draft
> >============== ====
> >
> >
> >Hello All
> >
> >Here is draft of HTML Help tool as Access AddIn
> >Tested with Access 2000, XP on Win2k and XP
> >
> >Install
> >====
> >1) Put all from To_ProgramFiles _MicrosoftOffic e_Office.zip
> >into c:\Program Files\Microsoft Office\Office
> >
> >CTHELPPARSE.md e - VBA Code parse library
> >CTHELPXML.md e - XML create/parse library
> >CTUTIL.mde - utilities library
> >vbahelp.xsd - XML Scheme for output XML
> >
> >2) Put all from To_AddIn.zip to Access AddIn Folder
> >I have it as c:\Documents and Settings\Admini strator.COMP\Ap plication
> >Data\Microsoft \AddIns
> >
> >CTHELPADDIN.md e - Access AddIn
> >
> >3) Start Access. GoTo Tools->Add-Ins->Add-In Manager
> >Install CTHELPADDIN AddIn
> >
> >4) Open Any mdb maybe with comments like in Spec
> >and try to use AddIn
> >
> >Format
> >=====
> ><Comments>
> ><Property/Function/Sub Declaration>
> >
> >Comments
> >========
> >'Context ID: value
> >'Desc Line 1
> >'Desc Line 2
> >'...
> >'Desc Line N
> >'
> >'Parameters:
> >'===========
> >'Param 1 - one line desc
> >'Param 2 - one line desc
> >'...
> >'Param N - one line desc
> >'
> >'Return Values:
> >'============= =
> >'value 1 - one line desc
> >'value 2 - one line desc
> >'...
> >'value N - one line desc
> >'
> >'Remarks:
> >'========
> >'Remarks Line 1
> >'Remarks Line 2
> >'...
> >'Remarks Line N
> >
> >comments to comments
> >============== ==
> >Each comment line start from ', No Rem is possible.
> >Empty Lines inside comments block are possible but ignored
> >No Mandatory
> >Words Context ID Parameters, Return Values, Remarks are reserved.
> >No comments at line where Parameters, Return Values, Remarks are[/color][/color]
possible.[color=blue][color=green]
> >Lines with '======== or '-------- are ignored.
> >
> >
> >Thanks
> >illya
> >
> >"Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
> >news:bmeo6l$21 lt$1@news.wnet. ua...[color=darkred]
> >> Hello
> >>
> >> Thank You for Your comments.
> >> But I'm not going to buy this license.
> >> Also I'm not going to parse all code -
> >> just procedure declarations block with previous attached comments
> >> to export them into XML and then auto generate HTML help :)
> >>
> >> '_' is not a problem just need to find <space>_
> >>
> >> A lot of function from VBIDE.CodeModul e are used
> >>
> >> I'm using some my own spec for comments and I'm parsing code according[/color][/color][/color]
to[color=blue][color=green]
> >my[color=darkred]
> >> spec by using only VBA code.
> >>
> >>
> >> Format
> >> =====
> >> <Comments>
> >> <Property?Funct ion?Sub Declaration>
> >>
> >> Comments
> >> ========
> >> 'Context ID: value
> >>
> >> 'Desc Line 1
> >>
> >> 'Desc Line 2
> >>
> >> '...
> >>
> >> 'Desc Line N
> >>
> >> '
> >>
> >> 'Parameters:
> >>
> >> '===========
> >>
> >> 'Param 1 - one line desc
> >>
> >> 'Param 2 - one line desc
> >>
> >> '...
> >>
> >> 'Param N - one line desc
> >>
> >> '
> >>
> >> 'Return Values:
> >>
> >> '==============
> >>
> >> 'value 1 - one line desc
> >>
> >> 'value 2 - one line desc
> >>
> >> '...
> >>
> >> 'value N - one line desc
> >>
> >> '
> >>
> >> 'Remarks:
> >>
> >> '========
> >>
> >> 'Remarks Line 1
> >>
> >> 'Remarks Line 2
> >>
> >> '...
> >>
> >> 'Remarks Line N
> >>
> >>
> >> comments to comments
> >> =============== =
> >> Each comment line start from ', No Rem is possible.
> >> Empty Lines inside comments block are possible but ignored
> >> No Mandatory
> >> Words Context ID Parameters, Return Values, Remarks are reserved.
> >> No comments at line where Parameters, Return Values, Remarks are[/color][/color][/color]
possible.[color=blue][color=green][color=darkred]
> >> Lines with '======== or '-------- are ignored.
> >>
> >>
> >> Procedure Declaration
> >> =============== =
> >> [Public|Private| Friend]
> >> Property Get?Property Let?Property Set?Function?Su b
> >> name ([ArgList]) [as ReturnType]
> >>
> >>
> >>
> >>
> >> "Steve Jorgensen" <nospam@nospam. nospam> wrote in message
> >> news:28mlov8kq7 cp5g0neo5ep7rae r3r7v5mgq@4ax.c om...
> >> > I have just done some research on this subject, and it turns out that[/color][/color][/color]
to[color=blue][color=green][color=darkred]
> >> do
> >> > it right, you need to buy a license for VBA integration. This is the[/color]
> >only[color=darkred]
> >> > way to get the DLLs that give you access to the same information that
> >> > AutoSense has. Without that, you can theoretically do what you want[/color][/color][/color]
(as[color=blue][color=green][color=darkred]
> >> > you have started to do), but it's up to you to pares everything[/color]
> >correctly[color=darkred]
> >> > such determining as what's a comment (did you know a comment can[/color]
> >line-wrap[color=darkred]
> >> > with " _"?). Also, if you want to know where a reference such as a
> >> > function call is resolved (other UDF, external library, VB key word,[/color]
> >etc.)[color=darkred]
> >> > ...
> >> >
> >> > I haven't checked the price on the VBA integration license yet, but I
> >> > assume it's not cheap.
> >> >
> >> > On Mon, 13 Oct 2003 19:07:40 +0300, "Illya Havsiyevych"[/color][/color][/color]
<gavsi@ukr.ne t>[color=blue][color=green][color=darkred]
> >> > wrote:
> >> >
> >> > >hi
> >> > >
> >> > >I'm trying to parse VBA code like compiler do
> >> > >Than export function/sub declaration (aka prototype) to xml together[/color]
> >with[color=darkred]
> >> > >comments to be ready to auto generate HTML help files for VBA/VB[/color][/color][/color]
code[color=blue][color=green][color=darkred]
> >> > >modules.
> >> > >
> >> > >For now I'm using all functions from VBIDE.CodeModul e Object.
> >> > >Have some progress. Can send current
> >> > >
> >> > >illya
> >> > >
> >> > >"TC" <a@b.c.d> wrote in message news:1066039150 .717984@teuthos ...
> >> > >> What are you trying to achieve?
> >> > >>
> >> > >> TC
> >> > >>
> >> > >>
> >> > >> "Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
> >> > >> news:bmb41d$2sf 6$1@news.wnet.u a...
> >> > >> > Hello
> >> > >> >
> >> > >> > How easily parse VB/VBA code by VB/VBA code ?
> >> > >> > Is any ready solutions ?
> >> > >> >
> >> > >> > Thank's,
> >> > >> > illya
> >> > >>
> >> > >>
> >> > >>
> >> > >
> >> >
> >>
> >>
> >>
> >>[/color]
> >
> >[/color]
>[/color]

**Steve Jorgensen** · Nov 12 '05, 03:19 PM

Re: Parse VB/VBA Code

I'm not familliar with any free hosing, but most non-free internet accounts
come with a modest Web hosting space already in the deal. It's unually at
www.<your-provider>.com/~<yourusername> , and you can usually upload to it
by logging in to <yourusername>: <youremailpassw ord>@ftp.<yourp rovider>.com.

Or - if your code is under an open source license, you can host it for free
at sourceforge.net .

On Tue, 14 Oct 2003 11:21:25 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
wrote:
[color=blue]
>will try a little bit later
>Do You know not very bad free hosting ?
>
>"Steve Jorgensen" <nospam@nospam. nospam> wrote in message
>news:ht1mov04h 3vvhv2moj3sqi2n olb6ch07ei@4ax. com...[color=green]
>> I'm pleased you are willing to share your code, and I'm anxious to take a
>> look at it, but this group does not allow binary attachments. If you can
>> put this in a Web site, and post a link, that would be a better way of
>> generously sharing your code.
>>
>> On Mon, 13 Oct 2003 21:50:01 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
>> wrote:
>>[color=darkred]
>> >this message also posted as
>> >HTML Help Tool - Draft
>> >============== ====
>> >
>> >
>> >Hello All
>> >
>> >Here is draft of HTML Help tool as Access AddIn
>> >Tested with Access 2000, XP on Win2k and XP
>> >
>> >Install
>> >====
>> >1) Put all from To_ProgramFiles _MicrosoftOffic e_Office.zip
>> >into c:\Program Files\Microsoft Office\Office
>> >
>> >CTHELPPARSE.md e - VBA Code parse library
>> >CTHELPXML.md e - XML create/parse library
>> >CTUTIL.mde - utilities library
>> >vbahelp.xsd - XML Scheme for output XML
>> >
>> >2) Put all from To_AddIn.zip to Access AddIn Folder
>> >I have it as c:\Documents and Settings\Admini strator.COMP\Ap plication
>> >Data\Microsoft \AddIns
>> >
>> >CTHELPADDIN.md e - Access AddIn
>> >
>> >3) Start Access. GoTo Tools->Add-Ins->Add-In Manager
>> >Install CTHELPADDIN AddIn
>> >
>> >4) Open Any mdb maybe with comments like in Spec
>> >and try to use AddIn
>> >
>> >Format
>> >=====
>> ><Comments>
>> ><Property/Function/Sub Declaration>
>> >
>> >Comments
>> >========
>> >'Context ID: value
>> >'Desc Line 1
>> >'Desc Line 2
>> >'...
>> >'Desc Line N
>> >'
>> >'Parameters:
>> >'===========
>> >'Param 1 - one line desc
>> >'Param 2 - one line desc
>> >'...
>> >'Param N - one line desc
>> >'
>> >'Return Values:
>> >'============= =
>> >'value 1 - one line desc
>> >'value 2 - one line desc
>> >'...
>> >'value N - one line desc
>> >'
>> >'Remarks:
>> >'========
>> >'Remarks Line 1
>> >'Remarks Line 2
>> >'...
>> >'Remarks Line N
>> >
>> >comments to comments
>> >============== ==
>> >Each comment line start from ', No Rem is possible.
>> >Empty Lines inside comments block are possible but ignored
>> >No Mandatory
>> >Words Context ID Parameters, Return Values, Remarks are reserved.
>> >No comments at line where Parameters, Return Values, Remarks are[/color][/color]
>possible.[color=green][color=darkred]
>> >Lines with '======== or '-------- are ignored.
>> >
>> >
>> >Thanks
>> >illya
>> >
>> >"Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
>> >news:bmeo6l$21 lt$1@news.wnet. ua...
>> >> Hello
>> >>
>> >> Thank You for Your comments.
>> >> But I'm not going to buy this license.
>> >> Also I'm not going to parse all code -
>> >> just procedure declarations block with previous attached comments
>> >> to export them into XML and then auto generate HTML help :)
>> >>
>> >> '_' is not a problem just need to find <space>_
>> >>
>> >> A lot of function from VBIDE.CodeModul e are used
>> >>
>> >> I'm using some my own spec for comments and I'm parsing code according[/color][/color]
>to[color=green][color=darkred]
>> >my
>> >> spec by using only VBA code.
>> >>
>> >>
>> >> Format
>> >> =====
>> >> <Comments>
>> >> <Property?Funct ion?Sub Declaration>
>> >>
>> >> Comments
>> >> ========
>> >> 'Context ID: value
>> >>
>> >> 'Desc Line 1
>> >>
>> >> 'Desc Line 2
>> >>
>> >> '...
>> >>
>> >> 'Desc Line N
>> >>
>> >> '
>> >>
>> >> 'Parameters:
>> >>
>> >> '===========
>> >>
>> >> 'Param 1 - one line desc
>> >>
>> >> 'Param 2 - one line desc
>> >>
>> >> '...
>> >>
>> >> 'Param N - one line desc
>> >>
>> >> '
>> >>
>> >> 'Return Values:
>> >>
>> >> '==============
>> >>
>> >> 'value 1 - one line desc
>> >>
>> >> 'value 2 - one line desc
>> >>
>> >> '...
>> >>
>> >> 'value N - one line desc
>> >>
>> >> '
>> >>
>> >> 'Remarks:
>> >>
>> >> '========
>> >>
>> >> 'Remarks Line 1
>> >>
>> >> 'Remarks Line 2
>> >>
>> >> '...
>> >>
>> >> 'Remarks Line N
>> >>
>> >>
>> >> comments to comments
>> >> =============== =
>> >> Each comment line start from ', No Rem is possible.
>> >> Empty Lines inside comments block are possible but ignored
>> >> No Mandatory
>> >> Words Context ID Parameters, Return Values, Remarks are reserved.
>> >> No comments at line where Parameters, Return Values, Remarks are[/color][/color]
>possible.[color=green][color=darkred]
>> >> Lines with '======== or '-------- are ignored.
>> >>
>> >>
>> >> Procedure Declaration
>> >> =============== =
>> >> [Public|Private| Friend]
>> >> Property Get?Property Let?Property Set?Function?Su b
>> >> name ([ArgList]) [as ReturnType]
>> >>
>> >>
>> >>
>> >>
>> >> "Steve Jorgensen" <nospam@nospam. nospam> wrote in message
>> >> news:28mlov8kq7 cp5g0neo5ep7rae r3r7v5mgq@4ax.c om...
>> >> > I have just done some research on this subject, and it turns out that[/color][/color]
>to[color=green][color=darkred]
>> >> do
>> >> > it right, you need to buy a license for VBA integration. This is the
>> >only
>> >> > way to get the DLLs that give you access to the same information that
>> >> > AutoSense has. Without that, you can theoretically do what you want[/color][/color]
>(as[color=green][color=darkred]
>> >> > you have started to do), but it's up to you to pares everything
>> >correctly
>> >> > such determining as what's a comment (did you know a comment can
>> >line-wrap
>> >> > with " _"?). Also, if you want to know where a reference such as a
>> >> > function call is resolved (other UDF, external library, VB key word,
>> >etc.)
>> >> > ...
>> >> >
>> >> > I haven't checked the price on the VBA integration license yet, but I
>> >> > assume it's not cheap.
>> >> >
>> >> > On Mon, 13 Oct 2003 19:07:40 +0300, "Illya Havsiyevych"[/color][/color]
><gavsi@ukr.net >[color=green][color=darkred]
>> >> > wrote:
>> >> >
>> >> > >hi
>> >> > >
>> >> > >I'm trying to parse VBA code like compiler do
>> >> > >Than export function/sub declaration (aka prototype) to xml together
>> >with
>> >> > >comments to be ready to auto generate HTML help files for VBA/VB[/color][/color]
>code[color=green][color=darkred]
>> >> > >modules.
>> >> > >
>> >> > >For now I'm using all functions from VBIDE.CodeModul e Object.
>> >> > >Have some progress. Can send current
>> >> > >
>> >> > >illya
>> >> > >
>> >> > >"TC" <a@b.c.d> wrote in message news:1066039150 .717984@teuthos ...
>> >> > >> What are you trying to achieve?
>> >> > >>
>> >> > >> TC
>> >> > >>
>> >> > >>
>> >> > >> "Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
>> >> > >> news:bmb41d$2sf 6$1@news.wnet.u a...
>> >> > >> > Hello
>> >> > >> >
>> >> > >> > How easily parse VB/VBA code by VB/VBA code ?
>> >> > >> > Is any ready solutions ?
>> >> > >> >
>> >> > >> > Thank's,
>> >> > >> > illya
>> >> > >>
>> >> > >>
>> >> > >>
>> >> > >
>> >> >
>> >>
>> >>
>> >>
>> >>
>> >
>> >[/color]
>>[/color]
>[/color]

**David W. Fenton** · Nov 12 '05, 03:19 PM

Re: Parse VB/VBA Code

nospam@nospam.n ospam (Steve Jorgensen) wrote in
<huvnov8vnfu5mr b7jkgq833o90q4e h4ume@4ax.com>:
[color=blue]
>I'm not familliar with any free hosing[/color]

I'll hose your code from free, Steve.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

**Jim Allensworth** · Nov 12 '05, 03:20 PM

Re: Parse VB/VBA Code

Brinkster offers Cloud Servers, Managed Hosting, Disaster Recovery, Hosted E-mail, Data Storage, Load Balancing & Custom Management Services.

http://www.brinkster.com

Brinkster offers an array of managed services, including Cloud Servers, Hostedd Desktop, DDOS Mitigation, Managed Hosting, Disaster Recovery, Hosted E-mail, Data Storage, Load Balancing and Infrastructure as a Service (IaaS).

They provide free webhosting with 30MB of space.
Also, provide IIS/ASP resources.

I have found them to be a very useful resource.

- Jim

On Tue, 14 Oct 2003 11:21:25 +0300, "Illya Havsiyevych"
<gavsi@ukr.ne t> wrote:
[color=blue]
>will try a little bit later
>Do You know not very bad free hosting ?
>
>"Steve Jorgensen" <nospam@nospam. nospam> wrote in message
>news:ht1mov04h 3vvhv2moj3sqi2n olb6ch07ei@4ax. com...[color=green]
>> I'm pleased you are willing to share your code, and I'm anxious to take a
>> look at it, but this group does not allow binary attachments. If you can
>> put this in a Web site, and post a link, that would be a better way of
>> generously sharing your code.
>>
>> On Mon, 13 Oct 2003 21:50:01 +0300, "Illya Havsiyevych" <gavsi@ukr.ne t>
>> wrote:
>>[color=darkred]
>> >this message also posted as
>> >HTML Help Tool - Draft
>> >============== ====
>> >
>> >
>> >Hello All
>> >
>> >Here is draft of HTML Help tool as Access AddIn
>> >Tested with Access 2000, XP on Win2k and XP
>> >
>> >Install
>> >====
>> >1) Put all from To_ProgramFiles _MicrosoftOffic e_Office.zip
>> >into c:\Program Files\Microsoft Office\Office
>> >
>> >CTHELPPARSE.md e - VBA Code parse library
>> >CTHELPXML.md e - XML create/parse library
>> >CTUTIL.mde - utilities library
>> >vbahelp.xsd - XML Scheme for output XML
>> >
>> >2) Put all from To_AddIn.zip to Access AddIn Folder
>> >I have it as c:\Documents and Settings\Admini strator.COMP\Ap plication
>> >Data\Microsoft \AddIns
>> >
>> >CTHELPADDIN.md e - Access AddIn
>> >
>> >3) Start Access. GoTo Tools->Add-Ins->Add-In Manager
>> >Install CTHELPADDIN AddIn
>> >
>> >4) Open Any mdb maybe with comments like in Spec
>> >and try to use AddIn
>> >
>> >Format
>> >=====
>> ><Comments>
>> ><Property/Function/Sub Declaration>
>> >
>> >Comments
>> >========
>> >'Context ID: value
>> >'Desc Line 1
>> >'Desc Line 2
>> >'...
>> >'Desc Line N
>> >'
>> >'Parameters:
>> >'===========
>> >'Param 1 - one line desc
>> >'Param 2 - one line desc
>> >'...
>> >'Param N - one line desc
>> >'
>> >'Return Values:
>> >'============= =
>> >'value 1 - one line desc
>> >'value 2 - one line desc
>> >'...
>> >'value N - one line desc
>> >'
>> >'Remarks:
>> >'========
>> >'Remarks Line 1
>> >'Remarks Line 2
>> >'...
>> >'Remarks Line N
>> >
>> >comments to comments
>> >============== ==
>> >Each comment line start from ', No Rem is possible.
>> >Empty Lines inside comments block are possible but ignored
>> >No Mandatory
>> >Words Context ID Parameters, Return Values, Remarks are reserved.
>> >No comments at line where Parameters, Return Values, Remarks are[/color][/color]
>possible.[color=green][color=darkred]
>> >Lines with '======== or '-------- are ignored.
>> >
>> >
>> >Thanks
>> >illya
>> >
>> >"Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
>> >news:bmeo6l$21 lt$1@news.wnet. ua...
>> >> Hello
>> >>
>> >> Thank You for Your comments.
>> >> But I'm not going to buy this license.
>> >> Also I'm not going to parse all code -
>> >> just procedure declarations block with previous attached comments
>> >> to export them into XML and then auto generate HTML help :)
>> >>
>> >> '_' is not a problem just need to find <space>_
>> >>
>> >> A lot of function from VBIDE.CodeModul e are used
>> >>
>> >> I'm using some my own spec for comments and I'm parsing code according[/color][/color]
>to[color=green][color=darkred]
>> >my
>> >> spec by using only VBA code.
>> >>
>> >>
>> >> Format
>> >> =====
>> >> <Comments>
>> >> <Property?Funct ion?Sub Declaration>
>> >>
>> >> Comments
>> >> ========
>> >> 'Context ID: value
>> >>
>> >> 'Desc Line 1
>> >>
>> >> 'Desc Line 2
>> >>
>> >> '...
>> >>
>> >> 'Desc Line N
>> >>
>> >> '
>> >>
>> >> 'Parameters:
>> >>
>> >> '===========
>> >>
>> >> 'Param 1 - one line desc
>> >>
>> >> 'Param 2 - one line desc
>> >>
>> >> '...
>> >>
>> >> 'Param N - one line desc
>> >>
>> >> '
>> >>
>> >> 'Return Values:
>> >>
>> >> '==============
>> >>
>> >> 'value 1 - one line desc
>> >>
>> >> 'value 2 - one line desc
>> >>
>> >> '...
>> >>
>> >> 'value N - one line desc
>> >>
>> >> '
>> >>
>> >> 'Remarks:
>> >>
>> >> '========
>> >>
>> >> 'Remarks Line 1
>> >>
>> >> 'Remarks Line 2
>> >>
>> >> '...
>> >>
>> >> 'Remarks Line N
>> >>
>> >>
>> >> comments to comments
>> >> =============== =
>> >> Each comment line start from ', No Rem is possible.
>> >> Empty Lines inside comments block are possible but ignored
>> >> No Mandatory
>> >> Words Context ID Parameters, Return Values, Remarks are reserved.
>> >> No comments at line where Parameters, Return Values, Remarks are[/color][/color]
>possible.[color=green][color=darkred]
>> >> Lines with '======== or '-------- are ignored.
>> >>
>> >>
>> >> Procedure Declaration
>> >> =============== =
>> >> [Public|Private| Friend]
>> >> Property Get?Property Let?Property Set?Function?Su b
>> >> name ([ArgList]) [as ReturnType]
>> >>
>> >>
>> >>
>> >>
>> >> "Steve Jorgensen" <nospam@nospam. nospam> wrote in message
>> >> news:28mlov8kq7 cp5g0neo5ep7rae r3r7v5mgq@4ax.c om...
>> >> > I have just done some research on this subject, and it turns out that[/color][/color]
>to[color=green][color=darkred]
>> >> do
>> >> > it right, you need to buy a license for VBA integration. This is the
>> >only
>> >> > way to get the DLLs that give you access to the same information that
>> >> > AutoSense has. Without that, you can theoretically do what you want[/color][/color]
>(as[color=green][color=darkred]
>> >> > you have started to do), but it's up to you to pares everything
>> >correctly
>> >> > such determining as what's a comment (did you know a comment can
>> >line-wrap
>> >> > with " _"?). Also, if you want to know where a reference such as a
>> >> > function call is resolved (other UDF, external library, VB key word,
>> >etc.)
>> >> > ...
>> >> >
>> >> > I haven't checked the price on the VBA integration license yet, but I
>> >> > assume it's not cheap.
>> >> >
>> >> > On Mon, 13 Oct 2003 19:07:40 +0300, "Illya Havsiyevych"[/color][/color]
><gavsi@ukr.net >[color=green][color=darkred]
>> >> > wrote:
>> >> >
>> >> > >hi
>> >> > >
>> >> > >I'm trying to parse VBA code like compiler do
>> >> > >Than export function/sub declaration (aka prototype) to xml together
>> >with
>> >> > >comments to be ready to auto generate HTML help files for VBA/VB[/color][/color]
>code[color=green][color=darkred]
>> >> > >modules.
>> >> > >
>> >> > >For now I'm using all functions from VBIDE.CodeModul e Object.
>> >> > >Have some progress. Can send current
>> >> > >
>> >> > >illya
>> >> > >
>> >> > >"TC" <a@b.c.d> wrote in message news:1066039150 .717984@teuthos ...
>> >> > >> What are you trying to achieve?
>> >> > >>
>> >> > >> TC
>> >> > >>
>> >> > >>
>> >> > >> "Illya Havsiyevych" <gavsi@ukr.ne t> wrote in message
>> >> > >> news:bmb41d$2sf 6$1@news.wnet.u a...
>> >> > >> > Hello
>> >> > >> >
>> >> > >> > How easily parse VB/VBA code by VB/VBA code ?
>> >> > >> > Is any ready solutions ?
>> >> > >> >
>> >> > >> > Thank's,
>> >> > >> > illya
>> >> > >>
>> >> > >>
>> >> > >>
>> >> > >
>> >> >
>> >>
>> >>
>> >>
>> >>
>> >
>> >[/color]
>>[/color]
>
>[/color]