Importing a Text File Using Macro

P

Paul

I have a macro set up to import a text file, but it imports into the active worksheet. How do I have the macro direct the import to another sheet in the workbook?
 
J

Jim Rech

How do I have the macro direct the import to another sheet in the
workbook?

Typically copy and paste after the import.
 
S

scott

If you don't need a macro you can use Data-Get External Data-import text
file and then you can import it to whatever cell you want.
 
Top