Running a VBA application in Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert Bradley - 24 Mar 2008 17:23 GMT

I get an error running a VBA application (saved as an xls file) in Excel 2007
on my office machine.
I can run this file OK on other Excel 2007 installations so I guess it’s a
settings issue on my office machine.

The error I get is as follows:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error018881_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Documents and
Settings\RB\Desktop\REPAIRED WINPLAN.XLS'</summary>
- <additionalInfo>
<info>This workbook has lost its VBA project, ActiveX controls and any
other programmability-related features.</info>
</additionalInfo>
</recoveryLog>

The file in question is called "REPAIRED WINPLAN.XLS'

I am a non teckkie but hope I can resolve this by changing my Excel
settings. Can anyone help please?

Robert Bradley

Reply to this Message

GuruGirl - 25 Mar 2008 02:22 GMT

VBA is slightly different in Excel 2007, not sure if you are running into a
code compatibility error, see if you can run a compiler check from the
Module, project view. You will see where the error occurs if this is the
case.

Also note that Excel 2007 differentiates between macro enabled file (.xlsm)
and non-macro enabled files (.xlsx). You can try saving your 2003 format
file as an (.xlsm) file and see if it converts successfully to 2007, then run
your macro.

other than that, not sure. Good luck.

> I get an error running a VBA application (saved as an xls file) in Excel 2007
> on my office machine.
[quoted text clipped - 21 lines]
>
> Robert Bradley

Reply to this Message

GuruGirl - 25 Mar 2008 02:24 GMT

Note: If your .xls file is converting to .xlsx, you will lose access to your
macro functions. If you first save your .xls file as .xlsm (macro enabled)
you should not lose your macro. if you save your .xlsx file as .xlsm, then
you should be able to recover access and functionality of your macro.

All is not lost.

> I get an error running a VBA application (saved as an xls file) in Excel 2007
> on my office machine.
[quoted text clipped - 21 lines]
>
> Robert Bradley

Reply to this Message

Rate this thread: