System-wide macro program

  • Thread starter Thread starter Shatin
  • Start date Start date
S

Shatin

I have a task which involves the following:

- copy a web page
- push a command button on an Excel spreadsheet to run a vba macro
- repeats above "copy web page and run Excel macro process" for several
worksheets in the same workbook

I have to do that because the data on the web page cannot be imported into
Excel directly.

My questions:

- Does anyone have a good Windows system-wide macro program to recommend?
- Would the macro program be smart enough to push the command buttons? Or do
I have to make it easier for the macro program by using menu items to run
the vba macro?

TIA
 
Shatin said:
I> My questions:

- Does anyone have a good Windows system-wide macro program to recommend?
Click to expand...

Since you are in an Excel NG, I assume that you think Excel might be able to
do it. It should be able to. VBA has a lot of powerful features, and can
call Windows APIs if necessary.

- Would the macro program be smart enough to push the command buttons? Or do
I have to make it easier for the macro program by using menu items to run
the vba macro?
Click to expand...

You could use SendKeys to 'press' the buttons, but if you don't want human
interaction, it seems pointless to have buttons. You seem to want
automation, so you could use workbook open events to trigger your code, or
worksheet events that fire the code when a certain condition in a worksheet
is met.
 
Bob,

My knowledge of Windows APIs is non-existent, so I thought I might need an
Windows macro program to help me. If I am going to take the pure Excel VBA
route, any pointers on how to activate IE, select copy area, etc.?

Thanks!
 
Back
Top