Automating Procedures and Extracting Data from Websites

[wezwaz]

I have only ever used simple spreadsheets and suspect the answer to my
question involves macros. Am using MS Office Basic Addition Excel 2003.

I want to automate procedures that I do regularly. One is to copy a table
off a website and then massage it by deleting columns/rows, sorting,
formatting, etc.

The second one is to access data piece by piece, i.e. not simply
highlighting a table, and put it into an Excel spreadsheet so it is in
essence looping each time to pick up new data.

Is it possible to fully automate these procedures? I just need guidelines as
to what Excel procedures I need to use. I believe I know enough to then be
able to work it through myself using Excel Help.

Any help would be appreciated. Thanks.

 

[HalB]

I am just starting down the same path.
For the 1st part I used this add in
http://finance.groups.yahoo.com/group/smf_addin/ and it worked very
well for getting the data I needed.

I am still working on the 2nd part so will be interested in this thread.

HalB

 

[Gleam]

I would start by using tools/macros/record new macro to record the actions
you take. Click on Stop rerding button that has popped up and then
tools/macros/ select macro and then edit. You can then look at that code and
edit it.