Importing tab delimited files into Excel
 

I want to write a method that will call the file open dialog, where
can select a file.

Then, have this tab delimited file popped into my worksheet starting i
the second row.

I am familiar with Access VBA; but have not worked with Excel VBA o
macros before.

How do I do that

--
dpimenta
-----------------------------------------------------------------------
dpimental's Profile: http://www.excelforum.com/member.php...fo&userid=1484
View this thread: http://www.excelforum.com/showthread.php?threadid=27735

Importing tab delimited files into Excel
 

Hi dpimental

Check out
http://www.cpearson.com/excel/imptext.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"dpimental" wrote in message ...

I want to write a method that will call the file open dialog, where I
can select a file.

Then, have this tab delimited file popped into my worksheet starting in
the second row.

I am familiar with Access VBA; but have not worked with Excel VBA or
macros before.

How do I do that?


--
dpimental
------------------------------------------------------------------------
dpimental's Profile: http://www.excelforum.com/member.php...o&userid=14848
View this thread: http://www.excelforum.com/showthread...hreadid=277356