Results 1 to 4 of 4

Trying to write code to save file as .csv

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-04-2014
    Location
    calgary, canada
    MS-Off Ver
    Excel 2013
    Posts
    108

    Trying to write code to save file as .csv

    this code works to create all the .pdf's i require - however i need to also create a .csv file of one of the sheets - sheet 1 - what would the line of code be?

    this is the line of code i have for creating the .pdf file

            Sheets("sheet1").Visible = True
            Sheets("sheet1").ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\rqr\" & FName & " Unacceptable " & FDate & ".pdf", quality:=xlQualityStandard, includedocproperties:=True, ignoreprintareas:=False, openafterpublish:=False
            Sheets("sheet1").Visible = False
    i need the same sheet to be saved as a .csv file in teh same directory with the same file name

    any help would be awesome!!
    Last edited by JBeaucaire; 03-04-2014 at 11:11 PM. Reason: Added missing code tags. Please read and abide the Forum Rules, link above in the menu bar. Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA code to save as file with specific file name
    By wolfm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2014, 10:45 AM
  2. Excel 2010 file with VBA save and send code works-but file can't be found.
    By carlton.clay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2013, 09:46 AM
  3. VBA Code to share file and save file
    By brian_2me in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2012, 05:32 AM
  4. Code to save XLA file
    By ExcelCowboy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2011, 08:18 AM
  5. FILE 'SAVE AS' IN VBA CODE
    By Sally in forum Excel General
    Replies: 3
    Last Post: 06-28-2006, 10:45 AM

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