[SOLVED] IE automatically opening files not prompting to save

mcornbill · 05-03-2006, 09:20 AM

Hi all

Right then here's a little problem which I've just started experiencing lately. At work we run program with a HTML front end on a SQL database. When clicking a button, within IE, I should be prompted to either save a csv file or open a csv file. I need to save these files as clicking open on them opens them up in Excel which is no good for me as they are usually 65,000+ records in size.

Now I get no option to save/open it just opens up in Excel automatically, losing any records past the magic 65,536 mark. To top it off I have a program called CSVed which is associated with all csv files. A normal double-click of a csv file within Windows would open it in this program anyway and not Excel?!

Any ideas?

Cheers
Mark

**ReeKorl** · 05-03-2006, 09:55 AM

I'm pretty sure you can correct this by opening up a folder (in windows, not an IE page; and any folder - doesn't matter where) and click Tools -> Folder Options -> File Types tab then find the CSV type in the list. Click Advanced, then make sure Confirm Open After Download is ticked. This should make sure you get the download confirmation box where you can choose to save it instead of it opening.

mcornbill · 05-04-2006, 04:39 AM

Yeah I have been down this route. As I have set csv files to open with a program called CSVed when you go to file types and click on csv the 'Advanced' button is actually 'Restore' instead. I restored it back to the default of Excel opening up csv's, then changed it back to CSVed and then I got the Advanced button back. Ticked that box like you suggested but still no prompt to save.

Cheers
Mark

mcornbill · 05-04-2006, 04:58 AM

Ok guys I've been messing about with the open settings and now when I double click a csv file it doesn't open at all. It opens up the CSVed program and then freezes. If however I open up CSVed first then go the File - Open route it works just fine. Can anyone tell me within Tools -> Folder Options -> CSV type -> Advanced what values should be in the various fields for the 'Open' action?

Cheers

mcornbill · 05-04-2006, 07:35 AM

Update - Done a system restore to solve my latter problem but any more suggestions on getting the Open/Save dialogue box up are welcome!

Cheers

nitow · 05-23-2006, 03:11 AM

Quote:

Originally Posted by ReeKorl

I'm pretty sure you can correct this by opening up a folder (in windows, not an IE page; and any folder - doesn't matter where) and click Tools -> Folder Options -> File Types tab then find the CSV type in the list. Click Advanced, then make sure Confirm Open After Download is ticked. This should make sure you get the download confirmation box where you can choose to save it instead of it opening.

This worked for me - however I first had to untick "Confirm Open After Download" save & close window as it was still ticked.
Then i went back and ticked it and Problem solved.

Thanx

srirammanoj · 05-26-2008, 06:16 AM

I have a req. I need to save an excel sheet which was opened in IE and has to be automatically save without user's intervention. and the "SaveAs" dialogue box should not come. i need to overwrite the file without any manual intervention.
how can i do this programatically(VB.NET/C#.NET)....???????

can u help me in this issue..

**Go The Power** · 05-28-2008, 03:03 AM

hello and welcome to the forum

please start your own thread.

Thank you

thread closed

05-03-2006, 09:20 AM	#1 (permalink)
mcornbill Registered User Join Date: Mar 2002 Location: Birmingham Posts: 218 OS: Windows XP MCE\Vista Ultimate	[SOLVED] IE automatically opening files not prompting to save Hi all Right then here's a little problem which I've just started experiencing lately. At work we run program with a HTML front end on a SQL database. When clicking a button, within IE, I should be prompted to either save a csv file or open a csv file. I need to save these files as clicking open on them opens them up in Excel which is no good for me as they are usually 65,000+ records in size. Now I get no option to save/open it just opens up in Excel automatically, losing any records past the magic 65,536 mark. To top it off I have a program called CSVed which is associated with all csv files. A normal double-click of a csv file within Windows would open it in this program anyway and not Excel?! Any ideas? Cheers Mark Last edited by mcornbill; 05-03-2006 at 09:23 AM.

05-03-2006, 09:55 AM	#2 (permalink)
ReeKorl Superhuman Computer Join Date: Mar 2005 Location: 6th Circle, The City of Dis, Hell Posts: 1,610 OS: WinXP Pro SP2 My System	I'm pretty sure you can correct this by opening up a folder (in windows, not an IE page; and any folder - doesn't matter where) and click Tools -> Folder Options -> File Types tab then find the CSV type in the list. Click Advanced, then make sure Confirm Open After Download is ticked. This should make sure you get the download confirmation box where you can choose to save it instead of it opening. __________________ "Sorry, the number you have dialled is imaginary. Please rotate dial by 90 degrees and try again."

05-26-2008, 06:16 AM	#7 (permalink)
srirammanoj Registered User Join Date: May 2008 Posts: 1 OS: XP	Re: IE automatically opening files not prompting to save I have a req. I need to save an excel sheet which was opened in IE and has to be automatically save without user's intervention. and the "SaveAs" dialogue box should not come. i need to overwrite the file without any manual intervention. how can i do this programatically(VB.NET/C#.NET)....??????? can u help me in this issue.. Last edited by Go The Power; 05-28-2008 at 03:01 AM. Reason: removed spam

05-28-2008, 03:03 AM	#8 (permalink)
Go The Power Moderator, Microsoft Support Join Date: Mar 2007 Location: South Australia Posts: 10,981 OS: Windows XP Home SP2 Blog Entries: 1	Re: IE automatically opening files not prompting to save hello and welcome to the forum please start your own thread. Thank you thread closed __________________

05-04-2006, 04:39 AM	#3 (permalink)
mcornbill Registered User Join Date: Mar 2002 Location: Birmingham Posts: 218 OS: Windows XP MCE\Vista Ultimate	Yeah I have been down this route. As I have set csv files to open with a program called CSVed when you go to file types and click on csv the 'Advanced' button is actually 'Restore' instead. I restored it back to the default of Excel opening up csv's, then changed it back to CSVed and then I got the Advanced button back. Ticked that box like you suggested but still no prompt to save. Cheers Mark

05-04-2006, 04:58 AM	#4 (permalink)
mcornbill Registered User Join Date: Mar 2002 Location: Birmingham Posts: 218 OS: Windows XP MCE\Vista Ultimate	Ok guys I've been messing about with the open settings and now when I double click a csv file it doesn't open at all. It opens up the CSVed program and then freezes. If however I open up CSVed first then go the File - Open route it works just fine. Can anyone tell me within Tools -> Folder Options -> CSV type -> Advanced what values should be in the various fields for the 'Open' action? Cheers

05-04-2006, 07:35 AM	#5 (permalink)
mcornbill Registered User Join Date: Mar 2002 Location: Birmingham Posts: 218 OS: Windows XP MCE\Vista Ultimate	Update - Done a system restore to solve my latter problem but any more suggestions on getting the Open/Save dialogue box up are welcome! Cheers