We are on a company intranet and most of our time involves cutting our data into reports using our Cognos 8.4 tool. To take the on-screen result into Excel (2007, in XP with IE8) I can either export as XLS (which now opens automatically thanks to an excellent reply by M. Palavuzlar elsewhere on this site) or if wishing to import data into a previously formatted sheet, I can choose to export in CSV.
Does anyone know a way of getting rid of the 'open or save' prompt - and just open? Perhaps from the URL of the tool as it's trusted?
I don't know if I should be looking at Excel, Windows or IE's setup or all three. Or if it's not possible. Any suggestions would be great!