Hi,

How do I write from one workbook to a closed workbook ?

MAS

Generally you don't unless the closed workbook is organized as a database.
then you may be able to do it using ADO.

http://support.microsoft.com/default...46&Product=xlw
How To Transfer Data from ADO Data Source to Excel with ADO

http://support.microsoft.com/default...73&Product=xlw
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

http://support.microsoft.com/default...19&Product=xlw
How To Use ADO with Excel Data from Visual Basic or VBA

--
Regards,
Tom Ogilvy


"MAS" wrote in message
...
Hi,

How do I write from one workbook to a closed workbook ?

MAS

It might just be easier to

Dim wkbk as Workbook
Application.ScreenUpdating = False
set wkbk = Workbooks.Open(Filename:="C:\Myfiles\Mybook.xls")
wkbk.worksheets(1).Range("A1").Value = Date
wkbk.close Savechanges:=True
Application.ScreenUpdating = True

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
Generally you don't unless the closed workbook is organized as a database.
then you may be able to do it using ADO.

http://support.microsoft.com/default...46&Product=xlw
How To Transfer Data from ADO Data Source to Excel with ADO

http://support.microsoft.com/default...73&Product=xlw
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in
Excel
Workbooks

http://support.microsoft.com/default...19&Product=xlw
How To Use ADO with Excel Data from Visual Basic or VBA

--
Regards,
Tom Ogilvy


"MAS" wrote in message
...
Hi,

How do I write from one workbook to a closed workbook ?

MAS