ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "Invalid internet address" during ADO (https://www.excelbanter.com/excel-programming/282471-invalid-internet-address-during-ado.html)

Dean Frazier

"Invalid internet address" during ADO
 
I'm trying to access an Excel file on the internet via ADO, and get an
"invalid internet address" error message. Here's the code.

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "http://www.mysite.com/myfile.xls" & ";" & _
"Extended Properties=""Excel 8.0;HDR=Yes"""

It works for a local file, just not for a file on the internet.

Any suggestions?

Thanks,
Dean


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com