I am writing a macro using ADO to pull data from an excel spreadshee
located on the internet. The macro works fine when the connectio
string points to a file on my hard-drive. However, when I change th
connection string to a file on my company's web-based portal (i.e
"http://portal.company.com/testing/test.xls"), I receive the erro
"Invalid internet address." The server is password protected, but i
recognizes my windows logon and does not require me to input a passwor
when I access the file directly. Is this feasible or must I use a we
query instead

--
paulharve
-----------------------------------------------------------------------
paulharvey's Profile: http://www.excelforum.com/member.php...fo&userid=2522
View this thread: http://www.excelforum.com/showthread.php?threadid=39291