Can you send me one of the workbooks private Ed

Do you have the same problem with my Add-in ?
http://www.rondebruin.nl/merge.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ed_P" <u37751@uwe wrote in message news:78cc2e99b7298@uwe...
I trying to implement Ron's code for merging multiple workbooks (
http://www.rondebruin.nl/copy3.htm) , but the procedure fails to open the
workbooks.

Im getting Method 'Open' of object 'Workbooks' failed as an error. The
spreadsheets are autogenerated by our technology group and each sheet is
named something like .xls)CE_Vs_PE_Report_For_Multip

If I open the worksheet and remove ANY character from the sheet name, the
procedure will open that workbook. Is there anyway to correct this?

Thanks for you help.