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?