using general variables

[mayki76]

i am writing a macro for excel.
i have few subs.
there are some variables (like "file_name") which i would like to use in all the subs.
how to i do so?

(i declared them in the "general")

 

[Chance1234]

The Answer is at the top of your module put

Public file_name as string

or if the value doesnt change

const file_name = "C:\whatever"

but from your question, i suggest you read the excel vba files on scope and declaration, as you wont get much further.,

Chance,

Filmmaker, taken gentleman and crunch day + 22

 

[mayki76]

that's exactly what i did but from some reason it doesnt work. i am not familiar with vba enough to understand why.

 

[Chance1234]

might help if you post your code.

Chance,

Filmmaker, taken gentleman and crunch day + 22

 

[mayki76]

thanks.
problem solved - i figured global variables are active as long as you run all subs.