[MS Office - 2010] VBA with Excell

[MattDLEA]

Hi,

Getting to my witts end with this problem.
its with a office 2010 install looks like its on all our comps now we get the following errors VBA.png
Now i did config office with OCT before deploy but didnt see that i had done anything that would have caused this. However i am open for all sugestions as I cant find the answer.

I have logged on as Admin and gone to control panel > programs > and office > change> and office tools are installed along with VBA. So it has to be a setting somewhere???

Please help

[mac_shinobi]

Daft suggestion but when you save the excel workbook are you going

File --> Save As --> Excel Macro Enabled workbook ( *.xlsm )

Then attempt to re open said workbook and try the vba code

[MattDLEA]

This is happening when SIMMS is generating the report file in xls but now its also with some maths files that they have got from national strategys website that end in xls format ?

[MattDLEA]

Anyone got any ideas on this. I have logged on a machine removed ranger then removed office. then installed office from the disk and still getting the same error?