hi
does anybody know how to set cell value in closed external workbook, from say cell value of active worksheet ?
the following doesn't work
/error 1004 - application defined or object defined error/
thanks
does anybody know how to set cell value in closed external workbook, from say cell value of active worksheet ?
the following doesn't work
Code:
Application.Workbooks("F:\DESKTOP\za abc\xy_z.xls") _
.Worksheets("Sheet1").Range("H1").Value = 123thanks