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

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!
pliant6Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

byundtCommented:
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
pliant6Author Commented:
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
turn123Commented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

pliant6Author Commented:
I would like to request a refund.  Nothing helped to fix this file as it was being corrupted during a Kermit file transfer.
0
turn123Commented:
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
SpazMODicCommented:
PAQed, with points refunded (150)

SpazMODic
EE Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
otwoCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.