Since every webpage will have different tables and data the best way to staer
ia to record a macro while you are performing the operation manually and then
modifiy the the recorded macro as necessary. Record macros are not general
purpose and range need to be modified. also there is a lot of erraneous
instructions that can be eliminated or wimplified after the macro is
recorded. for example recorded macros contain scrolling statements that are
not needed when trying to automate the saving of web data to a datebase.

1) On worksheet menu - Tools - Macro - Record new macro
2) On worksheet menu - Data - Import External Data - New Web Query
3) Save Excel data to your database
4) On worksheet menu - Macro - Stop Recording

You can post your recorded macro if you need additional help.

" wrote:

Hello,

I use often a certain spreadsheet to get data from a website. To store
this data, I manually copy this data the an access database. However,
I know this can be done automatically (probably using VBA), but I
don't have a clue how to do this. Anybody an idea??