Updateing a workbook from another workbood
 

I need to open a workbook, update a worksheet, and close the workbook all
from a different workbook. I have tried several approaches and have not been
successful. Can someon please point me to an article or source code to
accomplishe this?

Many Thanks,
--
Robert Hill

Updateing a workbook from another workbood
 

Robert,

The code below will open a workbook, put "Hello, World" in cell A1 of
Sheet1, then save and close the workbook.

Sub test()
Dim wb As Workbook
Set wb = Application.Workbooks.Open("D:\test.xls")
wb.Worksheets("Sheet1").Range("A1").Value = "Hello, World"
wb.Close True
Set wb = Nothing
End Sub


--
Hope that helps.

Vergel Adriano


"Robert" wrote:

I need to open a workbook, update a worksheet, and close the workbook all
from a different workbook. I have tried several approaches and have not been
successful. Can someon please point me to an article or source code to
accomplishe this?

Many Thanks,
--
Robert Hill