Hi all,
I have a file in xls format and I need to convert it to csv format, but I want it to be a new file and want to be able to specify the name of the new file with a message box. The csv file needs to concatenate all columns of data so that only column A has data. For example the new file will only have data in column A. Cell (A1) would be A1 & "," & A2 & " ," & A3....etc. Please help. I appreciate any thoughts or ideas. I am not much of a programmer so the more information the better. Thanks.
I have a file in xls format and I need to convert it to csv format, but I want it to be a new file and want to be able to specify the name of the new file with a message box. The csv file needs to concatenate all columns of data so that only column A has data. For example the new file will only have data in column A. Cell (A1) would be A1 & "," & A2 & " ," & A3....etc. Please help. I appreciate any thoughts or ideas. I am not much of a programmer so the more information the better. Thanks.