Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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... "JT" wrote: 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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.) JT wrote: 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... "JT" wrote: 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 -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. Dave Peterson wrote: 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.) JT wrote: 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... "JT" wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |