VBA open file: concatenate error -

[jakobt]

Get a syntax error when trying to run this piece of code

Sub Opentb()
dim Entity as string

Entity = InputBox("Which entity")

Workbooks.Open Filename:="S:\Lon_Acct\TB\UK TB_MTD_"&Period&"-en-us.xlsx"



End Sub

 

[steve the fish]

What is Period? You have a variable called Entity but not one called Period.

 

[jakobt]

sub opentb

Dim period As String

period = InputBox("Which Period")






Workbooks.Open Filename:="S:\Lon_Acct\TB\UK TB_MTD_"&Period&"-en-us.xlsx"

End Sub

 

[steve the fish]

Ok now space out the &period&