What would happen if?

[DChambers]

What would be displayed in the MsgBox if I did this:

Dim Msg1 As String
Dim FN1 As Variant
Msg1 = "opening file 'FN1' "
'
'Later in code
'
Get FN1
'
'Later in code
'
MsgBox Msg1
'
I know code is not right but meaning should be clear.

Anyone?

 

[Mike Blackman]

Hi,

Surely this would be shown in the msgbox;

opening file 'FN1'

 

[KWMSeattle]

Your messagebox would say: opening file 'FN1'

You probably want to set Msg1 to this

Msg1 = "opening file "

Then once you have FN1 run this

Msgbox Msg1 & FN1

 

[DChambers]

Hi Mikey and KWMSeattle,

Mikey you are right the way I showed it and KWM that is the normal way to do it - I just did not make myself clear, I think I know what would happen now - since FN1 was not set it would probably be a null string.

Sorry for the confusion and thanks for your help!