Solved

An error occurred initializing the VBA libraries (265) - MS Excel

Posted on 2003-11-21
7
2,354 Views
Last Modified: 2007-12-19
I am having a problem when i try to open an .xlt excel file.

In Windows2000 with Excel 2000 when I double click on the xlt file to open it I am given the Macros prompt and I click on "Enable Macros" (I've tried clicking "Disable Macros" but still have the same results).  Then I am receving the message: "An error occurred initializing the VBA libraries (265)".  

I click ok on the message and then the Excel application stays open but the Excel file does not open.  If i open the Visual Basic Editor from inside Excel and then try to open the file I receive a "Device I/O" error message.  

In WindowsXP with Excel 2002 I eventually receive a message box saying:
"Errors were detected in 'filename.xlt', but Microsoft Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent.  Lost Visual Basic project. Lost ActiveX controls."

When I click Ok the template opens but there is no data in it as there should be.  There is just the header and column headings.

When I then save the file, the file size is goes to 33K instead of the 125K it started at originally.

I've found some articles on Microsoft.com that deal with similar issues but in Excel97 and when I've tried their fixes I still end up with the save problem.  

I've tried opening other xlt files that contain macros as well and they work find.  Any ideas of things I can try to get this file opening properly?  Thanks!
0
Comment
Question by:pliant6
7 Comments
 
LVL 81

Expert Comment

by:byundt
ID: 9800114
Hi pliant6,
Are there supposed to be VBA macros in the template? If so you may want to try "cleaning" them using Rob Bovey's VBA CodeCleaner http://www.cpearson.com/excel/xltools.htm 

Have you tried Excel 2002's File Repair and Open tool? To access it, use the File...Open menu item. Choose your file, then click the triangle to the right of the Open button. Choose File Repair and Open.

Cheers!

Brad
0
 

Author Comment

by:pliant6
ID: 9800211
Yes, when I use the Repair and Open tool in Excel 2002 is when I get the: "Errors were detected in 'filename.xlt', but Microsoft Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent.  Lost Visual Basic project. Lost ActiveX controls."

When i tried the VBA Code Cleaner I get a message saying: "Programmatic access to Visual Basic Project is not trusted (CodeCleanerMain).

:(
0
 
LVL 11

Expert Comment

by:turn123
ID: 10177571
pliant6,
No comment has been added lately (62 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Accept byundt's answer http:#9800114 and Refund

Please leave any comments here within 7 days.

-- Please DO NOT accept this comment as an answer ! --

Thanks,

turn123
EE Cleanup Volunteer
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:pliant6
ID: 10177801
I would like to request a refund.  Nothing helped to fix this file as it was being corrupted during a Kermit file transfer.
0
 
LVL 11

Expert Comment

by:turn123
ID: 10178723
pliant6,

If you want to delete this question, post a zero-point question in http://www.experts-exchange.com/Community_Support/

Subject: Moderator Please Delete
Body: Please delete this question:
http://www.experts-exchange.com/Applications/Q_20805493.html

or you could just leave it as my recommendation was for you to get a refund.

Turn123
0
 

Accepted Solution

by:
SpazMODic earned 0 total points
ID: 10230076
PAQed, with points refunded (150)

SpazMODic
EE Moderator
0
 

Expert Comment

by:otwo
ID: 14655430
Possible fix
open the workbook in Excel 2002 and hit Alt +F11
Insert from the tool bar
then Module
Select Tools and references
make sure Visual Basics for applications is selected
Add Active controls are also checked


Good Luck!!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PDF writer for SBS 2008 11 83
Edit header 19 101
Backup Data/Portable NAS storage 4 65
Where is Outlook in Paperport 14? 8 30
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now