Just the other day I was required to upgrade to office 2016. I have set this post up to record any issues I find and record what I have tested. If you have done any testing on 2016 then please feel free to leave a comment and we can add it to the list of things that may need to be looked at by the Unicom Team.
| Product | Test | Outcome | Date |
| Excel | Can I use my existing VBA code to manipulate XL files | Yep , no issues here everything currently still works | 5/06/2017 |
| Excel | Can I export an MTD to an XL file | Yep , no issues here everything currently still works | 21/06/2017 |
| Excel | Can I export data file to a csv file that can be loaded into XL | Yep , no issues here everything currently still works | 21/06/2017 |
| Powerpoint | Can I use my existing VBA code to manipulate ppt/pptx files | Yep , no issues here everything currently still works | 5/06/2017 |
| Powerpoint | Can export my tables to a PPT/PPTX still using my old chart templates | Yep , no issues here everything currently still works | 5/06/2017 |
| Powerpoint | create a batch file and run an MRS that holds a TOM export to PPT | Excel seams to hang at end of export ( I think when it is saving the PPT ) Added code to kill process “TASKKILL /F /IM excelcnv.exe” to see if I can kill it | 21/06/2017 |
I run Table srip with .mrs file on export to excel output am getting this error message:
Export failed cannot file microsoft excel. Export required microsoft excel 2000 or later.
On the laptop am using microsoft office 2016 that include excel 2016.
Thanks in advance.
Help.
Can you send me your script ? email it to dporton@au1.ibm.com