Results 1 to 8 of 8

Copy Excel data to Notepad file

Threaded View

rizmomin Copy Excel data to Notepad... 05-19-2015, 08:48 AM
TMS Re: Copy Excel data to... 05-19-2015, 09:26 AM
JBeaucaire Re: Copy Excel data to... 05-19-2015, 09:30 AM
rizmomin Re: Copy Excel data to... 05-19-2015, 10:02 AM
TMS Re: Copy Excel data to... 05-19-2015, 10:12 AM
JBeaucaire Re: Copy Excel data to... 05-19-2015, 10:15 AM
rizmomin Re: Copy Excel data to... 05-19-2015, 10:44 AM
JBeaucaire Re: Copy Excel data to... 05-19-2015, 11:01 AM
  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Copy Excel data to Notepad file

    Hello:

    Please refer to attached file.
    I need VB code to copy data from column D into txt file.
    I have txt file for each store (ColumnA) and the name of the txt file for each store is StoreName.txt
    For Example :
    Store Name : Fayetteville has a txt file as Fayetteville.txt
    Store Name : Riverdale has a txt file as Riverdale.txt
    Store Name : SF0003 has a txt file as SF0003.txt
    and so on

    All these files are in location C:\Temp\Stores\

    So basically
    Fayetteville.txt should have 1 in the file
    Riverdale.txt should have 0 in the file and so on for other store.

    Note : Data will be in from A2 down to A12
    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Opening Notepad a saved notepad file and copying the data on it
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2014, 06:18 PM
  2. Copy data from notepad into excel
    By platesigns in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2014, 12:54 PM
  3. Copying more than one range of data from excel into more than one notepad file
    By brianQ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2013, 01:25 PM
  4. [SOLVED] Copy excel data to notepad.
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2012, 08:56 AM
  5. Extract Data from Notepad file into excel
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 02-21-2012, 01:31 PM

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