LinkBack URL
About LinkBacks
I'm trying to populate multiple Excel fields with data from multiple notepad files. The code below does not put the data from the notepad file "test.txt" into cell B3.
Is what I'm trying to do possible?
Please Login or Register to view this content.
I'm trying to populate multiple Excel fields with data from multiple notepad files. The code below does not put the data from the notepad file "test.txt" into cell B3.
Is what I'm trying to do possible?
Please Login or Register to view this content.
Last edited by arlu1201; 04-30-2013 at 03:22 PM. Reason: Use code tags in future.
ther'is only one string in the text file ?
If solved remember to mark Thread as solved
You need to read the contents of the text file into a variable and then load the cell with the contents of the variable.
Currently you are populating the cell with the folder and file name.
Patel45....this is only a test before I spend a lot of time on the actual code.
Andy Pope....I'm wet behind the ears when it comes to vbs...what would this variable look like? The contents of the test is: H50976.....324
Thank for both of your replies!
Something like this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks