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
I have written a macro that does various things on a workbook.
The Workbook is then saved and closed using the command ActiveWorkbook.Close SaveChanges:=True
this command was working fine until I made various changes but now it now longer works.
The last bits of my macro is as...
I have a list of file paths in a workbook, in cells A1:A307. I would like to open some master data files, then open the files listed in Column A one-by-one, update formula values that are referring to the master data files, save them, and then close them.
If the file is unable to be...
I have a number of file paths listed in Column A of Sheet1 that have to be opened and saved daily. There are formulas in these sheets that are linked back to other data sheets that should remain open the whole time.
However, the current macro I have fails to a full stop if one of the...