F
feltra
Hi all,
Something very weird is happening with my user-defined Add-In Excel
VBA modules.
I have a set of "common" routines (like CheckFileonDisk(),
getSortedRow() etc) that I put into a CommonMacros.xla file, and am
referencing them thru Tools->AddIns and Tools->References.
It used to be working fine, but past couple of days I am observing a
strange problem - and am experiencing what I call "ghost" code.
In the course of development (of my other main modules), I found some
bugs in one of the CommonMacros procedures, fixed them and also added
a new function procedure.
Everything seems to be fine except that it insists on executing some
code that I have commented out!!!!! (during bugfixing)
There are a few MsgBox statements that I put in the Add-In procedure
during the course of debugging, and commented them out later.
However many times I de-link and re-link the AddIn reference, it
always executes these (currently commented out) MsgBox statements.
I even tried adding some new statements at the beginning of the buggy
add-in procedure and put a breakpoint there. During execution, it
comes to the breakpoint, but skips the newly added statements entirely
and keeps displaying the (visibly commented out) MsgBox statements!!!
If I de-link the reference, re-link it again, save the changes and
execute my macro *without exiting Excel*, it is working fine (the
ghost code is not executed).
But if I restart Excel and my application, it appears again!!! My
surmise (could be wrong) is that my previous save of the newly created
Reference was silently ignored?
Overall, I would say that the problem seems to be that I cannot seem
to get a recompile done on my Add-In module and Excel somehow
"remembers" only the older version...
I have tried quick-and-dirty things like renaming files, copying them,
etc and nothing seems to work.
The xla file is not saved in any default directory (i didnt know what
was default at saving time).
Please help with any inputs....
My advance thanks for any & all help...
Thanks & Regards,
-feltra
PS: This is how I unlinked and re-linked the AddIn module.
a) remove the reference to the Add-in in the Tools->AddIns
(from both Excel and VBA Editor windows)
b) Save the changes
c) Exit Excel
d) Restart Excel
e) Tie in the addin code in Excel thru Tools-<AddIns
f) Tie in the addin code in VBA Editor thru Tools->References
PS2: If there's no solution in sight, my only recourse is to stop
using the Common Macros in an Add-In module and instead put the macros
in each and every application.... This is a most cumbersome,
inefficient and manually error prone method. Wish I could avoid
this...
Something very weird is happening with my user-defined Add-In Excel
VBA modules.
I have a set of "common" routines (like CheckFileonDisk(),
getSortedRow() etc) that I put into a CommonMacros.xla file, and am
referencing them thru Tools->AddIns and Tools->References.
It used to be working fine, but past couple of days I am observing a
strange problem - and am experiencing what I call "ghost" code.
In the course of development (of my other main modules), I found some
bugs in one of the CommonMacros procedures, fixed them and also added
a new function procedure.
Everything seems to be fine except that it insists on executing some
code that I have commented out!!!!! (during bugfixing)
There are a few MsgBox statements that I put in the Add-In procedure
during the course of debugging, and commented them out later.
However many times I de-link and re-link the AddIn reference, it
always executes these (currently commented out) MsgBox statements.
I even tried adding some new statements at the beginning of the buggy
add-in procedure and put a breakpoint there. During execution, it
comes to the breakpoint, but skips the newly added statements entirely
and keeps displaying the (visibly commented out) MsgBox statements!!!
If I de-link the reference, re-link it again, save the changes and
execute my macro *without exiting Excel*, it is working fine (the
ghost code is not executed).
But if I restart Excel and my application, it appears again!!! My
surmise (could be wrong) is that my previous save of the newly created
Reference was silently ignored?
Overall, I would say that the problem seems to be that I cannot seem
to get a recompile done on my Add-In module and Excel somehow
"remembers" only the older version...
I have tried quick-and-dirty things like renaming files, copying them,
etc and nothing seems to work.
The xla file is not saved in any default directory (i didnt know what
was default at saving time).
Please help with any inputs....
My advance thanks for any & all help...
Thanks & Regards,
-feltra
PS: This is how I unlinked and re-linked the AddIn module.
a) remove the reference to the Add-in in the Tools->AddIns
(from both Excel and VBA Editor windows)
b) Save the changes
c) Exit Excel
d) Restart Excel
e) Tie in the addin code in Excel thru Tools-<AddIns
f) Tie in the addin code in VBA Editor thru Tools->References
PS2: If there's no solution in sight, my only recourse is to stop
using the Common Macros in an Add-In module and instead put the macros
in each and every application.... This is a most cumbersome,
inefficient and manually error prone method. Wish I could avoid
this...