I have a folder with a lot of files of the form: defects_*.txt
Assuming the path to the directory containing these files is C:/Path, how can I load just the second column of these txt files into excel?
So column A would be the 2nd column of defects_002.txt, column B would be the 2nd column of defects_005.txt, etc (no constant increment). Can VBA do this, or do I need to use something else?
Hi bjcowen,
This is a problem for Power Query which is an Add-In to Excel 2010.
Read about it at:
http://excelunplugged.com/2015/02/10...n-power-query/
The beauty of Power Query is, once you have built an Excel file using PQ, you simply add more files in your folder and run it again. It will do it again using all the old and new files in that folder.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
great just downloaded it, and now my excel version, which i havent had issues with for years, is giving me all sorts of errors. I feel like you just sabotaged my excel version. I keeping getting Microsoft .Net Framework errors
Last edited by bjcowen9000; 09-19-2018 at 09:09 PM.
Hey - Bad news!!!
Did you download and install from this site?
https://www.microsoft.com/en-us/down....aspx?id=39379
Read the "System Requirements" on the link above and see if I screwed things up for you. I hope not.
I'm using Office 365 for $10/month and it upgrades some features each month. It also has Power Query built in but is called Get & Transform. If you don't have a compatible old version then I'd suggest upgrading to the latest.
Sorry you are having this problem and getting errors.
Here is an answer on Reddit that suggests a possible solution.
https://www.reddit.com/r/excel/comme...uery_download/
I think you need to restart Excel and Reboot your computer before anything else. I'd also insure I had the Windows upgrade if you are using Windows 10. That is on the Windows Settings - Updates and Security.
I have windows 8 and excel 2013. can vba do what I need?
Last edited by bjcowen9000; 09-19-2018 at 10:52 PM.
Note this has been cross-posted here
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks