How to include an integer variable in a workbook name VBA?

[SBF12345]

Greetings,

I would like to be able to include a variable value in part of a workbook name. The line of code requiring a variable value (the workbook name changes each time the file is accessed) is below:

Set GLD = Workbooks("GLD_US_archive_EN(integer variable goes inside the brackets).csv")

what is the syntax for including an integer variable in this situation?

Thanks!

 

[Fluff]

Try

Set GLD = Workbooks("GLD_US_archive_EN" & myVariable & ".csv")

 

[SBF12345]

When I write the line as:

Set GLD = Workbooks("GLD_US_archive_EN(" a ").csv")

I receive a compile error expected: list separator or )

How can I get around this while continuing to include the variable inside of the brackets?

 

[Fluff]

The same way I showed you, just add the brackets

 

[shg]

Set GLD = Workbooks("GLD_US_archive_EN(" [COLOR="#FF0000"]&[/COLOR] a [COLOR="#FF0000"]&[/COLOR] ").csv")

 

[SBF12345]

Shoot...i'm sorry...got it

Thanks!