Greetings !

A continuation of a saga that started on 1st September,
and has elicited responses from several people, for whose
contribution I am very grateful. Alas ! The problem
remains...


Tom Ogilvy responded, 9/2/2003 11:10:39 AM

Rob Bovey's URL:

So I have now managed to run that. Alas ! It makes no
difference to the problem in hand, my code still refuses
to run.

I would also make my addin a workbook,

Please tell me how I do that?
There is no option to "Save As..." in VBE.

then make it the active project (in
the vbe) and then go to tools=References
(in the vbe) and make sure nothing
is shown as missing.

At the moment, the code (that all used to run OK, when it
was in a psuedo .xla) now does not recognise the Common
Variables that I have declared in the new "genuine" .xla,
using these lines, and a lot more similar -

Public I0(20) As Double
Public Direction(3) As String
Public G1(32) As String * 8
Public Stxt$(10)
Public Ttxt$(5)

When it runs, it comes to a halt, believing that
Ttxt$(3)
is a Function Call

Taking the original "psuedo" .xla, I tried to separate
the "Worksheet" part from the "true" .xla part, but this
has meant that I have duplicated some of the code, in
the "ThisWorkbook" module, specifically, the
Workbook_BeforeClose procedure. I can't see that this
should have the effect at start up that I am
experiencing?