Hi Itchy, Thank you for your questions and insight. Yes we did entertain the idea of bypassing Excel using an automation tool. Unfortunately there is still a requirement to create visualisations in Excel to supplement those from VA. I offered the Stored Processes as a potential solution, but the stakeholders declined. I agree with your position on using BASE to get the job done. However we were told that this functionality (all though not core) was achievable during the DD process and now the Stakeholders want it achieved using VA or want categorical proof that it can't be done. I am not at a point yet that I can say definitively that it can't be done, hence me throwing it open to the community. Thank you again for your help, it is really appreciated.
... View more