+ Reply to Thread
Results 1 to 3 of 3

Export each cell to a TXT

  1. #1
    Registered User
    Join Date
    11-27-2018
    Location
    Mexico
    MS-Off Ver
    2019
    Posts
    13

    Export each cell to a TXT

    Hello Ladies and Gentleman, im facing a situation here and I need your help.

    I have Excel file with this information inside:

    Cell A1: Client1, Cell B1: link/Client1.pdf
    Cell A2: Client2, Cell B2: link/Client2.pdf

    I have more than 5000 records and I need to create a txt file for each Client with this specifications: FileName: CellA1 and inside the file I need the CellB1 in the first line.

    For example,

    Client1.txt inside the file at first line link/Client1.pdf
    Client2.txt inside the file at first line link/Client2.pdf

    Any help?

    Thanks in advance!

  2. #2
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Export each cell to a TXT

    Try this
    Please Login or Register  to view this content.
    Last edited by saravnepali; 11-20-2019 at 09:14 PM.
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  3. #3
    Registered User
    Join Date
    11-27-2018
    Location
    Mexico
    MS-Off Ver
    2019
    Posts
    13

    Re: Export each cell to a TXT

    Thank you!!
    Works like a charm!

+ 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. Replies: 0
    Last Post: 11-10-2016, 10:18 AM
  2. Replies: 1
    Last Post: 07-22-2016, 04:38 PM
  3. Find and export within cell
    By bigtwenty in forum Excel General
    Replies: 4
    Last Post: 12-26-2012, 05:03 PM
  4. I would need a macro to export data from base example workbook to export worbook
    By slato8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2012, 11:21 AM
  5. [SOLVED] Pulling cell contents from a different sheet / adding a static number to export from cell
    By jayinthe813 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2012, 08:55 PM
  6. [SOLVED] Add 1 do previous cell if cell X has value / export value to another Workbook
    By faffol in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-15-2012, 03:28 PM
  7. export in CSV with ; as cell separator
    By bodovoet in forum Excel General
    Replies: 4
    Last Post: 10-31-2006, 11:11 AM

Tags for this Thread

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