Follow @dporton

Testing Unicom Intelligence with Office 2016

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

2 thoughts on “Testing Unicom Intelligence with Office 2016

  1. 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.

Leave a Comment

%d bloggers like this: