Select particular column

[zoe]

Hi,

I am working on batch conversion of XLS to CSV files.

Ex: There are 100 excel files in Root Folder.
From file "xyz.xls" I would like to select particular ColumnA, ColumnM, and Column Z
and from other file "abc.xls" I would like to select ColumnB, ColumnG
and I would be even looking for transpose (Row Column exchange data\values)
so on from other multiple files and then convert the selection into CSV file.

Basically from couple of files I am looking for particular file and then either convert it to XLS or CSV file.

Please guide me in the above matter.

Appreicate your response

[Paul]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Also, you've broken two rules multiple times in your first few posts here. Not a good start. Please read the forum rules immediately before posting again. Future infractions will result in a temporary ban from the forum.

Thank you.