Importing Macro VBA Help - Data Import Window on Macro

Hello VBA Forums.

My name is Zhi. I am new to this forum~ I have some VBA basic skills but I have not used it for a while and trying to get back into using it. Recently, I am trying to analyse a bunch of data which makes it extremely tedious to do it manually. I have this set of data which contains two columns.

I am interested in finding out the area below it using a Macro so I can load a .CSV file and spit out a value with the ability base on a very simple mathematics formula. My question is, how can make such a VBA run a macro when I hit "1. Run Macro > 2. Open Import Data Dialog > 3. Select the .CSV File > 4. Run Macro"?

I would like some help with Step #2? I highlighted the part which I want to adjust. But I do not know what to press to make it open a "Window File Selection" box so I can choose the .CSV file. I want it to be able to computer everything as soon as I select that CSV file. Thank you in advance.

My current code looks like this:

Please Login or Register  to view this content.

[/SIZE]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)