Defining variables in Excel 2010

[stattouk]

Just need direction on this please...

Where should I define variables if I want these to be available to all modules (and ThisWorkbook)? I assumed this would be in the Option Explicit declaration section of the module that the variable is first used and preceded by the Public statement.

I lose the variable's scope (reset?) executing the first line of the following code (in ThisWorkbook), to which I wish to add files to an Outlook email which has these variable names.

Please Login or Register  to view this content.

Regards.

[LJMetzger]

Hi stattouk,

Where should I define variables if I want these to be available to all modules (and ThisWorkbook)?

The easiest way to do what you want is to declare the variables in any Ordinary Code Module after the 'Option Explicit' statement and before the first Macro in that module. DO NOT declare the variables in a Sheet Code Module or the ThisWorkbook Code module (because they are 'Class Modules' which behave in a slightly different manner).

See the bottom of the following link for more information about the scope of variables in general: http://www.functionx.com/vbaexcel/Lesson03.htm

For example:

Please Login or Register  to view this content.

Lewis