View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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)