Thread: Use string value for database location - VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Use string value for database location - VBA
Check your earlier post.

wrote:

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

--

Dave Peterson
Reply With QuoteReply With Quote