1.

Solve : excel programming macro on web change event?

Answer»

I need to write a macro to capture the data from one SHEET, and write to another sheet with time stamp.
Next refreshed data to be written in the next row.
The data is changing dynamically using WEB refresh

please help capture data from one sheet:
- range OBJECT
- for each c in activesheet.usedrange

write to another sheet:
- range.copy method

timestamp:
- now(), date(), time() function

look it up by hitting F1 on VBA IDE



Discussion

No Comment Found