Change a macro to from and absolute cell reference to selected cell.

i am currently using the macro below to import text files into a spreadsheet. Currently, it begins the import in cell A1 which is what I recorded it to do. how do I change the code to begin the import on the active cell?

Please Login or Register  to view this content.

Thanks!