Macro to open folder so I can "Import External Data from a Text"
Hi,
I am using excel 2013
I need a simple macro that will take me to a specific folder to import a text file into my active sheet.
For example in - in sheet1 - I want to import a text file from a list of files - end there.
from - Data Tab/ From Text / and open file where the text files are located.. end sub. I will do the rest manually.
many thanks
Last edited by Mhay5656; 05-30-2017 at 09:42 PM.
Hello Mhay5656,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thank you, have I posted this thread correctly , when I submitted the thread there was a message about introduction
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks