I have a rather large workbook I've converted from an Excel 2003 .xls format
to an excel 2007 xlsx format. I'm having problems deleting the custom
toolbar that was attached to the original workbook. Excel allows me to
delete the toolbar from the current session; however, the next time I open
this file the toolbar comes back. The file also causes the following error
when opening. "Excel cannot complete this task with the available resources.
Choose less data or close other applications." By watching the Add-Ins
ribbon I can see this error occurs right after the cuctom toolbar is created.
I believe deleting the unused commandbar will solve the error. During my
research I found the following statment in the excel help for
Workbook.Commandbars Property. "There is no programmatic way to return the
set of command bars attached to a workbook." If I can't delete this workbook
commandbar through the commandbars property how can it be deleted?

Save the workbook in 2003 format (xls). Then open in Excel 2003. Select
View, Toolbars, Customize, Attach and delete the attached toolbar. Save the
file. Open back in 2007 and save in the desired format.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"ALF-E" <(E-Mail Removed)> wrote in message
news:A2EC6D9A-6DCD-4EF0-9137-(E-Mail Removed)...
>I have a rather large workbook I've converted from an Excel 2003 .xls
>format
> to an excel 2007 xlsx format. I'm having problems deleting the custom
> toolbar that was attached to the original workbook. Excel allows me to
> delete the toolbar from the current session; however, the next time I open
> this file the toolbar comes back. The file also causes the following
> error
> when opening. "Excel cannot complete this task with the available
> resources.
> Choose less data or close other applications." By watching the Add-Ins
> ribbon I can see this error occurs right after the cuctom toolbar is
> created.
> I believe deleting the unused commandbar will solve the error. During my
> research I found the following statment in the excel help for
> Workbook.Commandbars Property. "There is no programmatic way to return
> the
> set of command bars attached to a workbook." If I can't delete this
> workbook
> commandbar through the commandbars property how can it be deleted?
>