Demonstrating mouse clicks with Macro

[JEFF]

Hi All,

Wondering how one would go about recording a macros that, when replayed, all
the mouse clicks and movements, the choosing of menu items, data entered in
cells would be seen.... Hoping to use it as an instructional tool

TIA!

[aidey]

I use Macro Scheduler for this kind of thing, see
http://www.mjtnet.com/.

[JEFF]

Thanks... went to the website -- looks interesting. My question is whether /
how I can record a demo, embed it into the workbook so the end user can
"click to run", without them being required to have the software as well.....

Thanks.

"JEFF" wrote:

> Hi All,
>
> Wondering how one would go about recording a macros that, when replayed, all
> the mouse clicks and movements, the choosing of menu items, data entered in
> cells would be seen.... Hoping to use it as an instructional tool
>
> TIA!

[aidey]

Well, if you buy the professional (i.e. expensive) version of Macro
Scheduler, you can create a .exe, so your user doesn't have to have the
software. The Macro Scheduler macro can start up Excel, open a
workbook and demonstrate some operations, but you can't actually embed
the macro into the workbook.

On the other hand, perhaps you can use Excel VBA. Have a look at the
VBA help on the SendKeys statement, as you might guess, this will send
keystrokes to Excel (or other apps for that matter). As far as I'm
aware, you can't send mouse movements and events, but most of Excel
probably has keyboard shortcuts anyway, so perhaps this is the answer.

[Vic Eldridge]

Hi Jeff,

There's a number of programs out there that will record what's happening on
your screen to an AVI file or MPEG or whatever. I can't recall the names of
any but they do exist.

Once you have the movie recorded, you can use the Shell function in your VBA
code to play the movie file. This would of course mean you'd have to
distribute the movie file along with your XLS or XLA.

If you need something more dynamic then the following thread may give you
some ideas.

http://groups.google.com.au/group/mi...b1d0c94af1e37/


Regards,
Vic Eldridge


"JEFF" wrote:

> Thanks... went to the website -- looks interesting. My question is whether /
> how I can record a demo, embed it into the workbook so the end user can
> "click to run", without them being required to have the software as well.....
>
> Thanks.
>
> "JEFF" wrote:
>
> > Hi All,
> >
> > Wondering how one would go about recording a macros that, when replayed, all
> > the mouse clicks and movements, the choosing of menu items, data entered in
> > cells would be seen.... Hoping to use it as an instructional tool
> >
> > TIA!