Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 752
  • Last Modified:

Compressed Folder is invalid

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
0
MarkH12518
Asked:
MarkH12518
  • 10
  • 9
  • 2
1 Solution
 
Martin LissRetired ProgrammerCommented:
Can you show the code you use to download the folder? Also just to be sure, what do you mean when you say "when I try to open it"? In other words how are you trying to open it?
0
 
MarkH12518Author Commented:
When I try to open it by either double clicking it or right click>open on the compressed file. I have it on the Windows Compressed file, but I got the same results using WinZip.

This is the actual url i'm going to and you can see the zips there. All of the string paths, etc in the code below are correct.

Thanks for looking.


http://mis.ercot.com/misapp/GetReports.do?reportTypeId=13057&reportTitle=48%20Hour%20Ancillary%20Services%20Reports&showHTMLView=&mimicKey

Public Sub DownloadFile()
    Dim objWHTTP As Object
    Dim strPath As Variant
    Dim strFile As Variant
    Dim arrData() As Byte
    Dim lngFreeFile As Long
   
    On Error Resume Next
        Set objWHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1")
        If Err.Number <> 0 Then
            Set objWHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1")
        End If
    On Error GoTo 0
   
    strPath = Cells(10, 3)
    strFile = Cells(12, 3)
   
    objWHTTP.Open "GET", strPath & strFile, False
    objWHTTP.Send
    arrData = objWHTTP.ResponseBody
   
   

   
   
    If Len(Dir("C:\Users\Mark\Documents\Apex\ErcotDataCapture", vbDirectory)) = 0 Then
        MkDir "C:\Users\Mark\Documents\Apex\ErcotDataCapture"
    End If
   
    lngFreeFile = FreeFile()
    Open "C:\Users\Mark\Documents\Apex\ErcotDataCapture\" & strFile For Binary Access Write As #lngFreeFile
        Put #lngFreeFile, 1, arrData
    Close #lngFreeFile
   
    Set objWHTTP = Nothing
    Erase arrData
End Sub
Public Sub Download_File2(ByVal vWebFile As String, ByVal vLocalFile As String)
Dim oXMLHTTP As Object, i As Long, vFF As Long, oResp() As Byte

'You can also set a ref. to Microsoft XML, and Dim oXMLHTTP as MSXML2.XMLHTTP
Set oXMLHTTP = CreateObject("MSXML2.XMLHTTP")
oXMLHTTP.Open "GET", vWebFile, False 'Open socket to get the website
oXMLHTTP.Send 'send request

'Wait for request to finish
Do While oXMLHTTP.readyState <> 4
DoEvents
Loop

oResp = oXMLHTTP.ResponseBody 'Returns the results as a byte array

'If Len(Dir("C:\Users\Mark\Desktop\ErcotDataCapture", vbDirectory)) = 0 Then
      '  MkDir "C:\Users\Mark\Desktop\ErcotDataCapture"
    'End If
   
Dim strFile As String
strFile = vLocalFile

vLocalFile = "C:\Users\Mark\Desktop\ErcotDataCapture\" & strFile

'Create local file and save results to it
vFF = FreeFile
If Dir(vLocalFile) <> "" Then Kill vLocalFile
Open vLocalFile For Binary As #vFF
Put #vFF, , oResp
Close #vFF

'Clear memory
Set oXMLHTTP = Nothing
End Sub
0
 
KyleSWCommented:
I can't open the link you've posted, but I've always used the Stream Object for downloading files, give this a whirl and see if it works for you:
Sub TestDownload()
    DownloadFile "http://www.rondebruin.nl/files/SendMail(Attachment)Testers.zip", "C:\Users\Public\testzip.zip"
End Sub


Sub DownloadFile(url As String, LocalFile As String)

Dim fle() As Byte

With CreateObject("MSXML2.XMLHTTP")
    .Open "GET", url
    .Send
    Do: DoEvents: Loop Until .readystate = 4
    fle = .responsebody
    With CreateObject("ADODB.Stream")
        .Open
        .Type = 1
        .write fle
        .Position = 0
        .SaveToFile LocalFile
        .Close
    End With
    .Abort
End With

End Sub

Open in new window

0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
MarkH12518Author Commented:
Thanks. I'm still getting the same result. Windows cannot open. Compressed file is invalid.
Frustrating.

Mark
0
 
KyleSWCommented:
hmmm very strange - does the above code work for you with the TestDownload() zip?
0
 
MarkH12518Author Commented:
no, i used that code on my last effort. I had a Microsoft tell me that all the data retrieved in .responsebody is string, but i tried converting and got the same result. thx
0
 
KyleSWCommented:
ResponseBody isn't technically a string, it's a byte array. ResponseText is the string version

It's really odd that the zip file from the site I posted doesn't work, it works fine on my computer. I could understand it if the code from the link you posted didn't work since it's inconceivable that it might want cookies passing to it before it allows you to download.

One thing to try would be to Debug.Print the response text and see if it returning something other than a zip file, my guess would be that this is what's happening, you're naming it as a zip file but it isn't really so windows can't open it
0
 
MarkH12518Author Commented:
yeah, i get a bunch of this with debug.print on fle


????????????????????????????????????????????????????????????????????????????????????????????•???????????????????????????????•????????=????????????????????????????????????????•??????????????????????????????????????????????????????•??????????????????????????????????????????????????????????????????????????????•?????????????????????????????????????????????????4??????•???????•????????????????????????????????????††††?†††?††††?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
???????????6??????????????????????????????????????????????????????????????????????????6????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6??????????????????????????????????????????????????????????????????????????6?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????n???4?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6??????????????????????????????????????????????????????????????????????????6????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6???
?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6??????????????????????????????????????????????????????????????????????????6????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6??????????????????????????????????????????????????????????????????????????6????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6???????????????????????????????
???????
0
 
KyleSWCommented:
No, don't debug.print fle.

You need to debug.print the response text, using your url:


Sub DownloadFile(url As String, LocalFile As String)

With CreateObject("MSXML2.XMLHTTP")
    .Open "GET", url
    .Send
    Do: DoEvents: Loop Until .readystate = 4
    debug.print .responsetext
    .Abort
End With

End Sub

Open in new window

0
 
MarkH12518Author Commented:
Hey, no you're file did work. It did open up and work correctly. It's mine that won't work.
0
 
KyleSWCommented:
Yes, that's what I thought. try the above code and see what you get. I'll bet it dumps a load of HTML
0
 
KyleSWCommented:
or actually, just change the extension of the zip file you've tried to download from .zip to .txt and see if you can open it with notepad
0
 
Martin LissRetired ProgrammerCommented:
What are you trying to do with this code?

    On Error Resume Next
        Set objWHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1")
        If Err.Number <> 0 Then
            Set objWHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1")
        End If
    On Error GoTo 0

Open in new window


What that says in English is "create the object and if you get an error then create it anyhow" which doesn't make sense to me.

Try it without the On Error Resume Next. What happens? Is there an error?
0
 
MarkH12518Author Commented:
Ok, if I download it and call it a .txt file I get something I can open. But I'm wide open here I guess. How do I download programmatically and get access to the csv files that are inside the zip folders here?

thx

http://mis.ercot.com/misapp/GetReports.do?reportTypeId=13057&reportTitle=48%20Hour%20Ancillary%20Services%20Reports&showHTMLView=&mimicKey
0
 
KyleSWCommented:
Well it sounds like you need to pass cookies/some authentication to download from the site.

I can't access the link at all, it just times out. So I can't really give you any more specific help than that. What's the output in the textfile?
0
 
MarkH12518Author Commented:
That's the debug.print result in the immediate window
0
 
KyleSWCommented:
I meant when you open the texfile
0
 
MarkH12518Author Commented:
Here it is





<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>ERCOT MIS</title>
<meta http-equiv="Content-Type" content="text/html"; charset="utf-8">
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">

<base href="http://mis.ercot.com:80/misapp/">
<link href="/misapp/css/vdg.css" rel="stylesheet" type="text/css">
<script language="javascript" src="/misapp/scripts/portletTypeA.js"></script>

</head>

<body>
      
      <form name="PortletTypeAForm" method="GET" action="/misapp/GetReports.do;jsessionid=101C3E87E87CFF5FA8618D3EE108971B.w_prl0176_e4">
      
            <input type="hidden" name="basePath" id ="basePath" value="http://mis.ercot.com:80/misapp/"/>
            
            
            
            
            
       
       
        <table width='800' border='0' cellpadding='0' cellspacing='0' class='tbl_ltTaupe'><tr><td class='hdr_grey'><table width='100%' border='0' cellspacing='0' cellpadding='0><tr class='hdr_grey'><td><b>48 Hour Ancillary Services Reports</b></td><td><div align='right'></div></td></tr></table></td></tr><tr><td><table width='800' border='0' cellspacing='0' cellpadding='4'><tr><td class='labelRequired_ind'><b>Title</b></td><td width='15%' class='labelRequired'><div align='center'><b>XML</b></div></td><td width='15%' class='labelRequired'><div align='center'><b>CSV</b></div></td><td width='15%' class='labelRequired'><div align='center'><b>Other</b></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120904.031740.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=223966526'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120903.031306.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=223645885'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120902.031653.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=223330684'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120901.031119.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=223017490'>zip</a></div></td></tr></table></div><table width='100%'><tr><td class='blue_expand_bar'><b><img id='img082012' src='images/ico_arrow_collapse.gif' width='20' height='16' onclick="showHideDiv('div082012','img082012')">August 2012</b></td></tr></table><div style='display:none' id='div082012'><table width='100%'><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120831.031012.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=222677418'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120830.030643.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=222335052'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120829.030740.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=222006582'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120828.030956.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=221674020'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120827.031637.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=221341461'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120826.031322.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=221038084'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120825.031306.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=220732870'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120824.031207.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=220405606'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120823.031935.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=220074942'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120822.030841.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=219746910'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120821.031634.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=219421097'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120820.031223.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=219081994'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120819.031433.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=218781313'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120818.030536.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=218474437'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120817.030626.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=218146061'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120816.031040.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=217823990'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120815.030837.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=217499630'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120814.031237.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=217171058'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120813.031243.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=216834084'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120812.033326.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=216532585'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120811.031944.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=216217102'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120810.031735.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=215886523'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120809.031415.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=215560559'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120808.032533.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=215245414'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120807.031714.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=214911268'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120806.032609.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=214579656'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120805.031343.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=214265300'>zip</a></div></td></tr><tr><td class='labelOptional_ind'>ext.00013057.0000000000000000.20120804.031720.48_Hour_AS_Disclosure</td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'>&nbsp;</div></td><td width='15%' class='labelOptional'><div align='center'><a href='/misdownload/servlets/mirDownload?mimicKey=&doclookupId=213960512'>zip</a></div></td></tr></table></td></tr></table>      
      </form>
</body>
</html>
0
 
KyleSWCommented:
Yes, that's what I thought. You aren't downloading the file, you're downloading the page that the zip files are on. I would say that your link is to the page above, you can see the links to the actual zip files in the above code - these bits:

/misdownload/servlets/mirDownload?mimicKey=&doclookupId=215560559

Try using
http://mis.ercot.com:80/misapp/misdownload/servlets/mirDownload?mimicKey=&doclookupId=215560559

as the url for a zip file and see if it works
0
 
MarkH12518Author Commented:
Ok I'll try that. Thx a lot
0
 
MarkH12518Author Commented:
turns out i need a certificate and some other stuff i was't aware of,

but checked as solution

thanks a lot for all your help

Mark
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 10
  • 9
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now