+ Reply to Thread
Results 1 to 3 of 3

Eliminate double import of same file in macro

Hybrid View

  1. #1
    Registered User
    Join Date
    02-23-2016
    Location
    KSA
    MS-Off Ver
    2010
    Posts
    3

    Post Eliminate double import of same file in macro

    Hi everyone,
    i am importing a text file into my master excel database using macro, i want to eliminate the double / duplicate imports of same file, meaning, file contains monthly data, i want to make sure that if one time data has been imported, second time macro should not import the same data. HELP please.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,272

    Re: Eliminate double import of same file in macro

    Hi dmsk and welcome to the forum,

    Excel has a function called Advanced Filter on the Data Tab. If you check the box at the bottom of the dialog it will remove duplicates in a table of data.

    Simply do the advanced filter, leave your data where it already is and check the box.

    OR better is there is a Remove Duplicates Icon on the Data Tab in a Group called, Data Tools. Read about this at:
    https://support.office.com/en-us/art...1-8daaec1e83c2
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    02-23-2016
    Location
    KSA
    MS-Off Ver
    2010
    Posts
    3

    Re: Eliminate double import of same file in macro

    Thanks a lot for prompt reply, i am new to vba macros and didnt actually get what you said, i am recording a macro that will first open text file in excel, do text to column function and append the data from this sheet to master excel database, so basically, what my check is if the data already imported formatted from text file it should not append second time.

    hope its clear and waiting for a simple solution.

+ 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] Import CSV file in Excel using ADODB when values in the file have double quotes
    By buran in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2015, 12:51 PM
  2. Macro - Open File Explorer, Select File, Import certain information from file
    By Drayde in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2015, 08:58 AM
  3. [SOLVED] MACRO: Store name of selected file as string w/ import data file dialog box
    By AnnieMcken in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2013, 02:13 PM
  4. [SOLVED] Macro - Master file to import data from another open file with variable file name
    By jdodz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2012, 10:56 PM
  5. Replies: 8
    Last Post: 11-12-2012, 02:39 PM
  6. Import txt file, eliminate dupes, convert data
    By rinser in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-30-2009, 07:49 AM
  7. Macro Import Text File, File Name
    By Bob S in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2006, 06:01 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