How to put variable in text line (ClientNumber)?

[mikeburg]

I have a input box as follows:

Public ClientNumber As String
ClientNumber = Application.InputBox("Enter A/R Client
Number in 4 digits (ex: 0195): ")

What is the proper syntax to get the ClientNumber entered in the input box to work in a file name to be retrieved?
(the following will not work)

With ActiveSheet.QueryTables.Add
(Connection:="TEXT;C:\usr\mike\CL"ClientNumber".MB", _
Destination:=Range("A1"))

Thanks,

Mike

 

[PHV]

Something like this ?
(Connection:="TEXT;C:\usr\mike\CL" & ClientNumber & ".MB", _

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886