Stuart McLachlan
stuart at lexacorp.com.pg
Fri Apr 22 17:05:01 CDT 2011
NO! Repeat after me, seven times... "Variants are an abomination. They are rarely required and must be used with caution" The Split() function returns a String array. So Dim Test() as Stinrg is correct. -- Stuart On 22 Apr 2011 at 16:57, philippe pons wrote: > Dim Test() As Variant > > Philippe > > 2011/4/22 Kaup, Chester <Chester_Kaup at kindermorgan.com> > > > I am trying to use the split command on the following string > > > > " 0.000 243.729 > > - > > 61.495 -" > > > > I have a dim statements as follows > > Dim LineText As String > > Dim Test() As String > > > > The split statement is as follows > > Test = Split(LineText)(0) > > > > No matter how I dim Test() I get an error message of > > Run Time Error 13 > > Type Mismatch > > > > This seems like it should be real simple but I am obviously missing > > something. > > > > Thanks. > > > > > > > > > > Chester Kaup > > Engineering Technician > > Kinder Morgan CO2 Company, LLP > > Office (432) 688-3797 > > FAX (432) 688-3799 > > > > > > No trees were killed in the sending of this message. However a large > > number of electrons were terribly inconvenienced. > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >