If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Cognos Report Automatic Refresh  (Read 316 times)

Offline keating101

  • Full Member
  • ***
  • Join Date: Mar 2013
  • Posts: 32
  • Forum Citizenship: +0/-0
Cognos Report Automatic Refresh
« on: 18 Oct 2021 11:40:58 pm »
Hello,

I have cognos for office installed, everything is all good (cognos 11).
i want to schedule an automatic refresh of this spreadsheet.
i have a macro/cba which can refresh it when im logged in.
But i cant work out how to pass the login credentials into the macro, so the spreadsheet can essentially be opened from scratch, logged in, and then refreshed.

any ideas?
Shaun