Code Issue to Extract Data from Online Web Source (.csv)

[bknight2602]

I have some code that returns the above message sometimes, not all the time.
The web site is worldwideweb dot cboe dot com/publish/scheduledtask/mktdata/datahouse/vixcurrent.csv
The site contains public information that can be opened in Excel.
What I mean by sometimes when I Googled the error and found a close answer on this forum. I went back to the site and checked it and the data was downloaded. I then ran the program and the program ran without errors. This is frustrating behavior because it doesn't manifest itself all the time.
I have added two keys in the registry that I hoped might solve my problem while using Excel 2007.
The two keys are:

Computer\HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings setting a Dword named BypassSSLNoCacheCheck to a value of 1
Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\ForceShellExecute setting a Dword named ForceShellExecute to a value of 1

As one would note both/neither have been successful all the time (one error and one completion just tonight. Any suggestions?

This is frustrating also as I am unable to post the web page or the code

[AliGW]

Welcome to the forum.

You may not, as a new member, post links, however you may post the code in the body of your post and you may attach a workbook (see the yellow banner at the top of the page).

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new, I wil do it for you this time.)

[bknight2602]

As you have changed the thread title, the question remains. Often but not always I get the error message that was in the original title:
"The resource cannot be displayed because the file extension is not being accepted by your browser" I am looking for help in avoiding/bypassing/eliminating the error and being successful in downloading a csv file 100 % of the time. That seemed a bit longer than titles are allowed. I understand your insight on the title.
I attempted to post the code, but since the code contains the web address that prevented the forum from accepting the post, so I left it out.
Now I will add a few facts not presented in the original post, as I was getting pretty frustrated in posting just the first one.
The behavior is exhibited in 3 browsers. So I'm not sure that it is a browser issues, but more of an Excel, but I could be wrong.

You can see the two attempts at editing the registry and that has not worked all the time, as I am posting here.
I'm using Win 10 with Excel 2007. Not too much more to add until posting the code.

Attempted three times to quote you, Ali, but your post contained a web address and this wasn't allowed.

[bknight2602]

I could attach my workbook as it contains public data, no proprietary data, but is there a size limit on them? It is currently 3.45 M.

[AliGW]

Yes - that's too big. We don't need to see the whole workbook - just a sample that contains the relevant code, etc.

There was no need to quote my post - why did you want to?

You can post code as part of the text of your message.

[bknight2602]

I attempted to quote you to answer specific points posted by you.
The code can't be posted since it contains a web address that your restrictions prevents, but let me think of a way to eliminate the Uniform Resource Locator out of the code.

[AliGW]

Just remove the web address from the code - put "web address here" instead.

You don't need to quote the post immediately above your own - it's only necessary if the are separated in some way in the thread.

[bknight2602]

Here is the code snippet

Please Login or Register  to view this content.

The web address was butchered to comply with restrictions.

[bknight2602]

The web address might be prudent to see if others have the same issue.

[AliGW]

Just present it like this:

cboe dot com slash etc.

Once you have posted a few more times, you won't be restricted, It's an anti-SPAM measure.

[bknight2602]

Yes that is what I did essentially. I understand the reasons for restrictions, it is just frustrating when the web address is at the heart of the problem of the download. Grrrrr

[AliGW]

Not really ... You posted this:

world wide web dot cboe dot com/Remainder of address/ vixcurrent dot csv

What should the bit in red be? Let me know and I'll post a clickable link for you.

[Haluk]

This one works for me;

Please Login or Register  to view this content.

.

[bknight2602]

Haluk:
That is the precise address for the code and it works for me SOMETIMES not all the time and thus my issue.

Ali:
See Haluk's code for the address.

[bknight2602]

Haluk:

The error I get when it doesn't work is:
"The resource cannot be displayed because the file extension is not being accepted by your browser"
But it fails in all browsers edge, firefox and ie when it fails, executes in all browsers when it works.
That is why I suspect an Excel issue not a browser issue, but I accept that assumption may be wrong.

[Haluk]

I'm not sure if this helps but, you can try the below code as well...

Please Login or Register  to view this content.

.

[bknight2602]

I added the for loop, good idea.
I will attempt the other corrections Monday night when I refresh the data, I do hope these might fix the issue.
Thanks

[bknight2602]

No issues with my original code so I'll have to and find a day where the code fails to try yours.

[bknight2602]

I did take your code suggestions and ran them on a blank sheet. I should have guessed with the word "TEXT" what the result would be, but I didn't. I did this bit of code, but then I had to run a function TextToNumber or something similar to put the text into numbers for ease of putting the numbers into my sheet. I abandoned that procedure and went to adding a VixData sheet taking number from that sheet into the Vix sheet and then deleting the VixData sheet. But thanks for the suggestion anyway.

[Haluk]

You don't need to do those extras.... just delete the below line;

Please Login or Register  to view this content.

and add the following lines, to make life easy...

Please Login or Register  to view this content.

.

[bknight2602]

For all that don't know, what does the 3 indicate in the Array?

[Haluk]

3 stands for the 1st column format as "Date"

2 stands for other columns format as "Text" and 1 formats the column as "General"

.

[bknight2602]

Well the web page did not open and reported the same error message as described in post #15.
This morning it opened and downloaded as coded.
Thus my original issue remains there is some setting in the pc, either in all the browsers (not likely in my opinion) or within Excel.
I will post all the known parameters so all will not have to scroll back.
Windows 10, Excel 2007 (Not sure which service pack, but I believe it to be 3 or latest provided by MS)