Can a variable be used across different Sub Functions?

I have a macro setup to run different reports in Excel. I have the filename picked up from cell A1 in one set of code, I also want it to be picked up and used in another Sub function. It is stored in a different module. Is there a way I can declare it so I can use it in both?

I read something about declaring it globally, would that work?

Thanks,

~J

Hi,

1)

Declare a public variable of appropriate data type in any one onf the modules. And you can use that in all the modules.

Eg: In module1.bas declare

public gIntEmpNumber as Integer

you can access this variable in module2.bas or another module.

2)
Declare a parameter in the other sub function and pass the filepath value and use that in the sub function

Best Wishes
mtpSuresh

Sorry just a tad confused. So in one module I would set

Public Filename as String

Then I just use Filenema whenever in any module?

Thanks,

~J