Hi,
I have a folder with multiple logon details for my company network. This is generated by a script at logon. Every time the script runs it creates a new line so I would need the last line of the text file.
It looks like this,
tuttd logged onto HCRPC23138, IP address 10.201. 33. 24 at 14:47:20 on 2012/06/28
The first characters are the username, the test file is also called HCRPC23138. The spread sheet contains the name (HCRPC23138) in the first column. What I would like to do is get the test file based on the name in A:1 and the put the username in the next column. I am not very good at VBA. Well to put it plainly I suck at it. I have created powershell scripts to do the work however it is still quite a manual process copying and pasting the values from CSV’s
I have checked Import Specific line from multiple text files however it doesn’t quite work. As it puts all the text file information in the spread sheet.
Thanks,
Bookmarks