Hi, I have a row value of 1013000 1016000 and so on, My file name contains Buoy1_1013000.
May I know how do Modify my code example the Do While Cells(i , 1 ).Value = FileName by matching just the 1013000, not the whole string.
This is how I open my File
Please Login or Register to view this content.
And this is where i want to edit my code. Thanks!!
Please Login or Register to view this content.
Get seven characters starting at position #7 in the file name.
Please Login or Register to view this content.
Ben Van Johnson
Thanks! Can I get the 1st seven character of my cells value let's say Cell (5,1) to cell (8,1) all have the value of 20141101****. I want to to read the file of 20141101**** as well. Thanks!
Hi I tried but it returns error on the code.
Please Login or Register to view this content.
Hi I tried new way to do it but still can't. Error at the if mid function. Help, thanks
[/QUOTE]Please Login or Register to view this content.
The Mid() function has three (arguments) parameters
* The string to extract the sub-string from
* the starting position and
* the number of characters to return
Notice that in your code: Mid(cells(I, 1),0, 8)
you are trying to start at position zero in the string; that's an error. the number must be one or larger; but it can't be larger than the actual length of the test string.
substring = MID(teststring, starting position, num chars to fetch)
Last edited by protonLeah; 12-17-2014 at 04:12 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks