Howdy,

I need to write a macro that pulls data from a closed excel spreadsheet on the internet into an open spreadsheet on my hard-drive. Is this possible using ADO or RDS? I have tried using ADODB.Recordset with Provider=MS Remote, but I could not get it to work. Can anyone give me a sample connection string for an online excel spreadsheet? Also, which object library should I be using? Any suggestions?

Thanks,
Paul