Workbooks.Open Fails

[Ed_P]

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.

 

[Ron de Bruin]

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

 

[Ed_P via OfficeKB.com]

Ron thanks for the reply. I was about to send you a workbook, and as I was
removing certain pieces of data from the sheet and saved it, I reran the
procedure and noticed that the workbook was now able to be opened by both
your addin and the the code on your site. Each workbook I opened and saved,
regardless if I changed anything, was able to be merged. Im trying to have
another workbook created that I can send you without have to edit it for you
to see. Have you ever seen something like this?

Thanks

 

[Ron de Bruin]

Hi Ed

Have you ever seen something like this?

No but maybe the file is corrupt ?
If you have the problem again I like to see the file if possible