internet data access in zip file

VBAnewbie · Aug 24th 2004

hi, i have the following problem. any suggestions are greatly appreciated.

there are some .csv files on the net that i wrote a macro to retrieve them automatically, and then save these files in excel as worksheets... however, the website put the older files in zip format, and i'm at a loss how to retrieve those .. the website is http://www.pjm.com/markets/jsp/lmp.jsp

thanks,
Kim

**iwrk4dedpr** · Aug 24th 2004

It looks like you'll need to find a way to control WinZip from excel. The link below talks about using winzip from inside xl so it's a place to start. I'm pretty sure you'll be able to specify a file on the web but I'm not sure. The best bet would be to check the link below and see if you can get the author of the website to furnish futher help.

Good Luck
Regards,

http://xcelfiles.homestead.com/Outlook_02.html

VBAnewbie · Aug 26th 2004

Ah, thanks. : )

Kim

internet data access in zip file

Participate now!

Share