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