Excel XP Macro Loading Problem

  • Thread starter Thread starter %P*Rr&^
  • Start date Start date
%

%P*Rr&^

Although Dave has offered kind suggestions, my problem is not solved.
Hopefully this re-re-post ends up on the main list of this group (instead of
as part of the original posting as my first re-post did). If you scroll
down to the bottom you will see my description of the problem.

And the answer to Dave's suggestion is no, the data I mention is actually a
list of constants entered into the declarations section and so is lost along
with the code.

- - It sounds like the old version has the macro. And the "recovered"
version has
the data.

- - Can't you create a third workbook that takes the good things from each
of the
bad things?
 
I assume that you tried to open the "faulty" workbook
with "macros disabled"? That should allow you to recover
th ecode. If so, I'd suggest you create a new folder on
your desktop then drag each module from the IDE into the
folder - that's a Save and might save time in future.

Also, I'd go with Dave's suggestion. Open new workbook &
again, in the IDE just drag the modules into the new
workbook in Project Explorer.
Of course, both the above require the original workbook
to open first. So again, try it with security at High and
open with macros disabled.

Patrick Molloy
Microsoft Excel MVP
 
Back
Top