Why wont it work?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bobby - 01 Dec 2005 22:26 GMT

Help!
I want to start automaticaly a macro or SUB in ThisWorkbook. This is my
code :

Private Sub Workbook_Open()
slist
End Sub

It keep's telling me that a variable or procedure is wanted and not a
module(slist is a module)! Where do I go wrong! This is driving me!(I
did try many things so far with no result)

Reply to this Message

Norman Jones - 01 Dec 2005 22:29 GMT

Hi Bobby,

What is the name of the macro that you want to run and where is it housed?

---
Regards,
Norman

> Help!
> I want to start automaticaly a macro or SUB in ThisWorkbook. This is my
[quoted text clipped - 7 lines]
> module(slist is a module)! Where do I go wrong! This is driving me!(I
> did try many things so far with no result)

Reply to this Message

Bobby - 01 Dec 2005 23:58 GMT

Norman the module name is: slist(was module1 before I rename it) and it
is located in the current WorBook

Reply to this Message

Dave Peterson - 02 Dec 2005 00:22 GMT

Put it back in Module1.

But inside that module1, there's a:

Sub XXXXX()

What's the name of the procedure you want to run?

(It follows the word Sub.)

> Norman the module name is: slist(was module1 before I rename it) and it
> is located in the current WorBook

Signature

Dave Peterson

Reply to this Message

Bobby - 02 Dec 2005 00:41 GMT

The Sub name is: slist or
Sub slist()

Reply to this Message

Norman Jones - 02 Dec 2005 00:48 GMT

Hi Bobby,

If you name a macro and a module with the same name, you will confuse VBA:
Change the name of the module (as suggested by Dave) and all should be well.

---
Regards,
Norman

> The Sub name is: slist or
> Sub slist()

Reply to this Message

Bob Phillips - 01 Dec 2005 22:30 GMT

You should be referring to the macro in that module, not the module itself.

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

Reply to this Message