Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Importing info from a web page
#1
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!!!
#2
Possibly you can record the macro. Or enter it (or part of it) using dialogs.

Or, do it programmatically, like in the following code.

Code:
Copy      Help
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.
#3
That sounds good - I'll see if I can fumble my way through - thanks for your help


Forum Jump:


Users browsing this thread: 3 Guest(s)