I need help with changing the width of the columns for my final reports. The report merges 11 other reports into a single excel report. Once merged I want to Autofit the columns. I tried using Invoke VBA and calling in the code but the client has disabled the macros.
Error - “Invoke VBA: Programmatic access to Visual Basic Project is not trusted”.
They also block any third party packages such as BalaReva.Excel.Activities.
I read I might be able to use Invoke code or Invoke Script but haven’t been able to find any examples. Any help would be appreciated.