Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > Import web data into Excel 2008?

Import web data into Excel 2008?
Thread Tools
Professional Poster
Join Date: Jan 2001
Location: Between Sydney and Melbourne
Status: Offline
Reply With Quote
Jan 19, 2008, 08:32 PM
 
Any way to do it? the Windows version allows you to do this easily but I can't work out how to do it on the Mac, can Automator help?
     
Mac Elite
Join Date: Aug 2007
Status: Offline
Reply With Quote
Jan 21, 2008, 09:27 AM
 
Originally Posted by moonmonkey View Post
Any way to do it? the Windows version allows you to do this easily but I can't work out how to do it on the Mac, can Automator help?
No idea, but I would like to know also. VMWare works for now, sadly.
MacBook Pro 13" 2.8GHz Core i7/8GB RAM/750GB Hard Drive - Mac OS X 10.7.3
     
Moderator
Join Date: Dec 2000
Location: Polwaristan
Status: Online
Reply With Quote
Jan 21, 2008, 09:36 AM
 
A lot of times you can hold and drag your cursor across a web page, then copy it into Excel. Don't know if that helps in your case. If you have a particular page in mind, I'll give it a try with my Excel 08.
     
Professional Poster
Join Date: Jan 2001
Location: Between Sydney and Melbourne
Status: Offline
Reply With Quote
Jan 22, 2008, 02:06 AM
 
What I want to do is pull stocks data (just one number) directly into excel from a webpage every evening after the markets close.

I managed to get automator to isolate the text string from the webpage and use the new excel actions to paste it into a predetermined cell, but its always the same cell! (and I would rather not use the clipboard).
No way I can see to assign a variable to the cell.



The Excel automator actions seem to be very rushed, what would be so hard about having a "Place data in next empty column or row" action.


In Summary:
I want an automator action or Applescript that can pull a string from a webpage and place it in the next available cell in a predefined column in a pre-created excel 2008 workbook.

Possible?
(Last edited by moonmonkey; Jan 22, 2008 at 02:35 AM. )
     
   
Thread Tools
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 03:55 PM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2