Excel Help with Network based Excel VBA solution


Joined
Mar 3, 2011
Messages
1
Reaction score
0
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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top