Global variable for add-in?

[paipimenta]

I'm working on an add-in that will have a user-form to make changes to a complex workbook. The add-in changes workbook "Audit Form.xls". How can I set this file name as a global constant in my add-in, so that I can just change this file name once in the add-in?

I'm looking for something like this....

Public Contant auditFileName As String
auditFileName = "Audit Form.xls"

 

[Mike Blackman]

Hi,

At the top of one of your modules house something like;

Public StrFileName as string

although I'd suggest writing the value to a name as if you have a single unhandled error within the code then and variables will be lost. If you write it to a name you can always refer to it as such;

ThisWorkbook.Range("MyFileName")

 

[RoryA]

If you want a constant in your code:

Public Const auditFileName As String = "Audit Form.xls"