Importing a Text File Using Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
How do I have the macro direct the import to another sheet in the
workbook?

Typically copy and paste after the import.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes no drop down list and macros 4
macro-import another xls file 15
Importing Text Files Into Access 1
Importing any excel files with any sheet name into different tables in MSAccess using code 0
Macro Compatability 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
Deleting all named ranges that have a workbook scope 3
Sheet tab names change automatically 3

Back
Top