I am using a macro to get data from closed workbooks, it works absolutely fine for 18 pieces of data (first part of macro)
when i use to get another 18 pieces of data, it gets the data but then comes up with "Run-time error '1004' Method 'range' of object _global failed"
Ive separeated the ones into 2 different macro thinking it could have been that but the lines highighted in red is the problem, as i said, it retrieves all data but falls over when it hits the private function data line for the last time (only on the second macro)
I found the code online and adapted it, so i only understand the obvious bits
the code will also be adapted to find other sheet names depending on cell values, so if anyone spots any suggestions, i'd be more than happy to recieve
Please Login or Register to view this content.