Hello,
I am importing csv data. I want to write a macro of a query to let the
user select which files to import and how many to import.

One example I would like my macro to do is the following :
1. There exist 3 csv files. The user imports all 3 files and puts them
on one worksheetsheet.
2. The macro formats the columns on the sheet.
3. Puts a check mark box over columns named A,B,C. To select or
deselect columns to have on graphs. Puts a checkmark in every box as a
default.
4. Sets up a x,y graph, graphing the checked columns as A(x),C(y). Sets
up another graph B(x),C(y)

Can you teach me or get me started on what I have to do for steps 1
through 4 ?

I have done formatting and graphing with a macro but never all at
once.

One of my main questions is : What if there is 2 csv files instead of 3
? How do I fix the error the macro gives me when it's looking for the
3rd file ?

I can clarify more if you need it. Thank you.


--
schnett
------------------------------------------------------------------------
schnett's Profile: http://www.excelforum.com/member.php...o&userid=12035
View this thread: http://www.excelforum.com/showthread...hreadid=540905