Thread: How to create a .XLS file instead of a .CSV file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.misc
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default How to create a .XLS file instead of a .CSV file
An easy way is to open it in Excel and then save it as a workbook.

You might just write a CSV file and name it with an XLS extension if the
main gripe is having to change the fileopen dialog to look for a CSV.

--
Regards,
Tom Ogilvy


"Karen Middleton" wrote in message
om...
I have a COBOL program that generates a .CSV file regularly but I have
a problem in the .csv file my users want the file to be in .XLS
instead of .CSV is there a simple way I can turn my .csv file into a
.XLS file please advise.

Can my COBOL program put some structure to turn the .CSV file into a
.XLS file.

Also, can somebody share a VB Script to turn a .CSV file into a .XLS
file.

Thanks
Karen


Reply With QuoteReply With Quote