Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need some help and explaination. Thks.
Thks dave for your advice. I have kinda solve the problem using primitive solution as below: .LookIn = "z:\GsmOmc\TrafRept\in-bound-roamer\" '.FileName = "in_*.txt" .FileName = ".txt" = solution If .Execute 0 Then Year = "" For i = 1 To .FoundFiles.Count Filenames = .FoundFiles(i) = solution Filetype = Right(.FoundFiles(i), 4) = solution If InStr(1, Filenames, "in_", vbTextCompare) = 36 An StrComp(".txt", Filetype) = 0 Then = solution This is just case someone like me who is desperate for a quic solution. How about checking your filenames before you do anything with them? Dave I have check the filenames by inserting the msgbox command an have confirm they are correct. BTW do you still have the links for that articles you mention? M window XP platform has been giving me lots of headache ever since i has been setup. Now I have faced with another problem which I hav posted separately to avoid confusion. : -- stevetan201 ----------------------------------------------------------------------- stevetan2010's Profile: http://www.excelforum.com/member.php...fo&userid=1624 View this thread: http://www.excelforum.com/showthread.php?threadid=27647 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function explaination need | Excel Worksheet Functions | |||
I need to understand how the IRR, NPV and FPV formulas work? Thks | Excel Worksheet Functions | |||
Formula explaination | Excel Discussion (Misc queries) | |||
Need some help and explaination. Thks. | Excel Programming | |||
Need some help and explaination. Thks. | Excel Programming |