File Search question...

UniversalJOC · Feb 26th, 2002, 01:24 AM

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 · Feb 26th, 2002, 02:17 AM

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:-

Code:

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

HTH,
D

Feb 26th, 2002, 02:17 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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:- Code: Workbooks.OpenText Filename:="C:temptest.txt", DataType:=xlDelimited, other:=True, otherchar:="\|" HTH, D

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 01:24 AM	#1
UniversalJOC New Member Join Date: Feb 2002 Posts: 40	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