I've set up a macro in Excel linked with a control button that will SaveAs when clicked and will make a duplicate of the workbook. My problem is that I have linked the workbooks together so that totals will carry from one month to the next; what's happening is that the new workbook is still linked to the one the old book was, not to the new workbook. Here is what I have:
ActiveCell.FormulaR1C1 = "=[Jan.xls]Week4!R5C10"
ActiveCell.FormulaR1C1 = "=[Jan.xls]Week4!RC[2]
I'm not sure how to tell it to create a new link to the workbook I created the new workbook from. Also, what is the R5C10 and RC[2] mean? The cell I'm linking to is J5.
Thank you!
Jackie
ActiveCell.FormulaR1C1 = "=[Jan.xls]Week4!R5C10"
ActiveCell.FormulaR1C1 = "=[Jan.xls]Week4!RC[2]
I'm not sure how to tell it to create a new link to the workbook I created the new workbook from. Also, what is the R5C10 and RC[2] mean? The cell I'm linking to is J5.
Thank you!
Jackie