17th October 2005, 04:06 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
DR,
It should work fine, I've tested it extensively, you might have not configured the macro correctly.
Here's the workbook attached.
Right click the link and select save target as and download it to your desktop before opening.
Make sure that your security settings for Excel are set to low, or it may not run.
Open it
Select Tools
Macro
Macros
Run
Viola!
The major drawback is that you have to manually enter the web addresses, which I've yet to find a solution to, and I'd prefer to only download select information and manipulate the entries and formatting, but I'll stick with it for now. |