Excel macro

G

Guest

hi,
you wouldn't "pause" the macro.
you would write code that would activate or open the other
workbook lookup(find), copy then acrivate the first
workbook and paste. it would be all part of the same macro.
you were a little vague but..
Windows("workbook2.xls").Activate

Cells.Find(What:="Inputbox"Find what?"", _
After:=ActiveCell, _
Lookin:=xlFormulas,_
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
searchDirection:=xlnext,_
MatchCase:=False).Activate

Selection.copy
Windows("workbook1.xls").Activate
'find where you want to paste
Activewindow.paste
 
Top