excel macro, making charts

[howru]

Hi,
Here are the instructions to what I have to do.
I have to open a file called data.csv in macros. I saved the file as xls but the file is actually has to be saved as csv when running my code.
Column 1 is time, column2 is displacement, column 3 is load

The file called data1.csv contains 3 different tests.
The data should be read by macro as follows:
Sheet1 = Test 1
Sheet2 = Test 2
Sheet3 = Test 3

Then I have to create a smooth scatter plot for test1,2, and 3 as force for my y axis and x as my displacement.
Then I have to write a table formatted next to the data numbers as:
Test number Maximum Load

In my attachment, I posted my excel file and if you open visual basic module, you can see my code. Basically what my problem is when I run my code, i get an error saying, "method or data member not found"

Also, if you do run my code, you have to save data.csv first and change the path file first in the code first to where you saved it.

Second question is, my charts won't open up. I need a chart for each the 3 tests but they won't even open from the module.
i can do it by hand, but it needs to be done by the program.
If you can help me, i would really appreciate it.