I have about 50 excel spreadsheets all saved in separate files but they all have the exact same format. I need to basically consolidate all of the data.<BR><BR>Is there a way, using VBA, to read in ...

I can't believe how difficult this seemingly simple task has turned out to be. I need to be able to get a date value stored in an Excel spreadsheet (say, C Temp\file.xls) in cell B28, and put that ...