+ Reply to Thread
Results 1 to 1 of 1

Macro code to pull cell info into .csv file

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Macro code to pull cell info into .csv file

    Greetings: I am a new (3weeks) user with VBA. I have been given a huge task to complete, and I am very grateful for any help people could offer. I have posted this to the moderator, but perhaps someone else is able to help me in case he already has a ton on his plate. Here is the post

    Mr. Ross,

    I just found your code (see copy below), from back in 2007. YOu helped somebody export info from their sheet into a text file. I'm trying to utilize a macro to copy certain cells into a .csv file so that can be imported inot a database. Would you be able to help me?

    My current code:

    Please Login or Register  to view this content.
    I would like to take the information in cells "B", "C", "D" and "G" and export it to a .csv file with the headers "B" = Task, "C" = Date assigned, "D" = Date Due "G" = Update, and a cell in the csv file that time stamps the import for "Completed" date. I was also hoping that I could pull the "name" of the sheet and drop it into a file to. I know it's a lot, and I hope it's not too much to ask. Please help if can. Thanks so much in advance.

    Your code that I am trying to modify:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by newbie10; 08-31-2012 at 05:00 AM. Reason: Please see the forum rules about proper code tags also

+ 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