Menu

Use string value for database location - VBA

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.worksheet.functions

Dave Peterson Dave Peterson is offline

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 Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel: Use pic location string to call up picuture in cell?	vloh28	Excel Discussion (Misc queries)	1	October 30th 07 12:42 AM
parsing on a date string pulled from a database.	Zone99	Excel Discussion (Misc queries)	3	July 9th 07 11:49 PM
find a character location in a string starting from the right	funtipoom	Excel Worksheet Functions	2	February 15th 07 12:18 AM
Frequency of a word string in an excel database	Danny_McCaslin	Excel Discussion (Misc queries)	2	December 13th 06 06:11 PM
The Template Wizard retains the original location for my database	Packwood	Excel Discussion (Misc queries)	0	April 15th 05 05:25 PM

All times are GMT +1. The time now is 08:21 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement