I appreciate your help but... I can't use workbooks.open because it
doesn't support all the options for opening delimited text files in the
way I need to. For example you can't select whether or not it's to
treat multiple delimeters as one or select mulitple delimeters.
-mark

JMB wrote:

you can use workbooks.open to open a text file. just set the format named
argument to specify the delimiter you need as well as the readonly argument.

see help for the open method.

"dominicb" wrote:


Hi Mark

This is what I put in answer to your other question further down the
page:


Good afternoon Mark

Try this

Workbooks.Open Filename:= "C:\TestFile.xls", ReadOnly:=True

The ReadOnly function does seem to be documented, but not to a great
extent. But it works.

It certainlyworks in Excel 2003.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=376539