macro problem

[Kiran]

I have a macro in a excell file. file is in the xlstart
folder
so that macro becomes available when excell launches.
When we import from a report(another application) to excell
excell starts but the file in which the macro is does not
launch i.e, under tool->macros we don't see that macro.

I just got my machine upgraded from excell2000 to
excell2002. macro was done in the previous version. should
that make a difference.

thanks

 

[Dave Peterson]

Guess #1:
How are you starting excel?

If you're automating it from another program (a change from before???), then
you'll have to load that workbook yourself.


Guess #2:
Your macro workbook isn't in the correct location.
Open Excel
hit alt-f11 to see the VBE.
hit ctrl-g to see the immediate window
type this and hit enter:
?application.StartupPath

Is that were your workbook is located? If not, then move it there and try it
again.

Guess #3:
Your workbook got corrupted someway (xl2002 has a way to stop loading it if it
thinks that it's bad).

Start excel
Help|about MS Excel
Click on Disabled items
Is your file mentioned there?
If yes, enable it. But if it was really corrupt, you may have to restore from a
backup.