ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Use string value for database location - VBA (https://www.excelbanter.com/excel-worksheet-functions/230925-use-string-value-database-location-vba.html)

[email protected]

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

Dave Peterson

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


All times are GMT +1. The time now is 04:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com