View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Compile Error: Expected Variable or Procedure, Not Project

What's the name of the VBAProject for this workbook?

Did you use that same name for any of the module names?

It's not a good idea to reuse these names.

BEEJAY wrote:

Have used / tested the following numerous times over the past few months.
Not that I'm almost ready to send out my "package", I tried one last test.
The first time it worked great. The 2nd time, I get the compile error
message, as shown above.
I copied over the "master/back-up" and tried again, with the same error
result.
Can someone direct me as to what is happening, and how I can correct this?

Private Sub Workbook_Open()
QCNum_Updater
End Sub


--

Dave Peterson