Generalized Macro

[Guest]

Hello,
I am very new to programming, I am a scientist by education.I have 2
questions:

1) I am trying to write a macro to do a simple calculation and make a graph
from two column of data. I have successfully recorded a macro for one set of
data. I need to repeat this process amny times. There will be many text files
that will contain the same columns, I want to macro to work on each, no
matter how long the columns are. I am trying to figure out how to generalize
the range variable so that someone can press a button after opening the text
file and get the graph in question.

2) I am also trying to find a way to easily import these text files into
Excel. If I right-click and open with...Excel, they open perfectly for what I
am trying to do, but if I open from inside Excel, I have to go through the
whole import menu. Can I create a form for importing that would open from a
button a menu for choosing the file and then open the file without the whole
import wizard?

Thank you for any advice,
Rebecca

 

[PY & Associates]

1, outside loop each file
inside loop each cell in column of your choice
do your stuff
next cell
next file

2, record a macro
put it in a loop also