Menu

Excel VBA-Importing txt files with VBA

Search this Thread

Prev

Previous Post

Next Post

Next

#1

Report Post

Posted to microsoft.public.excel.programming

pwdiaz

pwdiaz is offline

external usenet poster

Posts: 1

Default

Excel VBA-Importing txt files with VBA

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing CVS files into Excel	summerelli	Excel Discussion (Misc queries)	2	August 31st 09 03:14 AM
Importing a Value from many Excel Files	STOVK	Excel Discussion (Misc queries)	2	September 25th 06 02:23 AM
Importing Files into Excel	[email protected]	Excel Discussion (Misc queries)	2	June 27th 06 06:43 PM
Importing CSV files into Excel	Doug	Excel Discussion (Misc queries)	9	August 24th 05 08:22 PM
importing files into excel	Gabby	Excel Discussion (Misc queries)	2	January 13th 05 09:41 PM

All times are GMT +1. The time now is 11:51 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement