VBA: copy CELL data from EXCEL1 to EXCEL2

[Hot Ice]

---

Patabang ko ninyu guys.

I have 2 excel files.
For example:
EXCEL1 and EXCEL2

I already have a macro that will generate a report for me in a MODULE of EXCEL1. However, I need help copying a CELL data from EXCEL1 to a sheet in EXCEL2.

I can move the focus from EXCEL1 to EXCEL2 by using "Windows("EXCEL2").Activate". But, succeeding lines like RANGE("A1").SELECT (for example) will generate an error.

What can i do?

[MarkCuering]

it would be helpful if you paste the error your some of the functions involve... or did you record the macro?
but judging from what I understand... can you try to tweak around this command.

Range(xx & yy).Value = ActiveCell.Offset(row_offset, column_offset).Value

Cells.Find("xxx").Activate
Range("Number" & ActiveCell.Row).Value = ActiveCell.Offset(row_offset, column_offset).Value

or maybe you mean copy? Activecell.PasteSpecial to a Worksheets(name).range(...)

I hope it helps...


Mark

[Hot Ice]

got it.
I typed the macro in a module I created in the PERSONAL.XLS file. That way, it's available to all EXCEL files I open.

thanks..