Merge 2 codes and assign it to Command Button

[Giri.hb]

I have code given below where 1st code will split the data in the multiple worksheet in the same workbook based on the selected column and I am using the 2nd code to split the multiple worksheets in to multiple work books.

So I need your help to merge the code and the code should work to split the data directly to multiple workbook instead of work sheets. Also I need to assign that code to Command button given in the attached macro work book. Where when I click the command button it should ask for the report(.xls or .xlsx or .csv) and below given codes will take care of remaining workflow to split the data.

1st code

Please Login or Register  to view this content.

2nd code is given below...

Please Login or Register  to view this content.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Giri.hb]

As informed I have updated. Please check and help.