+ Reply to Thread
Results 1 to 1 of 1

Partly Autogenerate filename when saving

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    Delft, The Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Partly Autogenerate filename when saving

    We are filling our ERP system and webshop from 1 master XL-file. All data is in 1 workbook, with one master worksheet which is filled, the other data is copied to other worksheets within the workbook.
    The upload data is a part of the masterdata and content depends on usgae (ERP or WEB) Due to uoload limits, we have to split the data in smaller parts.

    After every update we need to upload all files again, which means that we have to save all separate worksheets as CSV. I want to "automate" this and build a macro that takes selected worksheets and saves the contents in separate CSV files, each with a different name. The name should have a date included and if possible the name of the worksheet.

    Is this possible, and how should I do this?

    please suggest.
    Last edited by pvisser; 02-01-2013 at 08:42 AM. Reason: typo's and better explanation

+ 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