assigning a global variable in vba

[lokeshsu]

Hi all,


I am trying to assign a variable globally in vba, as i want to use that variable in different places in the vba code to get the path. i tried to do it using the option explicit and it was showing an error, below is code what i used.

Option Explicit
Public dbpath As String
Public dumppath As String
 dbpath = "c:\datadump.mdb"

Need help in fixing this issue

Thanks in advance
Lokesh Sundar

 

[jim may]

dbpath = "c:\datadump.mdb" <<< This belongs within (inside of) your Sub procedure.

 

[lokeshsu]

ya it should be in sub procedure but if i want to use a variable in different procedure how can we go about that

 

[jim may]

to use a variable in different procedure :

1) A procedure within the Same Module, Place in the Declaration Section:
Dim dbpath As String
2) A Procedure in a Different Module of the Same Project (File) in the Declaration of
any Standard module:
Public dbpath As String