Automatically insert file name and split as CSVs

[gokuleshdasa]

So, I want that as soon as macro is run it splits the excel file and save like <Worksboom name - Worksheet name>.CSV in the same folder.

Also, in each worksheet, it should automatically insert first column with Workbook Name upto last entry in other columns. This other column can be something column B and sometimes Column D.

After that save as mentioned in first paragraph.

Is it possible?

 

[Marc L]

Should be … So as a reminder well read at least the part How to get the Best Results :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org