Trending News

John Geddert. (AP)

Ex-U.S. gymnastics coach dies by suicide amid scandal

An American Airlines passenger jet. (AP)

Pilot: 'We just had something go right over the top of us'

Rosamund Pike. (AP)

Rosamund Pike: I've been Photoshopped for film ads

Costco store in Tacoma, Wash. (AP)

Major retailer raises its minimum wage

Mr. and Mrs. Potato Head. (Getty Images)

Mr. Potato Head goes gender neutral — sort of

Charlie Sheen. (Getty Images)

Sheen was 'winning' 10 years ago. Now he has regrets.

Joe Biden. (Getty Images)

'It harms the United States': Biden lifts Trump-era ban

Justin Foster. (AP)

Clemson player retires after COVID-19 complications

Marjorie Taylor Greene. (Getty Images)

Historic LGBTQ rights bill exposes ugly rift in GOP

President Joe Biden. (Reuters)

The words that are in and out with Biden

Calvin and Tina Tyler with Morgan State University president David K. Wilson. (Paul "P.A." Greene/Morgan State University)

Dropout donates $20M to college he couldn't afford

More trending news?Visit Yahoo Home

Promoted

* asked in 電腦與網際網路程式設計 · 1 decade ago

VBA如何匯網路資料?

VBA如何匯網路資料"http://mis.tse.com.tw/Quotes/Stock?Category=13=53&...

2 Answers

Rating

微軟卓越魔人
Lv 6
1 decade ago
Favorite Answer
是Excel VBA的話，可以把這個網址當成一個檔案來開啟，執行的結果會自動傳回Excel的sheet中。
Workbooks.Open Filename:= "http://mis.tse.com.tw/Quotes/Stock?Category=13=53&...
丫賢！！
1 decade ago
請問用workbooks.open完都會出現檔案開啟的視窗，要如何不讓他出現？

Still have questions? Get your answers by asking now.