Writing data to a new workbook
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.
|