Hi. I am trying to set up a macro to import many text files into a table. I have written a macro to import the text file, but I not only need to change the text file name, I would also like a way to import ALL of the text files without being prompted for each one. (There are thousands of files.) I could get all of the file names into a table to reference if that would help. Does anyone have any suggestions on where to start with this? Thank you so much for any help!
Importing numerous text files
- Thread starter mindyi
- Start date
ted.martin
Registered User.
- Local time
- Today, 13:47
- Joined
- Sep 24, 2004
- Messages
- 743
You will only achieve the automation you require with VBA.
You are on the right path by creating a table with all the filenames (AND Paths) so that the principle of looping through them would then be possible as the loop runs from each table record to the next.
Do you know anything about VBA? If not what you can do to get started is write a macro to get one working and then using the Macro/Tools option, select Convert Macro to Visual Basic. Post that code here and someone will be able to help you.
You are on the right path by creating a table with all the filenames (AND Paths) so that the principle of looping through them would then be possible as the loop runs from each table record to the next.
Do you know anything about VBA? If not what you can do to get started is write a macro to get one working and then using the Macro/Tools option, select Convert Macro to Visual Basic. Post that code here and someone will be able to help you.
Similar threads
