Re: CSV Downloads
From: Ramesh, MS-MVP (ramesh_at_online.mvps.org)
Date: 02/06/05
- Next message: Rick \: "Re: System Restore Problem - Another one!"
- Previous message: Arioch: "Re: Ahead Nero InCD"
- In reply to: Dave L: "Re: CSV Downloads"
- Next in thread: Ramesh, MS-MVP: "Re: CSV Downloads"
- Reply: Ramesh, MS-MVP: "Re: CSV Downloads"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 6 Feb 2005 19:29:51 +0530
Hi Dave,
This problem can be resolved by modifying a couple of registry values.
1. Create a System Restore point if you want to undo the following
operation
2. Open Regedit and navigate to:
[HKEY_CLASSES_ROOT\.CSV]
3. In the right-pane, double-click "Content Type" and delete it
4. Navigate to:
[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]
5. Rename the key "CLSID" to "CLSID-"
NOTE: With missing Content Type value and missing Workbook CLSID, Internet
Explorer cannot execute the .CSV file, and you'll be presented with the
Open/Save As prompt when you click your bank statement (.CSV file). Should
you need to open a CSV file in Internet Explorer (embedded document) in
future, reverse the above steps.
Hope this helps, and keep us posted!
-- Ramesh, Microsoft MVP Windows XP Shell/User http://windowsxp.mvps.org "Dave L" <DaveL@discussions.microsoft.com> wrote in message news:E94CA24D-5E1B-4F5D-8E04-A3262C029E72@microsoft.com... > Thanks for the replies, > When I try to download my statement I am given the 5 options via a > dropdown > menu of - Microsoft Money, Quicken 2001, Quicken 98, Sage Line 50 (all OFX > files) and Microsoft Excel (CSV file). On my Win2K machine I select CSV > and > am presented with a file download box. My option is where I would like to > save it as a .csv file. On the XP machine I select CSV and Excel is opened > in > I.E. I do not appear to have any control over file associations. All I can > then do is copy and paste the related data into a seperately opened excel > workbook. > I hope this explains things more clearly. > > "Karl" wrote: > >> Just to clarify, when you go to the banking website and click the link to >> download the files, instead of the download window popping up and asking >> if >> you want to save or open the file, it just opens in IE? If so, you could >> try >> right clicking the link and "save target as". If doing that brings up a >> file >> with an .htm extension, then you could just click the link, and when it >> opens in IE, just do File/Save As and save it as .xls or whatever. >> >> When I read the post originally, I thought you were saying that you could >> download the files, but that when you opened them they opened in IE. >> Sorry >> for any wrong info. >> >> >> "BAR" <BAR@discussions.microsoft.com> wrote in message >> news:74E720F9-E873-4A8D-A57E-D9A9304DBB70@microsoft.com... >> > It may well be that the download has an '.html' or '.htm' extension. >> > >> > Just check the file name before you go changing associations. >> > >> > If the file is saved as other than 'name.xls' right click and rename it >> > to >> > 'name.xls' from 'name.htm'. >> > >> > "Karl" wrote: >> > >> > > Perhaps you could change your file association to open with Excel vs >> > > IE? >> > > Right click the file and choose open with, Excel, and check to always >> open >> > > with excel. >> > > >> > > "Dave L" <DaveL@discussions.microsoft.com> wrote in message >> > > news:3765D2E6-BD23-4A49-880B-AAEE51A28648@microsoft.com... >> > > > I have just started using XP, having used Win2K for a couple of >> years, >> > > and >> > > > when downloading my bank statements as CSV it now opens Excel >> > > > within >> > > Internet >> > > > Explorer. On my Win2K machine I can download to a folder. Any help >> > > > appreciated, thanks. >> > > >> > > >> > > >> >> >>
- Next message: Rick \: "Re: System Restore Problem - Another one!"
- Previous message: Arioch: "Re: Ahead Nero InCD"
- In reply to: Dave L: "Re: CSV Downloads"
- Next in thread: Ramesh, MS-MVP: "Re: CSV Downloads"
- Reply: Ramesh, MS-MVP: "Re: CSV Downloads"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
