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