Compile error

[Guest]

Hi...

I broght a 97 workbook into 2002 and now when I start it up it says

Compile error in hiddne module: jwpacke

ive looked for this module and cant seem to un-hide it...

any suggestions?

thanks
JT

 

[Guest]

Hi again...

I found the jwpake module.. at the top of my workbook in the vba project
window...

I didnt make it or put it there and it is password protected.... it happend
when I started using 2002......from my old 97 workbook.....its called
VBAProject(jwpacke.xls)

any ideas on how to get rid of this? it seems that my master copy of my
workbook is now part of it...

 

[Dave Peterson]

Look for jwpacke.xls in your XLStart folder.

Or close excel and use windows start button|search and look for that file. Then
move it to a different location. (If you find that you actually use some of the
stuff in that workbook, you may not want to delete it. Although, you may want
to find the author and yell.)

 

[Dave Peterson]

Another way to find this file...

Open excel and ignore those warning/error messages.

Then go into the VBE.

You should still be able to see VBAProject(jwpacke.xls) in the project explorer.

Hit ctrl-g to see the immediate window.
type this and hit enter
?workbooks("jwpacke.xls").fullName

Make a note of that file (and location).

Close excel and go off to move that file.