+ Reply to Thread
Results 1 to 3 of 3

Merge 2 codes and assign it to Command Button

  1. #1
    Forum Contributor
    Join Date
    06-12-2013
    Location
    india
    MS-Off Ver
    Office 365
    Posts
    146

    Merge 2 codes and assign it to Command Button

    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.
    Attached Files Attached Files
    Last edited by Giri.hb; 10-21-2019 at 03:30 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,956

    Re: Merge 2 codes and assign it to Command Button

    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.)

  3. #3
    Forum Contributor
    Join Date
    06-12-2013
    Location
    india
    MS-Off Ver
    Office 365
    Posts
    146

    Re: Merge 2 codes and assign it to Command Button

    As informed I have updated. Please check and help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can't Assign Macro to Command Button??
    By Novice_704 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2008, 12:28 AM
  2. VB codes for delete command button (new)
    By Lilly in forum Excel General
    Replies: 1
    Last Post: 04-25-2007, 01:15 AM
  3. VB codes for delete command button
    By Lilly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2007, 07:16 AM
  4. [SOLVED] how can I assign a password to a command button
    By Help! in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2006, 09:55 AM
  5. How can i assign a marco to a command button
    By Eric in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-29-2005, 08:05 PM
  6. How to assign a marco to a command button
    By Eric in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1