I have a macro that follows a file path and once it gets to the end, it finds
every excel file in that folder and opens each one. As it opens each one it
copies and pastes data from a specific sheet and cell or range of cells into
a new workbook. I use this macro to gather data at the end of each month. I
have started using it throughout the month to get different data from the
same workbooks. I'll just go into the macro and change the file path, sheet,
or cell that I need. The Problem.... I have a specific workbook that this
will not work on. The macro goes thru all the motions but in the end it
leaves me with a blank excel sheet instead of a sheet with all the pasted
data.