Automatic Import: Very high-level question.

Hello. This is my first post and I'm seeking very high-level information about how to automatically import externally gathered data into Excel.

I have HUGE amounts of ASCII text data which is generated by electronic test equipment. Using techniques I am very familiar with, this text data is already neatly groomed and organized into precise (and manageable) files.

I need some kind of script (.bat file, shell script, python program -whatever) that will automatically import my text data into workbook templates (which I have already created). How do I write a program (or script) that automatically dumps data into a sheet of an existing workbook?

I think I need VBA and/or Macros but, I have very little experience with this aspect of Excel.

Can someone show me an example (or point me to a good reading reference) that shows this?


Thanks in-advance...

Ray

Hi,

have you already tested File Open ... ?

Carim

Originally Posted by Carim

Hi,

have you already tested File Open ... ?

Carim

I need some kind of script (.bat file, shell script, python program -whatever) that will automatically import my text data into workbook templates...

Can someone show me an example (or point me to a good reading reference) that shows this?

This is a non-trivial task. If by chance you don't know much about VBA, I would think this would be a challenge. Anyway, the example you need is here.
http://www.cpearson.com/excel/imptext.htm

Matt

Originally Posted by Mallycat

This is a non-trivial task. If by chance you don't know much about VBA, I would think this would be a challenge. Anyway, the example you need is here.
http://www.cpearson.com/excel/imptext.htm

Matt

Thank you Mallycat. ... Looks like it's time for me to learn VBA now