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

What exactly is QCNum_Updater. I am assuming it is a procedure of some sort?
I assume that it exists somewhere in your project. If you right click on it
and select Definition it takes you to the procedure? Do your modules include
"option explicit" at the top?
--
HTH...

Jim Thomlinson


"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

QCNum_Updater is a macro in Module 1, that calls other subs and messages from
Modules 2 and 3.
All my modules are set up with "Option Explicit". I've read that it is a
good thing to do.
Yes, when I right click on QCNum_Updater, I get taken directly to the
procedure in Module # 1.



"Jim Thomlinson" wrote:

What exactly is QCNum_Updater. I am assuming it is a procedure of some sort?
I assume that it exists somewhere in your project. If you right click on it
and select Definition it takes you to the procedure? Do your modules include
"option explicit" at the top?
--
HTH...

Jim Thomlinson


"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

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

There is nothing in there that should be causing a compile error. Have you
checked for missing references. That is a bit of a long shot but sometimes
that will cause a compile error on an otherwise good line of code...
--
HTH...

Jim Thomlinson


"BEEJAY" wrote:

QCNum_Updater is a macro in Module 1, that calls other subs and messages from
Modules 2 and 3.
All my modules are set up with "Option Explicit". I've read that it is a
good thing to do.
Yes, when I right click on QCNum_Updater, I get taken directly to the
procedure in Module # 1.



"Jim Thomlinson" wrote:

What exactly is QCNum_Updater. I am assuming it is a procedure of some sort?
I assume that it exists somewhere in your project. If you right click on it
and select Definition it takes you to the procedure? Do your modules include
"option explicit" at the top?
--
HTH...

Jim Thomlinson


"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

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

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

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