Write no closed workbook ?

[Tom Ogilvy]

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.aspx?scid=kb;en-us;295646&Product=xlw
How To Transfer Data from ADO Data Source to Excel with ADO

http://support.microsoft.com/default.aspx?scid=kb;en-us;278973&Product=xlw
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

http://support.microsoft.com/default.aspx?scid=kb;en-us;257819&Product=xlw
How To Use ADO with Excel Data from Visual Basic or VBA

 

[MAS]

Hi,

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

MAS

 

[Tom Ogilvy]

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