Hi Ajit,

Another option is to use XMLHTTP and ADODB to do it. Here's a link to a
function I wrote to copy any file via HTTP:

http://groups-beta.google.com/group/...f364286?rnum=2


--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Ajit wrote:
Is it possible to write a macro to save a workbook from URL to my c
drive.

eg : i want to save a workbook from "http://...../abc.xla" to
"C:\.....\abc.xla" on a click of a button.

Suggestions will be greatly appreciated.

Thanks,