kdjonesmtb
New Member
- Joined
- Feb 5, 2010
- Messages
- 31
How can use VBA/macro in Excel to pull text file into Excel spreadsheet specified column using the filename.txt
Example
I have a spreadsheet with over 900 columns of textfile names that contain SQL code in text files
I want to automate pulling text out each file -- and place it in the column associated with the text filenames. The Text files are located on a OneDrive on my laptop --- want the specific syntax to pull the folder path correctly as well
thanks
Example
I have a spreadsheet with over 900 columns of textfile names that contain SQL code in text files
I want to automate pulling text out each file -- and place it in the column associated with the text filenames. The Text files are located on a OneDrive on my laptop --- want the specific syntax to pull the folder path correctly as well
thanks