Excel VBA Write to xls ?
Are they both open?
workbooks("Otherfile.xls").Worksheets(1).Range("A1 :B5").Value = _
Thisworkbook.Worksheets(3).Range("M11:N15").Value
--
Regards,
Tom Ogilvy
"Adrian" wrote in message
...
Hi,
Can an Excel VBA program access (read/write) another excel file ? if
so, how ?
Thanks...
--
Regards,
Kok Hsing
(Guoxing)
|