File Search question...

[UniversalJOC]

I have a command button that will search for and open specifically named files. These files are text documents is there a way to delimit automatically in the macro? (From tab to other with character'|')

Thanks

 

[dk]

You can specify the delimiting character when using Workbooks.Opentext. To get a better explanation type Opentext into Excel's VB help but this should get you going:-

Workbooks.OpenText Filename:="C:temptest.txt", DataType:=xlDelimited, other:=True, otherchar:="|"

HTH,
D