+ Reply to Thread
Results 1 to 6 of 6

Export single sheet in csv format?

  1. #1
    Registered User
    Join Date
    06-03-2008
    Posts
    14

    Export single sheet in csv format?

    I'm looking to export a single sheet within several sheets, saving it in csv format so it can by imported in other worksheets. I will eventually record a macro for this which will be linked to a button on the page, but for now I cannot figure out how to export a single page in this format.

    Thank you

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Hi,

    No need to record macros.
    Just Select File -> Save As
    in Save as Type box , select CSV
    It will save only currently selected sheet.

  3. #3
    Registered User
    Join Date
    06-03-2008
    Posts
    14
    lol, sorry I forgot to mention, this has to be run from the button because it has some script which prevents it running without macros & it also has an expiry deadline, in which the save as is limited to Excel files .xls only.

    I have attached the sheet so you can take a peek and see what I mean. The save to csv button will be located in the export sheet.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Hi,

    Delete the macros named Private Sub CustomSave(Optional SaveAs As Boolean)
    and copy the below mentioned code, it will allow u to save in csv format



    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-03-2008
    Posts
    14
    Thanks, but it's limited for a reason. The user isn't a member of the company so they can only save the same file back to itself or another name. All options are still available when called from VB or formula's which is why I need it to run off the button. That way when the sheets are hidden the user can still export the data from the hidden sheet to csv and import it into the new version. You see most of the data is sensitive, but the export sheet can be used throughout the company freely, which is why only one sheet can be allowed to be exported, and also why it expires. Of course most savvy folks can just recode the expiration, but the people who will be using it aren't savvy, just basic level users.

    I hope this explains things a little clearer.

    PS thanks for the help so far.

  6. #6
    Registered User
    Join Date
    06-03-2008
    Posts
    14
    I thnk the following code should do it but I'm getting errors.

    Please Login or Register  to view this content.
    Anybody any idea's?

+ 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