Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

為了改善您的使用體驗,本網站正在進行維護,部分功能暫時無法使用。若本站的文件無法解決您的問題,想要向社群發問的話,請到 Twitter 上的 @FirefoxSupport 或 Reddit 上的 /r/firefox 發問,我們的社群成員將很快會回覆您的疑問。

搜尋 Mozilla 技術支援網站

防止技術支援詐騙。我們絕對不會要求您撥打電話或發送簡訊,或是提供個人資訊。請用「回報濫用」功能回報可疑的行為。

了解更多

VBA hyperlink start to act strangly today: cannot download *csv files from finance.yahoo.com anymore without opening browser. What changed?

more options

I use the same VBA program (unchanged for ages) to download sequentially many *.csv files from finance.yahoo into Excel without actually opening Firefox. The program uses "ActiveWorkbook.FollowHyperlink Address:=name" to get each file in Excel, manipulates file a little, saves it, and then asks for the next "name" in a loop. Today the hyperlink opens Firefox window which than open new tab and new Excel window for each requested file. And after few (3 or 4 loops) it kills the VBA code and hangs up.

I use the same VBA program (unchanged for ages) to download sequentially many *.csv files from finance.yahoo into Excel without actually opening Firefox. The program uses "ActiveWorkbook.FollowHyperlink Address:=name" to get each file in Excel, manipulates file a little, saves it, and then asks for the next "name" in a loop. Today the hyperlink opens Firefox window which than open new tab and new Excel window for each requested file. And after few (3 or 4 loops) it kills the VBA code and hangs up.

所有回覆 (11)

more options
more options

No, I am not forcing Firefox to do anything. Actually I do not want it to open either new tab or new window, or even start Firefox. All download was going in the background before this strange behavior started few days ago on my laptop (w7). My other (desktop) PC(XT) behaves normally: downloads files in the background without any browsers open, manipulates downloaded file, saves it and goes to download next one according to prearranged schedule. The laptop also lost ability for wireless connection to the internet a day or two after. Coincident? Or some screw-up in internet linking s/w? Restoration of the laptop system from earlier safety point doesn't help.

由 albgr 於 修改

more options

If you haven't already, try making Internet Explorer your default browser to see whether that helps.

more options

And no, setting was not changed in any way. Running the VBA program that downloads and process downloaded files is a routine procedure that is done almost every day. The code changes only occasionally, and only within the processing part. The downloading part has not been changed for years. When the last time (2 or 3 years ago) yahoo rearranged its file storage structure only the access string was adjusted to recognize the new structure.

more options

Tried that already. Also tried Chrome. With similar results.

more options

That's why I am suspicious of broken wireless. Although I do not understand how broken wireless could cause this behavior. I assume that wired and wireless do not share any s/w. Or they do? I do not want to do anything drastic and time consuming (like reinstall the entire system).

more options

Just in case I compared browser.link setting on both machines and they are the same. However one machine (desktop XT) works and laptop (W7) does not. Wireless on the laptop is switched off, so both machines are on wired connection.

more options

Is there anything different in the connection settings between the two PCs? I imagine that Excel uses your IE connection/proxy settings.

http://windows.microsoft.com/en-us/windows/change-internet-explorer-proxy-server-settings

more options

There is no diff. in setting.

more options

Still grappling with the same problem. Any other suggestions?

more options

Could you try Microsoft's forum for Excel support? Maybe there is an Excel setting which is changing the behavior, or at least they may be more familiar with potential glitches with the FollowHyperlink method.