+ Reply to Thread
Results 1 to 2 of 2

Macro to import a text file with using a date criteria

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Arlington, TX
    MS-Off Ver
    Excel 2003
    Posts
    31

    Macro to import a text file with using a date criteria

    Hi, I have an excel macro enable file that I want to run an import macro to bring everything on a text file with a weird extension (book1.txtv) but it can open in excel. I would like to import only data with date criteria in column I (dd/mm/yyyy), but I want the operator to be able to type in the US format mm/dd/yyyy and the macro copy everything to the next available row. The problem is I don't know where I begin with it, any help would be extremely appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (24 H2) 64 Bit
    Posts
    1,185

    Re: Macro to import a text file with using a date criteria

    If you attach a sample file, someone can suggest a code to you.

+ 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] How Do I Stop A Text File Import From Converting to a Date?
    By jayclinton in forum Excel General
    Replies: 2
    Last Post: 05-04-2017, 01:59 PM
  2. Import data from text, by Macro, With a text box for the file path??
    By locopete999 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2016, 06:30 AM
  3. Replies: 8
    Last Post: 11-12-2012, 02:39 PM
  4. Import text file with criteria
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-29-2012, 06:58 AM
  5. macro to import text file
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2008, 09:08 AM
  6. [SOLVED] Import from text file with German Date seperator
    By Crumb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2006, 05:50 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