For five weeks I have been writing Macros to do various functions

I have four WorkBooks. ACTStdnts, INTLStdnts, SATStdnts and TAKSStdnts.

All four of these Workbooks and all my Macros worked great in my Test
Directory

I Copied a live Workbook ACTStdnts into my Test Directory to Test it one
final time.
All my Macros (3000 Lines) were destroyed!!!!

Why did it destroy the Macros in my other three Workbooks.

This never happened with IBM Lotus, why is it happening with Microsoft.

Explanation Please

Thanks

J.Q.

I have never heard of that happening. What version of Excel? If 2007, is it
possible you saved the file(s) as non-macro enabled workbooks (*.xslx rather
than *.xlsm)? You might try downloading OpenOffice (www.openoffice.org) and
opening the workbook and see if the code is still intact to some extent.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"John Quinn" <(E-Mail Removed)> wrote in message
news:1EA1B327-D4B1-4369-BD85-(E-Mail Removed)...
> For five weeks I have been writing Macros to do various functions
>
> I have four WorkBooks. ACTStdnts, INTLStdnts, SATStdnts and TAKSStdnts.
>
> All four of these Workbooks and all my Macros worked great in my Test
> Directory
>
> I Copied a live Workbook ACTStdnts into my Test Directory to Test it one
> final time.
> All my Macros (3000 Lines) were destroyed!!!!
>
> Why did it destroy the Macros in my other three Workbooks.
>
> This never happened with IBM Lotus, why is it happening with Microsoft.
>
> Explanation Please
>
> Thanks
>
> J.Q.

what do you mean by "destroyed" ? lines were removed or modules or maybe
forms ? be more specific, pls.
I hope you know that the answer for ur question is rather difficult without
additional info ( not mentioning the fact that we cant see ur code )

S.

Chip;

Excel 2002! I have never downloaded anything. We bought 7 retail
copies over the counter of Excel only. None of them are Microsoft Office.
The school District prefers to do everything VB6 and Excel Only. This was at
the advice of the Microsoft Consultants (They work for Microsoft).

None of the Macros (unless I goofed) were for all workbooks. They
were coded for the specifice worksheets only!

I write special programs that the real world never sees. This is a
new experience for me, but I have never seen work from one directory destroy
work from another directory in my 25 years of programming!

Thanks for getting back

J.Q.

"Chip Pearson" wrote:

> I have never heard of that happening. What version of Excel? If 2007, is it
> possible you saved the file(s) as non-macro enabled workbooks (*.xslx rather
> than *.xlsm)? You might try downloading OpenOffice (www.openoffice.org) and
> opening the workbook and see if the code is still intact to some extent.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting
> www.cpearson.com
> (email on the web site)
>
> "John Quinn" <(E-Mail Removed)> wrote in message
> news:1EA1B327-D4B1-4369-BD85-(E-Mail Removed)...
> > For five weeks I have been writing Macros to do various functions
> >
> > I have four WorkBooks. ACTStdnts, INTLStdnts, SATStdnts and TAKSStdnts.
> >
> > All four of these Workbooks and all my Macros worked great in my Test
> > Directory
> >
> > I Copied a live Workbook ACTStdnts into my Test Directory to Test it one
> > final time.
> > All my Macros (3000 Lines) were destroyed!!!!
> >
> > Why did it destroy the Macros in my other three Workbooks.
> >
> > This never happened with IBM Lotus, why is it happening with Microsoft.
> >
> > Explanation Please
> >
> > Thanks
> >
> > J.Q.
>

All the Macros are gone, now I am having a heck of a time recreating them.
Why can't we just create a module and call it like VB6?

I have them in the Toolbar (The Toolbar stayed the same) and it will not let
me re-create them???

Can we just write a Macro without bringing up the Tools Menu and Create a
New Macro without running the code. Why can't I just copy a Macro and change
the necessary lines?

Thanks for getting back to me!

J.Q.

"Snake Plissken" wrote:

> what do you mean by "destroyed" ? lines were removed or modules or maybe
> forms ? be more specific, pls.
> I hope you know that the answer for ur question is rather difficult without
> additional info ( not mentioning the fact that we cant see ur code )
>
> S.
>
>
>

What you mean by "I Copied a live Workbook" ?
Not sure you set-up/system, but copying a WB to new location will NOT
destroy VBA in it and 3 other unrelated WBs.

Something else must have happened also, as, from your description alone, it
is not possible.

NickHK

"John Quinn" <(E-Mail Removed)> wrote in message
news:1EA1B327-D4B1-4369-BD85-(E-Mail Removed)...
> For five weeks I have been writing Macros to do various functions
>
> I have four WorkBooks. ACTStdnts, INTLStdnts, SATStdnts and TAKSStdnts.
>
> All four of these Workbooks and all my Macros worked great in my Test
> Directory
>
> I Copied a live Workbook ACTStdnts into my Test Directory to Test it one
> final time.
> All my Macros (3000 Lines) were destroyed!!!!
>
> Why did it destroy the Macros in my other three Workbooks.
>
> This never happened with IBM Lotus, why is it happening with Microsoft.
>
> Explanation Please
>
> Thanks
>
> J.Q.

frankly - I never heard...

BTW - just in case - maybe you should consider exporting all vba code from
time to time...

John Quinn wrote:
>Chip;
>
> Excel 2002! I have never downloaded anything. We bought 7 retail
>copies over the counter of Excel only. None of them are Microsoft Office.
>The school District prefers to do everything VB6 and Excel Only. This was at
>the advice of the Microsoft Consultants (They work for Microsoft).
>
> None of the Macros (unless I goofed) were for all workbooks. They
>were coded for the specifice worksheets only!
>
> I write special programs that the real world never sees. This is a
>new experience for me, but I have never seen work from one directory destroy
>work from another directory in my 25 years of programming!


Is it possible that you were calling a Macro that was residing in another
workbook intead of the one you were activly working on?

That could give you unexpected results,and it may be difficult to find the
code if it's in anothrer file



































>
>Thanks for getting back
>
>J.Q.
>
>> I have never heard of that happening. What version of Excel? If 2007, is it
>> possible you saved the file(s) as non-macro enabled workbooks (*.xslx rather
>[quoted text clipped - 21 lines]
>> >
>> > J.Q.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200707/1