Real Amateur
Unregistered
Am I able to use macros to go to a web page highlight info and bring it back to place in a spreadsheet? If so can I do it by "recording" or do I have to write everything into the macro?
PS - I know nothing about macros!!!
Posts: 12,073
Threads: 140
Joined: Dec 2002
Possibly you can record the macro. Or enter it (or part of it) using dialogs.
Or, do it programmatically, like in the following code.
Htm el=htm("SPAN" "Posted:*" "" "Quick Macros :: View topic" 0 11 0x21)
str s=el.Text
ExcelSheet sh.Init
sh.SetCell(s 1 1)
This code finds static text field in this page, gets its text, and populates Excel cell A1. Requirements: QM 2.1.7, Internet Explorer or compatible.
Real Amateur
Unregistered
That sounds good - I'll see if I can fumble my way through - thanks for your help