View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
 
Posts: 695
Default Open wb from a wb and run a macro

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!