Variable does not accept value

[farmock2]

I have installed Excel 2016 on a new computer and when I run the following macro, the variable symBol does not
accept the value GDX. It just shows "" as the value. The macro works fine on another computer running Excel 2013.

Sub RunBTSlong() Dim symBol As String

symBol = GDX

Workbooks.Open Filename:= _

"http://www.marketwatch.com/investing/fund/" & symBol End Sub

<tbody>
</tbody>

Can anybody help? Is there a setting that needs to be changed? Thanks in advance. Frank

 

[Joe4]

If you want the literal string GDX, you need to enclose it in quotes, i.e.

symBol = "GDX"

Otherwise, it is looking for a variable named GDX, which is not set, so has no value, so is equal to "".

If you put "Option Explicit" at the top of your code, it will catch errors like this.
See: http://www.excel-easy.com/vba/examples/option-explicit.html

 

[farmock2]

Thanks so much. It has been a while since using macros and forgot that. Your quick response is genuinely appreciated

 

[Joe4]

You are welcome.