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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find copy data from a cell in Personal workbook and copy it to a cellin current workbook 14
Run macro on all sheets 3
macro to select a range from a set cell to a specified cell 6
use Find without hardcoded value but a value from a cell 1
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Getting Excel Find to Default to Searching Workbook not Sheet 3
Using While Wend with Cells.Find 1
Find Feature with Macro 3

Top