internet connection via excel macro
 

Hi,
Can experts help me on this:
I need to see a macro code that establishes an internet connection to a web
site
and retrieves data from a *.xls or *.mdb file there. Being able to modify
that data, add and delete will be extra good features.
Can you give me a d/l link for such an example
Thanks
J_J

internet connection via excel macro
 

sUrl = "c:\www.somesite.com\somefolder\somefile.xls"
Workbooks.Open sUrl

will bring a copy of the file down and load it in excel.

However, if you are talking about updating and saving it back to its
location, I wouldn't know if you can do that or not. It would definitely
seem ludicrous to have unsupervised access to the source file.

--
Regards,
Tom Ogilvy


"J_J" wrote in message
...
Hi,
Can experts help me on this:
I need to see a macro code that establishes an internet connection to a
web
site
and retrieves data from a *.xls or *.mdb file there. Being able to modify
that data, add and delete will be extra good features.
Can you give me a d/l link for such an example
Thanks
J_J

internet connection via excel macro
 

Thank you for the speedy reply.
Best wishes
J_J

"Tom Ogilvy" wrote in message
...
sUrl = "c:\www.somesite.com\somefolder\somefile.xls"
Workbooks.Open sUrl

will bring a copy of the file down and load it in excel.

However, if you are talking about updating and saving it back to its
location, I wouldn't know if you can do that or not. It would definitely
seem ludicrous to have unsupervised access to the source file.

--
Regards,
Tom Ogilvy


"J_J" wrote in message
...
Hi,
Can experts help me on this:
I need to see a macro code that establishes an internet connection to a
web
site
and retrieves data from a *.xls or *.mdb file there. Being able to modify
that data, add and delete will be extra good features.
Can you give me a d/l link for such an example
Thanks
J_J