Hi
In the code below, this line of code
Set closedBook = Workbooks.Open("D:\Dropbox\excel\articles\example.xlsm")
Not sure why I need "Set closedBook". Let say I have one Workbook open, which is Workbooks(1). If I do this code
Workbooks.Open("D:\Dropbox\excel\articles\example.xlsm")...