S
schnett
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.
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.