Using Windows XP and Office 2007;

Is there a way to obtain the contents of a string constant from another
module where the other module in which the const lives is marked "Option
Private Module" and the const is declared as: Private Const myConst As String
= "MyString"?

If possible, could someone please post a generic example on how to do it?

If NOT marked private, is a module level Const automatically global, if not,
what is it?

Thanks for the clarifications!

Change 'Private Const' to 'Public Const'. That should still be visible
throughout the project even with Option Private Module

Regards,
Peter T


"XP" <(E-Mail Removed)> wrote in message
news:676CA115-6A9D-4A32-918E-(E-Mail Removed)...
> Using Windows XP and Office 2007;
>
> Is there a way to obtain the contents of a string constant from another
> module where the other module in which the const lives is marked "Option
> Private Module" and the const is declared as: Private Const myConst As
> String
> = "MyString"?
>
> If possible, could someone please post a generic example on how to do it?
>
> If NOT marked private, is a module level Const automatically global, if
> not,
> what is it?
>
> Thanks for the clarifications!