ExcelBanter - View Single Post - Excel VBA-Importing txt files with VBA

pwdiaz

Hi All!

I need to write a procedure that will import txt files into Excel. Th
procedure, when called upon, must allow the user to select the tex
file. These txt files contain data from instruments such a
spectrophotometers, luminometers etc and are typically written in ro
and column formats using various delimiters depending on the machin
that generated them. Some txt file outputs are in tab deliminte
format others are in csv etc. Generally the data is in either an 8x1
or 16x24 matrix or array if you prefer, representing the format of th
original microplate from which the data are derived. All I need is
tip or example code that will allow the automated import of th
selected text file with each element of the matrix or array to appea
in discrete cells of the work sheet. I am by necesssity workin
directly with text files rather than a database so hopefully someon
has a solution that can do the import directly from the text file.

Thanks!

Pau

--
Message posted from http://www.ExcelForum.com