Error saving excel workbook with Macros

[tosca1978]

Hi,

I have been working on an excel workbook with active forms for a few weeks now and been saving it to Perspectives as an application and it works fine. This morning I have added some VBA + macros in excel but it will not let me save to Perspectives. When I try it tells me that I need to change the format of teh file to a Macro Enabled Excel Workbook. When I do this I can save to perspectives.

However, when I try and open teh application in Perspectives I get the following error:
"Excel cannot open teh file 'TM156.xlsx' because the file format or file extention is not valid. Verify that the file has not been corrupted and that the file extention matches the format of the file"

When I view the application in perspectives it reads "TM156.xlsm.xlsx". I have tried to change the filer type to "TM156.xlsm" - I get a similar error.

Please help!

[lotsaram]

You need to save as XL 2003 .xls format.

(you wouldn't think it is that difficult but support for .xlsx and .xlsm is still not great, the best alternative is to simply save in the old format)

[tosca1978]

Hi Lotsaram,

thanks for your help. I have saved the workbook as Excel 97-2003 and it has automaticallly saved it as Compatability Mode.

When I open the workbook it opens without error. However, when I try and run teh macro that was previsouly saved I get the eeror message:
"Cannot run the macro 'TM176.xls!Menu_CostCentre'. The macro may not be available in tehis workbook or all macros may be disabled"

under the developer ribbon/Macro security I have checked the "Enable all macros..." still has the same error. I have aldo tried ticking "Trust access to the VBA project ojject model", still no luck. This is all on the client side.

I have logged onto the server and opened excel and selected the same options. Gone back to teh client side and opened teh application again (workbook with active forms and VBA) and the macro error message still appears!

Do you know what I am doing wrong?

Thanks for you help with this.

[tosca1978]

Lostaram...I meant to add...the macros IS definitely available in the workbook!

Cheers

[lotsaram]

Do you know what I am doing wrong?

Nope.

[mikegrain]

Try right clicking on the application folder in Server Explorer and using the Add File option to upload the original .xlsm file.

It was the only way I could get TM1 to handle .xlsm files properly.

[David Lee]

Try right clicking on the application folder in Server Explorer and using the Add File option to upload the original .xlsm file.

It was the only way I could get TM1 to handle .xlsm files properly.

It works! Thanks for your tips!

[roblightbody]

Having spent time downloading FP3 after reading this - http://www-01.ibm.com/support/docview.w ... wg1PM25985

I discovered that this didn't work BUT then I tried 'MikeGrain' 's suggestion above and it worked - using the 'add file' option. This works perfectly.

Thanks for solving a frustrating problem!

- Rob