How to apply formatting to a .csv file through VBScript???

[squale]

I have a .csv file that I create through VBScript. The problem I now have is that I want to apply some formatting to the file and save it as a .xls file. I know that .csv files DO NOT allow formatting so that's why I need a .xls file. But the problem is, how do I take my .csv file, then apply certain formatting to it (like making certain rows BOLD), then resave the file as a .xls file?

Is this possible to do through VBScript? Do I need to use an excel macro? if so, can you execute an Excel macro through VBScript?

Thanks!

[Vanny]

Ummm, i am not sure, I never use Excel myself, i always just export as CSV, even though it has limitations.

try this, it has information how to create actual excel documents.

http://www.4guysfromrolla.com/webtech/022801-1.shtml

I think you can also create an excel document though ADODB, but im not 100% sure on that one.