Hi All:
it's actually my first post here, and I am practically new to VBA, so bare with me.
I am running macros that import data from a .txt file, organize it, and then append the new data to historical data base.
Since I am running a macro of macros, and finally closing file and saving automatically ( ActiveWindow.Close savechanges:=True), I risk of running the same macro twice sending duplicates to the destination range.
So how can remove such duplicates using VBA( already have one duplicate), and how can I prevent duplicates within my current macro.
Much appreciated.
it's actually my first post here, and I am practically new to VBA, so bare with me.
I am running macros that import data from a .txt file, organize it, and then append the new data to historical data base.
Since I am running a macro of macros, and finally closing file and saving automatically ( ActiveWindow.Close savechanges:=True), I risk of running the same macro twice sending duplicates to the destination range.
So how can remove such duplicates using VBA( already have one duplicate), and how can I prevent duplicates within my current macro.
Much appreciated.