Code: Select all
wb2.Sheets(Format(strDate, "dd-mm")).Copy Before:=wb1.Sheets(1)
Microsoft’s suggestion of using copy & paste from ws to ws is not really ideal.
I have a theory: The code works with files that were created using 2003, but not where created using 2007 vba (from a text file), saved as xls. I would rather save the files as xls (I need the code to work in both versions).
I don't understand how there can be more rows / columns in the source workbook than the destination workbook, when both are xls files.