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