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.

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.

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

--
Message posted via http://www.officekb.com

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

--

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


"Ed_P via OfficeKB.com" <u37751@uwe wrote in message news:78d1a784ee4ed@uwe...
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

--
Message posted via http://www.officekb.com