[F8] Step by step in another application

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gérard Ducouret - 19 Apr 2006 11:42 GMT

Hello,
I have a VBA macro in Word. This macro opens Excel, then runs another macro
in Excel.
Is it possible to check step by step (F8 ?) the macro which is in Excel ?
Thanks

Gérard

Reply to this Message

Jezebel - 19 Apr 2006 13:36 GMT

Why not just try it?

> Hello,
> I have a VBA macro in Word. This macro opens Excel, then runs another
[quoted text clipped - 4 lines]
>
> Gérard

Reply to this Message

Gérard Ducouret - 25 Apr 2006 12:57 GMT

I already tried with F8, which doesn't work
I'll try Ctrl + Shift + F8

Gérard

> Why not just try it?
>
[quoted text clipped - 6 lines]
> >
> > Gérard

Reply to this Message

Cindy M -WordMVP- - 26 Apr 2006 08:44 GMT

Hi Gérard,

> I have a VBA macro in Word. This macro opens Excel, then runs another macro
> in Excel.
> Is it possible to check step by step (F8 ?) the macro which is in Excel ?

You might need to try setting a break point (F9) in the Excel procedure in
the Excel VB Editor before running the macro. That could stop the code
execution, once it starts, so that you can continue with F8.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message