2003 macros in 2007

[theo1881]

Have a user who is opening workbooks created in 2003 and macros are not working (message about security etc). have set macro security to run all and set trusts to be ok but still an issue

Any ideas

Laters, phat, headshape

 

[AnotherHiggins]

Generally speaking, macros created in Excel 2003 will run fine in 2007.

Knowing exactly what problems you're running into would help make it possible to troubleshoot what's going on.

Please provide actual error messages as well as what you did to change security settings.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[theo1881]

apologies, looking at that its a poor post. can't get on users pc at present to get error.

as far as macro settings are concerned i have set them to

enable all macros and set 'trust access to the vba [project model'. i have added the location to the trusted locations also

Laters, phat, headshape

 

[theo1881]

i have also resaved the document in 2003 as .xlsm (macro enabled workbook)

Laters, phat, headshape

 

[theo1881]

Exact error is

This workbook has lost its VBA project, Active X controls and any other programmability-related features.

Below is the log file listing repairs

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="

http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error034120_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Documents and Settings\d.roper\Desktop\090820 ODBC WebTrends file for dashboards.xls'</summary>
- <additionalInfo>
<info>This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.</info>
</additionalInfo>
</recoveryLog>

Any help now greatly appreciated.

Laters, phat, headshape

 

[theo1881]

BTTT as my user is chasing!

cheers

Laters, phat, headshape