Hi David, I pasted it in my browser, and it opened. Will it open for you if you paste it in your browser?
Tim
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com]
Sent: Tuesday, June 28, 2016 5:05 PM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] URL opens file but fails
I am trying to get an Excel to open from the following:
ActiveWorkbook.FollowHyperlink strURL
strURL = http://finance.google.com/finance/historical?histperiod=daily&q= CALM&startdate=Jan+1%2C+1975&enddate=1+27%2C+2010&output=csv
The above use to work just fine, but fails with "This operation has been cancelled ...... restrictions in effect on this computer. Please contact your system administrator"
I am not aware of any changes that i might have made to cause this.
Thank you in advance for your time and efforts.
Thanks, David
Posted by: "Tim Lewis" <twlewis@reagan.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar