We recently migrated from Impromptu 6.0 to Cognos 8.4, using Report Studio and Query Studio. Under Impromptu, I was able to automate many MS Access tools using VBA to call Impromptu, run imrs and import tables into the Access tool. Now that we are web-based, I have lost all my automation. Is there a way (VBA code)to call Report Sudio reports in Cognos 8.4, run and import the data using MS Access VBA?
Thanks.
Thanks.