[Brian]

Many, many years ago I use to earn my daily bread by writing code for
Dos using Microsoft Masm. In due course I transferred to C (but not
C++) and then to Windows 3.1, and finally I retired 24 years ago.

I am now writing (more precisely, trying to write) some VBA code for a
friend, but I am having difficulty finding information about the
mechanics of the process. By this I mean, matters such as whether code
can be in several files, and if so how those files are compiled and
linked. I am even finding it difficult to find clear information about
how to couple VBA programs with Excel.

If anyone can recommend a book which describes these basic processes,
and possibly also provides guidance with the language itself - though
this is less important - I would be extremely grateful. Any other
advice would also be very welcome.

Kind regards

Brian Phillips

[GS[_6_]]

Many, many years ago I use to earn my daily bread by writing code for
Dos using Microsoft Masm. In due course I transferred to C (but not
C++) and then to Windows 3.1, and finally I retired 24 years ago.

I am now writing (more precisely, trying to write) some VBA code for
a friend, but I am having difficulty finding information about the
mechanics of the process. By this I mean, matters such as whether
code can be in several files, and if so how those files are compiled
and linked. I am even finding it difficult to find clear
information about how to couple VBA programs with Excel.

If anyone can recommend a book which describes these basic processes,
and possibly also provides guidance with the language itself - though
this is less important - I would be extremely grateful. Any other
advice would also be very welcome.

Kind regards

Brian Phillips

Start here...

http://spreadsheetpage.com/

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

[Auric__]

Brian wrote:

Many, many years ago I use to earn my daily bread by writing code for
Dos using Microsoft Masm. In due course I transferred to C (but not
C++) and then to Windows 3.1, and finally I retired 24 years ago.

I am now writing (more precisely, trying to write) some VBA code for a
friend, but I am having difficulty finding information about the
mechanics of the process. By this I mean, matters such as whether code
can be in several files,

Eh... sort of. Code needs to be within spreadsheets (or other application-
specific formats: documents for Word, slideshows for Powerpoint, etc.) but
within each spreadsheet there can be multiple modules, forms, classes, etc.,
each of which is analogous to, and can be exported to, an individual file.
Code in one spreadsheet can be called from another spreadsheet if needed.

and if so how those files are compiled and linked.

VBA is an interpreted language. What compilation happens is behind the
scenes. This page has a (very) brief discussion of compilation (with a view
toward decompiling) within VBA:

http://orlando.mvps.org/VBADecompilerMore.asp#WhatItIs

I am even finding it difficult to find clear information about
how to couple VBA programs with Excel.

If anyone can recommend a book which describes these basic processes,
and possibly also provides guidance with the language itself - though
this is less important - I would be extremely grateful. Any other
advice would also be very welcome.

Microsoft Press has released several books on this topic. See he

https://www.microsoftpressstore.com/...t-office/excel

I don't know how good any of them are, but the one I have (somewhere...) is
pretty thorough (it was released in the 90's for Office 97 or 2000).

--
I am sick of testing my brakes
because you are trying to become my newest hood ornament.

[Brian]

On 12/01/2016 12:39, Brian wrote:
Many, many years ago I use to earn my daily bread by writing code for
Dos using Microsoft Masm. In due course I transferred to C (but not
C++) and then to Windows 3.1, and finally I retired 24 years ago.

I am now writing (more precisely, trying to write) some VBA code for a
friend, but I am having difficulty finding information about the
mechanics of the process. By this I mean, matters such as whether code
can be in several files, and if so how those files are compiled and
linked. I am even finding it difficult to find clear information about
how to couple VBA programs with Excel.

If anyone can recommend a book which describes these basic processes,
and possibly also provides guidance with the language itself - though
this is less important - I would be extremely grateful. Any other
advice would also be very welcome.

Kind regards

Brian Phillips



Thanks everyone. I have ordered a Walkenbach book "Excel 2013 Power
Programming with VBA" to start with.

I actually thought that VBA was interpreted, but an error message I got
referred to the compiler not being able to do something, and this made
me wonder.

Regards

Brian

[GS[_6_]]

On 12/01/2016 12:39, Brian wrote:
Many, many years ago I use to earn my daily bread by writing code
for
Dos using Microsoft Masm. In due course I transferred to C (but
not
C++) and then to Windows 3.1, and finally I retired 24 years ago.

I am now writing (more precisely, trying to write) some VBA code
for a
friend, but I am having difficulty finding information about the
mechanics of the process. By this I mean, matters such as whether
code
can be in several files, and if so how those files are compiled and
linked. I am even finding it difficult to find clear information
about
how to couple VBA programs with Excel.

If anyone can recommend a book which describes these basic
processes,
and possibly also provides guidance with the language itself -
though
this is less important - I would be extremely grateful. Any other
advice would also be very welcome.

Kind regards

Brian Phillips



Thanks everyone. I have ordered a Walkenbach book "Excel 2013 Power
Programming with VBA" to start with.

I actually thought that VBA was interpreted, but an error message I
got referred to the compiler not being able to do something, and this
made me wonder.

Regards

Brian

The compiler only checks code syntax based on your settings. Note that
on the Editor tab of the Options dialog, you should check the option to
'require variable declaration' so *Option Explicit* is the 1st line on
every code page!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

[Brian]

On 13/01/2016 16:50, GS wrote:
On 12/01/2016 12:39, Brian wrote:
Many, many years ago I use to earn my daily bread by writing code for
Dos using Microsoft Masm. In due course I transferred to C (but not
C++) and then to Windows 3.1, and finally I retired 24 years ago.

I am now writing (more precisely, trying to write) some VBA code for a
friend, but I am having difficulty finding information about the
mechanics of the process. By this I mean, matters such as whether code
can be in several files, and if so how those files are compiled and
linked. I am even finding it difficult to find clear information about
how to couple VBA programs with Excel.

If anyone can recommend a book which describes these basic processes,
and possibly also provides guidance with the language itself - though
this is less important - I would be extremely grateful. Any other
advice would also be very welcome.

Kind regards

Brian Phillips



Thanks everyone. I have ordered a Walkenbach book "Excel 2013 Power
Programming with VBA" to start with.

I actually thought that VBA was interpreted, but an error message I
got referred to the compiler not being able to do something, and this
made me wonder.

Regards

Brian

The compiler only checks code syntax based on your settings. Note that
on the Editor tab of the Options dialog, you should check the option to
'require variable declaration' so *Option Explicit* is the 1st line on
every code page!


Thanks Garry. Will do.

Brian