Hello all,

I have an interesting request. I'm pretty new to writing macro's for Office, but I'm no stranger to VB. The issue I'm having is:

I need to be able to convert a .xls file to a .csv file from a script. I know that office allows you to pass a macro to be executed from the command line via the /m switch. The problem is getting the macro to work.

I'm using Office 2003, and if i record a macro, then go to file_saveas, change the filetype to .csv, it all works fine. Except for the fact that it asks the user for input, example: If there are more than one sheets in the workbook, it will pop up with a message box informing you. Also another message box pops up saying "File may contain features that are not compatible with CSV ...." do you want to keep the .csv format? and it has a Yes, No, and Help button.

I was wondering if there is a way to force it to save in the format without asking for user input (so it is script friendly).