I wrote in here, 2003-09-01 08:15:31 PST

I am now trying to separate the "Worksheet"
part from the "AddIn" part.

O.K. - so here is my current challenge !

In the AddIn part, I have modules -
"Constants", "CommonVariables", "VariableTypes"
and "PublicDeclarations", but when I RUN the
two parts together, i.e. when I load the
spreadsheet, Excel runs OK until it reaches
RecLen = Len(HIP(Ali, 1))

and Excel highlights the word "HIP" (it appears to be
in "de-bug" mode, while loading the AddIn)

which refers to an array variable declared
in the "CommonVariables" module by
Public HIP(2, 50) As HorizIntersPts

At this point, Excel creaks to a halt with the message -
"Compile Error - Sub or Function not defined".

Now, this worked FINE until I split the two parts.

What am I doing wrong ?

Tom Ogilvy was (once again) kind enough to respond, 2003-
09-01 08:37:44 PST, for which, many thanks.

I suspect Excel does not have a definition for
HorizIntersPts

I have the lines -

Public Type HorizIntersPts
PtNo As Integer
Rad As Double
Code As String
Cant As Double
End Type

in the "VariableTypes" Module of the AddIn.
It all used to work "before"...
It seems that Excel simply does not reach those lines
early enough ?


When I try to exit, Excel again grinds to a halt at the
same place, and then it stops again in the "BeforeClose"
routine of the AddIn, at this line (when I want the
question "Save this file?" asked -

Ans$ = MsgBox(Msg, vbQuestion + vbYesNoCancel)

Excel highlights the word Ans$ with the message

Compile error
Variable not defined

This, despite my having this line -
Public Ans$
in the "CommonVariables" Module of the AddIn.


Curiously, these are the only two places it seems to have
a problem, yet there are lots of similar situations /
variables....

Do you have Rob Bovey's Code Cleaner? I suggest you run it. Search Google for a URL to download
it. If you can't find it, export all modules to text files, perhaps save, close and reopen the
workbook, then import the modules. (Rob's Add-in does that automatically.)


On Tue, 2 Sep 2003 02:07:32 -0700, "Robin Clay" wrote:

I wrote in here, 2003-09-01 08:15:31 PST

I am now trying to separate the "Worksheet"
part from the "AddIn" part.

O.K. - so here is my current challenge !

In the AddIn part, I have modules -
"Constants", "CommonVariables", "VariableTypes"
and "PublicDeclarations", but when I RUN the
two parts together, i.e. when I load the
spreadsheet, Excel runs OK until it reaches
RecLen = Len(HIP(Ali, 1))

and Excel highlights the word "HIP" (it appears to be
in "de-bug" mode, while loading the AddIn)

which refers to an array variable declared
in the "CommonVariables" module by
Public HIP(2, 50) As HorizIntersPts

At this point, Excel creaks to a halt with the message -
"Compile Error - Sub or Function not defined".

Now, this worked FINE until I split the two parts.

What am I doing wrong ?

Tom Ogilvy was (once again) kind enough to respond, 2003-
09-01 08:37:44 PST, for which, many thanks.

I suspect Excel does not have a definition for
HorizIntersPts

I have the lines -

Public Type HorizIntersPts
PtNo As Integer
Rad As Double
Code As String
Cant As Double
End Type

in the "VariableTypes" Module of the AddIn.
It all used to work "before"...
It seems that Excel simply does not reach those lines
early enough ?


When I try to exit, Excel again grinds to a halt at the
same place, and then it stops again in the "BeforeClose"
routine of the AddIn, at this line (when I want the
question "Save this file?" asked -

Ans$ = MsgBox(Msg, vbQuestion + vbYesNoCancel)

Excel highlights the word Ans$ with the message

Compile error
Variable not defined

This, despite my having this line -
Public Ans$
in the "CommonVariables" Module of the AddIn.


Curiously, these are the only two places it seems to have
a problem, yet there are lots of similar situations /
variables....