Quote marks and variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know you have already given me the answer on this but I just can't find it
and am going nuts here. I have three variables
MyPath = network path name - string
MyCountry = country name -string
Myfile - file name - string

When I try the statement it just wont work
MyImport = "MyPath&MyCountry&MyFile"

Any help would be very much appreciated
 
assuming that MyImport is a String variable also, the correct syntax would
be

MyImport = MyPath & MyCountry & MyFile

hth
 
Why are you putting the quotes? Is it because you want quotes around the
concatenated values of the variables?

If so, you need

MyImport = """" & MyPath&MyCountry&MyFile & """"

or

MyImport = Chr$(34) & MyPath&MyCountry&MyFile & Chr$(34)

Other than that, you don't want the quotes: as you've doubtlessly
discovered, doing so sets MyImport to the literal string
MyPath&MyCountry&MyFile
 
I know you have already given me the answer on this but I just can't find it
and am going nuts here. I have three variables
MyPath = network path name - string
MyCountry = country name -string
Myfile - file name - string

When I try the statement it just wont work
MyImport = "MyPath&MyCountry&MyFile"

Any help would be very much appreciated
Click to expand...

Remove the quotes.

MyImport = MyPath & MyCountry & MyFile

If the individual strings do not include the "\" separator, then:

MyImport = MyPath & "\" & MyCountry & "\" & MyFile
 
Back
Top