| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA SQL - variable Source Data...
Thanks a lot Bob!
It works! :-) SpeeD "Bob Phillips" wrote: ..Connection = Array("OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=" & CAM & ";Mode=Share De" -- HTH Bob "SpeeD" wrote in message ... Hi. I'm new a this Excel/Sql thing. so bare with me :-) My my problem is that i need to add several different (variable) SQL queries to my WB so i´ve add the following with no success: Cam = ActiveWorkbook.Path & "\" & "JB.xls" .. .Connection = Array("OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=CAM;Mode=Share De" it only works if i specify the complete path, not variable .Connection = Array("OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\TRABALHOS\2010\Março\JB.xls;Mode=Share De" How can a make my variable with the Path work? Thanks for reading this SpeeD . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Names in Source Data References in Charts | Charts and Charting in Excel | |||
| Variable row data source for combo boxes? | Excel Programming | |||
| Variable VLOOKUP source and target | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| How do i change the graph source data to a variable dependent on the value in a cell | Excel Programming | |||
Threaded Mode
