I'm tring to pass value in cell between workbooks for example : value in cell A1 of Book1.xls pass to cell B1 of Book2.xls
with code
workbooks(book1.xls").worksheets("sheet1").range(" A1").value = workbooks(book2.xls").worksheets("sheet1").range(" B1").value
or something like that but not success. Could anyone give me the answer please.