How can I set up Excel 97 to automatically convert/open .csv files

J

Jean-Luc240660

How can I set up Excel 97 to automatically convert/open .csv files in xls
format without having to use conversion each time ?
 
D

Dave Peterson

I haven't used xl97 in a longggggg time, so this is a guess.

Try reregistering excel.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets some of the windows registry to
excel's factory defaults.

And if I recall correctly, .csv files should be opened in excel by default.

One more question...

If you're not using an English version of excel, then maybe the default
extension for comma separated values isn't .CSV????

Do you see that as an option in the the File|SaveAs dialog?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shortcuts in OneDrive 0
Convert PDF to Visio File or Editable PDF in Visio 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Excel does not accept text format! 0
How to Write EXCEL files from a FORTRAN Program ? 0
Keeping to ms office 97 pro 0
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
Excel opening 1

Top