I have a .dat file (csv), and an empty excel file. I would like to make a macro where it would detect when a new row is added to a .dat file and copy new rows to a excel file, added to existing rows. Both files would probably need to be opened.
Does anyone have any macro sample, or ideas on how to do this? I have no idea about excel macros.