Hi all,

I'm new in this forum and I sign up as i believe the guys here can help me with the problem on macro that I have.

Well firstly I need to write a macro that prompt me to select a file so that I can use that selected file data to calculate the average, max , min and standard deviation.

I have no idea how to go about doing it. I have tried putting the functions of the average, max, min and standard deviation to the worksheet but it only allows me to get data from fixed location when I run macro.

Hope someone can help me with this.

Thanks very much.



Best regards
tkl