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