Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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!

share|improve this question
    
Where do you get this dialog: Cognos or Excel? And describe better the procedure that you follow. –  harrymc Oct 29 '10 at 11:32
    
Apols, I'll clarify. Once the data I need is on screen I click the 'download CSV' icon and IE's "File Download" message appears (Do you want to open or save this file?). The message box also dispays the file opens with Excel and that the source is my intranet data server (so as trustworthy as you can get!). I suppose a better phased question is, that if IE knows all this, can I set up that CSV files from this location are always opened, not saved, thus removing the open/save prompt altogether? I suppose it's an IE or file-type-options setting rather than cognos or excel themselves. –  John Allan Oct 29 '10 at 12:46

1 Answer 1

How to do that for a given file-type, .csv, is described here:

Reset Open/Save Choice for Internet Explorer Downloads in Vista

But I don't know of a way to condition it upon the source website.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.