Help with Network based Excel VBA ADO connection string

[RaoulD]

Hi,

I have an Excel file that uses ADO to connect to one of the sheets and uses it as a database to store and extract data. The connection string that I use works fine with a C:\ or D:\ etc in the string -

sConnect = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=D:\Raoul\Path\Dashboard_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"

However, this file needs to be relocated to a network drive that is named "\\NetworkFolder\NetworkFolder1".

sConnect = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=\\NetworkFolder\NetworkFolder1\Dashboard_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"

When I substitute this for the c:\ or d:\ I get an error that the path is not found. Could someone please help me with this?

Thanks,
Raoul

[Kenneth Hobs]

Create a virtual drive and use that.