Sorry about the delay of response.
Yes, the naming of modules etc. was the problem.
Your help greatly appreciated, as always.


"Dave Peterson" wrote:

If that doesn't work, make sure you look at the Project's name, too.

Open the VBE
select your project
Do you see:
QCNUM_Updater(QCNUM_Updater.xls)

if yes, then hit F4 (to see the properties window)
then give that project a new (name)



BEEJAY wrote:

The actual file name is QCNUM_Updater.xls
The subs name is QCNUM_Updater
I have now changed the file name to QCNUMBER Updating.xls
I check it out in the morning, and see if that helps out with this
intermitent problem.
Thanks for now.

"Dave Peterson" wrote:

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


--

Dave Peterson