Re: CSV Downloads



Rod V
07-10-2005, 01:09 AM
By editing the registry as Ramesh suggested the problem has been solved, .CSV
files can be moved into Excel 97 without any loss of formatting. Thanks for
your help.

Rod V

"Ramesh, MS-MVP" wrote:

> 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
> [url]http://windowsxp.mvps.org[/url]
>
>
> "Dave L" <DaveL@discussions.microsoft.com> wrote in message
> news:E94CA24D-5E1B-4F5D-8E04-A3262C029E72@microsoft.com...[color=green]
> > 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:
> >[color=darkred]
> >> 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.
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>[/color]
>
>[/color]

Ramesh, MS-MVP
07-10-2005, 01:09 AM
You're welcome Rod. Thanks for taking the time to post back.

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org


"Rod V" <RodV@discussions.microsoft.com> wrote in message
news:0430EA4F-C597-4453-A3AB-05FD176B5BB2@microsoft.com...
> By editing the registry as Ramesh suggested the problem has been solved,
> .CSV
> files can be moved into Excel 97 without any loss of formatting. Thanks
> for
> your help.
>
> Rod V
>
> "Ramesh, MS-MVP" wrote:
>
>> 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...[color=darkred]
>> > 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.
>> >> > >
>> >> > >
>> >> > >
>> >>
>> >>
>> >>
>>
>>[/color]


Re: CSV Downloads