<div>
<div class="content wysiwyg-content">
I have created an Excel file that runs a SQL query on several sheets within the same file. This works fine when the file is saved on the user's PC or in the network folder. However if they save it onto Sharepoint, it stops at the point the connection is being opened saying &quot;Invalid internet address&quot;. I have tried adapting my code to look the same as the URL which works when pasted into IE but this gives the same error. Can anyone help please?<br />
<br />
&nbsp; &nbsp; If Left(strWbPath1, 4) = &quot;http&quot; Then<br />
&nbsp; &nbsp; strWbPath1 = Replace(strWbPath1, &quot;&nbsp;&quot;, Chr(37) &amp;&nbsp;&quot;20&quot;)<br />
&nbsp; &nbsp; Else<br />
&nbsp; &nbsp; End If<br />
<br />
cn1.Open &quot;Provider=Microsoft.ACE.OL<wbr />EDB.12.0;D<wbr />ata Source=&quot; &amp;&nbsp;strWbPath1 &amp;&nbsp;&quot;;Extended Properties=&quot;&quot;Excel 12.0 Macro;HDR=YES;IMEX=1&quot;&quot;;&quot;
</div>
</div>


I have created an Excel file that runs a SQL query on several sheets within the same file. This works fine when the file is saved on the user's PC or in the network folder. However if they save it onto Sharepoint, it stops at the point the connection is being opened saying "Invalid internet address". I have tried adapting my code to look the same as the URL which works when pasted into IE but this gives the same error. Can anyone help please?

    If Left(strWbPath1, 4) = "http" Then
    strWbPath1 = Replace(strWbPath1, " ", Chr(37) & "20")
    Else
    End If

cn1.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strWbPath1 & ";Extended Properties=""Excel 12.0 Macro;HDR=YES;IMEX=1"";"

Excel ADO Connection to file on Sharepoint site

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.