View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] wolfbrain@gmail.com is offline
external usenet poster
 
Posts: 1
Default Use string value for database location - VBA

I posted earlier, but I think I may have been too obtuse.

I have a string value:

Dim DBLocation As String

Then I have a database connection which I want to use the DBLocation
for the DQB.

DBQ=DBLocation

I can't seem to get it to work....

THanks,
Brian