Hi,
I have a dashboard that I wish to put on a network folder for easy access to everyone. However, the VBA code in that uses the absolute path to create a connection string. It works fine with something like "c:\<path>". However, when I change the same reference to the network folder path that starts with "\\<network folder>" this does not work. I am using the following code:
This Works:
' Create the connection string.
sConnect1 = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=C:\Dashboard 2011_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"
This Does Not Work:
' Create the connection string.
sConnect1 = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=\\NetworkFolder\Dashboard 2011_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"
Can somebody please help me with this?
Thanks in advance,
Raoul
I have a dashboard that I wish to put on a network folder for easy access to everyone. However, the VBA code in that uses the absolute path to create a connection string. It works fine with something like "c:\<path>". However, when I change the same reference to the network folder path that starts with "\\<network folder>" this does not work. I am using the following code:
This Works:
' Create the connection string.
sConnect1 = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=C:\Dashboard 2011_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"
This Does Not Work:
' Create the connection string.
sConnect1 = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=\\NetworkFolder\Dashboard 2011_v1.2.xlsm;" & _
"Extended Properties=Excel 12.0;"
Can somebody please help me with this?
Thanks in advance,
Raoul