I have a url that I can go to manually, click on a zip button and download the zip file fine; I can see the file and open it.
But when I try to automate downloading this using VBA in Excel I can download to a MyDocs folder and see that it is there. But when I try to open it I get a message that says "Windows cannot open file. The compressed folder xxxxx is invalid.
I'm in Windows 7 and Excel 2010.
Any ideas? thankx