Hi Edward
adding the code:
will do it if your working with a single Excel file.![]()
Worksheets("Sheet4").Range("E3") = Now
Otherwise you have to add the Filename:
![]()
WorkBooks("filename.xls").Worksheets("Sheet4").Range("E3") = Now
Hi Edward
adding the code:
will do it if your working with a single Excel file.![]()
Worksheets("Sheet4").Range("E3") = Now
Otherwise you have to add the Filename:
![]()
WorkBooks("filename.xls").Worksheets("Sheet4").Range("E3") = Now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks