Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / September 2007

Tip: Looking for answers? Try searching our database.

Workbooks.Open Fails

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ed_P - 26 Sep 2007 15:22 GMT
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 - 26 Sep 2007 21:54 GMT
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

Signature

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

>I trying to implement Ron's code for merging multiple workbooks  (
> http://www.rondebruin.nl/copy3.htm) , but the procedure fails to open the
[quoted text clipped - 8 lines]
>
> Thanks for you help.
Ed_P - 27 Sep 2007 01:49 GMT
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 - 27 Sep 2007 17:55 GMT
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

Signature

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

> 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
[quoted text clipped - 5 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.