1

Importing Text in Excel 2010 - Overwrite previous imports

view story
linux-howto

http://superuser.com – I created a macro, using the recorder, to add a specific .txt file in my Excel file, using a specific shortcut key, in a specific area of the open excel file. However, I've got this problem: when I use the Macro again, the new data does not override the previous data imported, in the same area, but shifts as much as needed to leave the previous data untouched. Is there any way to change this, either with an option or through altering the macro code? Specifically, I would like the macro to check if the cells to be written already have data in them, and clear their contents before importing t (HowTos)