I have two workbooks that I have open. WorkBook A has data in it. WorkBook
B is blank.

If I use this code, I can get the date from WorkBook A
Range("A2").Activate
RunDate = ActiveCell.Offset(0, 1).Value
MsgBox "Run Date " & RunDate

I can not figure out how to write the RunDate to the same location in
WorkBook B.

Another question, how to open a new Workbook with a file name or save it
with a file name.

Thank you.