Open wb from a wb and run a macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick S. - 24 Sep 2007 18:36 GMT

This is hard top describe in a a title.
I would like to be working in one workbook (wb) select a cell that has any
type of data and search for that data in another wb that may or may not be
open.

I am mainly stumbling due to Excel 2007 which seems to have some quirks for
me to work thru :lol:

As always, any help is appreciated!

Reply to this Message

excelent - 24 Sep 2007 20:20 GMT

Sub check()
Application.Run ("Workbookname.xls!Macroname")
End Sub

"Rick S." skrev:

> This is hard top describe in a a title.
> I would like to be working in one workbook (wb) select a cell that has any
[quoted text clipped - 5 lines]
>
> As always, any help is appreciated!

Reply to this Message

Rick S. - 24 Sep 2007 23:36 GMT

So simple yet so simple! :lol:

Thank you!

:beer:

> Sub check()
> Application.Run ("Workbookname.xls!Macroname")
[quoted text clipped - 11 lines]
> >
> > As always, any help is appreciated!

Reply to this Message