How to use Global variable in Windows( ).Activate

[capson]

<tbody style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; background-color: transparent;">
[TD="class: votecell, bgcolor: transparent"]

​

[/TD]
[TD="class: postcell, bgcolor: transparent"]I have set some Global variables and they are working, without the GV I have<code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">Windows("LimeSurveyTokenTable.csv").Activate</code> and this is working.
I need <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">Windows("LimeSurveyTokenTable_ & strA & .csv").Activate</code> where strA is a Global variable
This is not working
There is a file called <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">LimeSurveyTokenTable_ Andrea.csv</code> where <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">strA=Andrea</code>
Thanks


[/TD]

</tbody>

 

[shg]

Workbooks("LimeSurveyTokenTable_ " & strA & ".csv").Activate

 

[capson]

Hello shg, it turns out that <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">Workbook("LimeSurveyTokenTable_" & strA & ".csv").Activate</code> has to be<code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">Windows("LimeSurveyTokenTable" & "_" & strA & ".csv").Activate</code>. It did not like the<code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">LimeSurveyTokenTable_</code>. Thanks

Tim

 

[GermanPath]

It did not like the space character:

Workbooks("LimeSurveyTokenTable_" & strA & ".csv").Activate

 

[shg]

Not Workbook(), Workbooks().

The strings "LimeSurveyTokenTable_" & strA & ".csv" and "LimeSurveyTokenTable" & "_" & strA & ".csv" are identical