Can ADO use to pull data from files stored at SharePoint

I think I better started another thread about ADO, hope someone who has the knowlege on it can help.

A bit of background is : I have 2 spreadsheets, one is like a form for users to fill in a customer number, then click the “Get data” button to initial a macro, which will connect to another Excel spreadsheet located in the company intranet, to search the records database which is over 10,000 rows, once found, to return the customer information like purchase date, what produce, what model….etc. back to the Result.xls

Leith from the Forum has kindly shown me how to do it by using the FIND function, unfortunately, I don't want to open the Data.xlsm file while searching the data to make the process faster. Leith suggested ADO.

I've been able to use the below ADO script I found on the web, it works perfectly when the Data.xlsm is local, once I point to the actual Data.xlsm file which is located in the Sharepoint, I have the 'run time error '-2147467258(80004005)': Invalid internet address. The script stopped at oRS.Open sSQL, sConnect, adOPenForwardOnly, _adLockReadOnly, adCmdText. Any idea??

Please Login or Register  to view this content.

Is ADO cannot use to connect files located in http??

Thanks & regards.