View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick S. Rick S. is offline
external usenet poster
 
Posts: 213
Default Open wb from a wb and run a macro

So simple yet so simple! :lol:

Thank you!
:beer:

"excelent" wrote:

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
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!