Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chartspace Data Source and Connection String Problem
I've embedded the activex chart control on a form. It needs to pull data from
an access database. When hardcoded into properties, the chart works fine, but I'd like to dynamically be able to pull the data from whatever directory the file may reside in. Here's the code that isn't working, thoughts appreciated 'Create variable for connection string less path Dim strConnection As String 'The access db has the same name as the workbook strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Left(ActiveWorkbook.FullName, Len(ActiveWorkbook.FullName) - 4) & ".mdb;Persist Security Info=False;Jet OLEDB:Database Password=;" frmMain.ChartSpace1.ConnectionString = strConnection frmMain.ChartSpace1.DataMember = "qryDJIA" frmMain.ChartSpace1.Refresh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data connection and formatting problem | Excel Discussion (Misc queries) | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
Problem getting external data using an existing connection | Excel Discussion (Misc queries) | |||
oledb connection string problem in vb.net | Excel Programming | |||
Problem: Residual query data? Closing external connection? | Excel Programming |