How to define a constant across all vba code such as your main workbook name.

[welchs101]

I have a workbook whose name i would like to define as a constant so that it can be used across all functions and procedures. I cant use "active workbook" as i am opening and closing so many workbooks while this program is running.

I figured if i somehow define my "main" workbook as a constant then i dont need to keep passing it to all the procedures that need to use it.

any ideas?

[romperstomper]

If you want to refer to the workbook in which the code is located, use ThisWorkbook.

[welchs101]

great idea.......thanks.

[welchs101]

i would not have to define it as a constant i would just call it "thisworkbook"? is this right.

[Mordred]

why not somethin like:

Please Login or Register  to view this content.

Assign this right in the beginning of you code, assuming that your code starts with your Main workbook.

[romperstomper]

i would not have to define it as a constant i would just call it "thisworkbook"? is this right.

Correct. ThisWorkbook always refers to the workbook containing the code.

[Mordred]

@Romper, that is an interesting thing to note. I always assumed that ThisWorkbook applied to whatever workbook was active. That is good to know.

Who are you that is so wise in the ways of science?

[romperstomper]

@Romper, that is an interesting thing to note. I always assumed that ThisWorkbook applied to whatever workbook was active.

Nope - that's ActiveWorkbook. (the clue is in the name. )

Who are you that is so wise in the ways of science?

I know a few random things, that's all.