Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default How to get Excel to grab data from browser?

Can someone get me started with a solution to this problem? I want to
be able to navigate to a page in IE and pass the URL to Excel. Saving
the URL in say cell B1, then allow the user to enter a note in cell
A1, either directly or via a form. The next URL from the browser is
entered in B2 and its comment in A2 and so the process continues.

In summery so it behaves like a commented history.

Do I need to get IE running within Excel somehow?

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default How to get Excel to grab data from browser?

If you are in Explorer, you can right-click on the data and an option will
popup asking if you want to 'Export to Microsoft Excel'.

If you want to import into Excel, then follow these steps:
Data Import External Data New Web Query.
Then navigate to the site that you want to import from.
Click the yellow arrow next to the data that you want to import, the arrow
will turn into a green check mark, and then click import. Choose the cell
that you want to import to and complete the import.

Regards,
Ryan---

--
RyGuy


"grove" wrote:

Can someone get me started with a solution to this problem? I want to
be able to navigate to a page in IE and pass the URL to Excel. Saving
the URL in say cell B1, then allow the user to enter a note in cell
A1, either directly or via a form. The next URL from the browser is
entered in B2 and its comment in A2 and so the process continues.

In summery so it behaves like a commented history.

Do I need to get IE running within Excel somehow?

Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default How to get Excel to grab data from browser?

Its the URL I want to extract, not the data on the page ....?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF function to grab data mike Excel Worksheet Functions 1 February 25th 09 02:22 AM
Moving Data from a Web Browser to Excel JohnHill Excel Discussion (Misc queries) 0 April 27th 06 04:06 AM
Excel vb help: How to grab the right Data [email protected] Excel Programming 0 August 23rd 05 12:12 PM
Grab Last Name data within Title and Name vamosj Excel Programming 1 October 29th 04 04:34 AM
Software of scripting to grab data from MS word file and fill in Excel fields? Joe Blo Excel Programming 2 October 6th 04 09:54 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"