+ Reply to Thread
Results 1 to 30 of 30

Opening a text file copying a specific set of info for a list off numbers

Hybrid View

  1. #1
    Registered User
    Join Date
    06-01-2017
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    18

    Re: Opening a text file copying a specific set of info for a list off numbers

    dflak,

    to answer your questions.

    1) please use the 'parts list' tab and read the part numbers in column A and column C if possible

    2) No we cannot depend on them being the same line each time, we can use the first one that appears (as they always should be the same) - to find the first I always such for "0 TR" and then look for the number after it.

    3) I only sent 9 directories to show you what I mean and what the mpf looks like. There are over 5000 directories also, I just couldn't zip them all. I can send you more if needs me? they are all in the same location each time (G:\Trimming)

    4) If you cant find a directory we can just skip over and im guessing the code will enter N/A?

    if you need any more info let me know.. Appreciate your help!!!

  2. #2
    Registered User
    Join Date
    06-01-2017
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    18

    Re: Opening a text file copying a specific set of info for a list off numbers

    just want to clarify,

    when we are searching the part number in the directory from Columns A or C, does it search an exact search, e.g. word for word. Or can it pick up characters?

+ 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: 1
    Last Post: 09-16-2015, 04:14 AM
  2. Replies: 1
    Last Post: 04-26-2015, 01:58 PM
  3. get info from another excel file without opening it
    By dbrizor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2015, 08:06 AM
  4. List of all row numbers that contain a specific text string
    By spoursy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2015, 07:24 AM
  5. Replies: 4
    Last Post: 01-18-2012, 07:43 AM
  6. Opening EXCEL with a specific file opening also
    By HitTheEXCELerator in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2011, 12:51 PM
  7. Replies: 2
    Last Post: 01-06-2006, 01:45 PM

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