LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default Using Excel to download a batch of files from a website

Okay, I am lost.

I have about 300 test reports in Doc format on my the company website in a
location that can't be mapped or shared. I was hoping to write a macro in
Excel to rip through a list of filenames and copy them from the internet to a
folder of my choosing. Since I can't map the folder, it is beyond me. I have
tried searching for download and other keywords and haven't found anything I
think will apply.

This will save me hours of clicking and choosing save as. Thanks.
I don't mind doing this in a Dos Batch file if anyone knows how to access a
webdirectory via Dos.

Thanks.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I download data into MS Excel from a Website that takes a l XL Baby Excel Worksheet Functions 3 May 11th 07 04:47 PM
Download excel doc from website, can this be done? Billznik Excel Worksheet Functions 1 August 9th 06 08:22 PM
want to download csv file from website and need to open in Excel. Jeff Excel Discussion (Misc queries) 2 January 17th 06 05:35 PM
can Excel connect and download data from a Stockmarket Website? Brook Excel Programming 1 November 16th 05 07:55 PM
Download data from website Sanjay Singh Excel Programming 3 April 21st 04 10:39 PM


All times are GMT +1. The time now is 06:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"