+ Reply to Thread
Results 1 to 5 of 5

Create CSV files from 2-3 worksheets from workbook & keep workbook intact

  1. #1
    Registered User
    Join Date
    02-05-2013
    Location
    NL
    MS-Off Ver
    Excel 2007
    Posts
    6

    Create CSV files from 2-3 worksheets from workbook & keep workbook intact

    Hi,

    I have a spreadsheet with one main worksheet for time entry.
    In the same workbook I have 3 other worksheets with information based on the time entry worksheet.
    These 3 sheets are formatted i such a way that they can be exported to CSV files, that can be used for upload in our ERP software.
    What I would like to have is a button that users can press after time entry, that will automatically create the 3 CSV files.
    I did some tests for this but my problem is that, when pressing this button, the required CSV files are created but I somehow have renamed my Excel sheet with the last CSV file's name.
    Is there a way to avoid this?
    Thank you for your help.

    I'm working with Excel 2007 and used the following code:

    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 02-20-2013 at 03:58 AM. Reason: Added code tags, as per forum rules. Don't forget!

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Create CSV files from 2-3 worksheets from workbook & keep workbook intact

    This should do it:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    02-05-2013
    Location
    NL
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Create CSV files from 2-3 worksheets from workbook & keep workbook intact

    JBeaucaire,

    Thank you very much.
    This does the thing for me!

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Create CSV files from 2-3 worksheets from workbook & keep workbook intact

    I have marked this thread solved for you.
    In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.

  5. #5
    Registered User
    Join Date
    02-05-2013
    Location
    NL
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Create CSV files from 2-3 worksheets from workbook & keep workbook intact

    Sorry: I'll remember
    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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