How to select any file in folder name (Left = "Final Test") then kill the file

**tuongtu3** · 10-30-2013, 12:09 AM

Hello All,
I'm looking for code how to open any files which Left 10 chars = "Final Test", do something then kill this file after done.

Please Login or Register  to view this content.

Regards,
tt3

**jindon** · 10-30-2013, 12:14 AM

Please Login or Register  to view this content.

?

**BrianM45** · 10-30-2013, 12:20 AM

Hi all

Try this optimised code

Please Login or Register  to view this content.

**tuongtu3** · 10-30-2013, 12:24 AM

Hi Jindon & BrianM45:
Thank you very much.

How about to kill the file. Please help

Call Macro1
'''I also want to kill the actvbk ("Final Test")
sFname = Dir

Please Login or Register  to view this content.

Regards,
tt3

**jindon** · 10-30-2013, 12:27 AM

Please Login or Register  to view this content.

**tuongtu3** · 10-30-2013, 12:40 AM

Hi Jindon,
That works perfect. Thank you for your time and help.

Regards,
tt3

Re: How to select any file in folder name (Left = "Final Test") then kill the file