+ Reply to Thread
Results 1 to 2 of 2

Export single sheet as CSV?

  1. #1
    Registered User
    Join Date
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010

    Export single sheet as CSV?

    Hi peeps,

    I have a question, which would help me a lot with a project I'm working on.

    Basically, I am typing in different data (dates, notes and numbers in different columns) of, say Sheet1 of an Excel workbook.
    Now, in Sheet2 these data are being sorted differently (basically just simple formulas, moving around on some of the info from Sheet1). The sorted data in Sheet2 is then copied into a new excel workbook, and saved as a separate .csv file, since the data is going to be used in another application/program which uses .csv files.

    Now, what I am really curious to find out is, if it somehow is possible to create an application/program that can automatically export Sheet2 as a separate .CSV file? In that way, I wont have to open a new file, paste the data, and save the new file as a .CSV file.

    Also, as this is a process that I am repeating quite a lot of times during the day, it would be awesome to basically have the original Excel file where I type in the data in Sheet1, and then some sort of an "Export" button which basically copies the data to Sheet2, and then exports Sheet2 as a separate .CSV file.

    Is this somehow possible? And if so, how? (even outside of Excel programming).

    I truly hope somebody can help me out on this.
    Thanks in advance,


  2. #2
    Forum Expert
    Join Date
    Leghorn, Italy
    MS-Off Ver
    Excel 2010

    Re: Export single sheet as CSV?

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

+ 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. [SOLVED] Need a macro to export a single sheet as - Paste special (Values)
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2012, 12:00 PM
  2. Export matrix to single text
    By Kb24 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-05-2009, 01:27 PM
  3. Export single sheet in csv format?
    By bluefrog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-08-2008, 06:55 AM
  4. Trying to export data from a single column file
    By chaznsc in forum Excel General
    Replies: 3
    Last Post: 05-17-2007, 12:37 PM
  5. [SOLVED] export a single row to word
    By Sketch in forum Excel General
    Replies: 1
    Last Post: 05-15-2005, 05:07 PM


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