Another stupid newbie question.

[mato nanjin]

I am trying to dim some variables as public. I have this statement (among
others) in a module in the Auto_Open Sub:

"Public dtPropDate As Date ' quote date"

I get the following error message when the workbook loads:

"Compile error. Invalid atribute in Sub or function"

Any ideas why I get this?

How can I screw up something this simple?

Thanks, Ron

[Bob Phillips]

It sounds as though you have declared it as part of a sub. In a sub it must
be a Dim. Public is used to declare a global variable, but it must be
declared outside of, and before, any procedures.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"mato nanjin" <matonanjin.nospam@yahoo.com> wrote in message
news:491B3FD7-05AD-4304-A1B2-DC31A28DBF43@microsoft.com...
> I am trying to dim some variables as public. I have this statement (among
> others) in a module in the Auto_Open Sub:
>
> "Public dtPropDate As Date ' quote date"
>
> I get the following error message when the workbook loads:
>
> "Compile error. Invalid atribute in Sub or function"
>
> Any ideas why I get this?
>
> How can I screw up something this simple?
>
> Thanks, Ron

[light]

mato nanjin

I a dumb newbie too but I think I may be smart enough to answer your question. You cant use certain words that are "reserved" like "Public" as a variable. I think the way to write this is:

Dim dtPropDate As Date