ExcelBanter - Update

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Update (https://www.excelbanter.com/excel-programming/333851-update.html)

\remy khalil via OfficeKB.com\

Update

How can I update cells from 2 different excel files, using VB

Tom Ogilvy

Update

Dim bk1 as Workbook, bk2 as Workbook
set bk1 = Workbooks("ABC.xls")
set bk2 = Workbooks("EFG.xls")
bk1.Worksheets(1).Range("A1").Value = 21
bk2.Worksheets(5).Range("B9").Value = 21

--
Regards,
Tom Ogilvy

""remy khalil via OfficeKB.com"" wrote in message
...
How can I update cells from 2 different excel files, using VB

All times are GMT +1. The time now is 01:48 PM.