Excel Macro to control other programs

[triplell89]

So I'm at work and one of my co-workers needs like 1000 accounts entered into a web user interface manually. Sure, I could just knock it out, but the mouse clicks are always the same. I've used macro's for games back in my script kiddie games, however I can't install these programs on my work computer.

Is there someway that I could use VBA for this task?

 

[ajetrumpet]

if you're on the web, record a macro and click around using the web query wizard that is built in to excel

 

[triplell89]

I looked for some information about doing that on the web, but I couldn't find anything. Do you care to explain?

 

[ajetrumpet]

what i meant by this was that there is a web query utility in the excel program that you can use. do you know where that is? I think it's under the tools> MENU. it's somewhere near the MACROS menu item in that menu.

do a web query with excel and record your mouse clicks with the macro recorder and see what pops into the vba window from microsoft.