+ Reply to Thread
Results 1 to 4 of 4

Trying to write code to save file as .csv

  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

    Please Login or Register  to view this content.
    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.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Trying to write code to save file as .csv

    Hi, winwall,

    maybe like this:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

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

    Re: Trying to write code to save file as .csv

    Solved thanks!!!

  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: Trying to write code to save file as .csv

    I've marked this thread as SOLVED for you.
    Next time, you can select Thread Tools from the links above to mark a thread as SOLVED. Thanks.
    _________________
    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!)

+ 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] 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. [SOLVED] 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