In order ro connect the Excel file will I need Excel installed on my computer.
See code below.
Private m_oXlsTests As ADODB.Connection
Private m_oRdsTest As ADODB.Connection
Set m_oXlsTests = New ADODB.Connection
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("Extended Properties") = "Excel 8.0"
strFileName = App.path & "\Tests.xls"
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…