How to concatenate a variable into an array string on VBA

Question

I'd like to use a variable inside an array like this

path = "C:\test\folder\"

Array("ODBC;DSN=MS Access Database;DBQ=path;")

but am unable to concatenate the variable into this array correctly.

Do you have a suggestion on how to do this?

enderland · Accepted Answer · 2012-08-17 19:15:50Z

5

You can add strings with the & operator directly into commands such as:

Array("ODBC;DSN=MS Access Database;DBQ=" & path & ";")

answered Aug 17, 2012 at 19:15

enderland

14.2k18 gold badges105 silver badges157 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

thx @enderland - i tried that but I get Run Time error 1004 (Application defined or object defined error)

Are you sure that works with your filepath? Try directly copying your filepath into the test you are running instead of =path.