Web page question
-
Open Excel, go File -> Open, Paste in the URL
netclectic wrote:
Open Excel, go File -> Open, Paste in the URL
:omg: Just tried it out! Awesome! Regards, Nish
My blog : Nish’s thoughts on MFC, C++/CLI and .NET
-
Did it work for you Nish? I got a message telling me the document had been permanently moved...:confused:
thealj wrote:
Did it work for you Nish?
Yes. I tried it again just to be sure. I used the following URL :- http://www.westernmininghistory.com/data/gold_production.php[^] Regards, Nish
My blog : Nish’s thoughts on MFC, C++/CLI and .NET
-
netclectic wrote:
Open Excel, go File -> Open, Paste in the URL
Apparently the document has moved....
thealj wrote:
Apparently the document has moved....
No it hasn't, I tried it 1 minute ago and it worked. Regards, Nish
My blog : Nish’s thoughts on MFC, C++/CLI and .NET
-
netclectic wrote:
Open Excel, go File -> Open, Paste in the URL
:omg: Just tried it out! Awesome! Regards, Nish
My blog : Nish’s thoughts on MFC, C++/CLI and .NET
Did it work for you Nish? I got a message telling me the document had been permanently moved...:confused:
-
Did it work for you Nish? I got a message telling me the document had been permanently moved...:confused:
BTW I use Excel 2003. Regards, Nish
My blog : Nish’s thoughts on MFC, C++/CLI and .NET
-
BTW I use Excel 2003. Regards, Nish
My blog : Nish’s thoughts on MFC, C++/CLI and .NET
It would appear that it does not work with Excel 2000. I did, however, fire up Quattro Pro 11 and it worked. Quite interesting, never knew you could use File->Open for a URL.
-
It would appear that it does not work with Excel 2000. I did, however, fire up Quattro Pro 11 and it worked. Quite interesting, never knew you could use File->Open for a URL.
thealj wrote:
It would appear that it does not work with Excel 2000.
Maybe, that's it. Regards, Nish
My blog : Nish’s thoughts on MFC, C++/CLI and .NET
-
With excel 2003 you could capture and even refresh table automatically. 1. Select Data->Import External data->New Web Query 2. Type the URL of the website in the address field 3. Execl automatically allows you to select the table 4. Finally click on Import 5. Select the cells where you want to place the table. 6. You can refresh the data whenever you desire by clicking on refresh data
-
With excel 2003 you could capture and even refresh table automatically. 1. Select Data->Import External data->New Web Query 2. Type the URL of the website in the address field 3. Execl automatically allows you to select the table 4. Finally click on Import 5. Select the cells where you want to place the table. 6. You can refresh the data whenever you desire by clicking on refresh data
Good tip indeed! Thanks.
-
It would appear that it does not work with Excel 2000. I did, however, fire up Quattro Pro 11 and it worked. Quite interesting, never knew you could use File->Open for a URL.
Excel 2000 here and it works fine.
-
Excel 2000 here and it works fine.
netclectic wrote:
Excel 2000 here and it works fine
Very strange. It will not work for me under Excel 2000. It informs me that the document is no longer available. Quattro Pro, on the other hand, will perform the operation successfully.
-
start excel goto website select the table copy, paste into excel
-
start excel goto website select the table copy, paste into excel
-
ahz wrote:
start excel goto website select the table copy, paste into excel
Does this trick work in any browser besides IE? Opera, and FF don't do this.
dan neely wrote:
Does this trick work in any browser besides IE? Opera, and FF don't do this.
hmm, dunno. you can open the website directly from the open file dialog of excel 2003 (and maybe 2000?) -- just type the url of the website in the filename box.