When you double-click on the file, the file name will be sent to your program on a command line - which you can read this from the Command function, eg:
Code:
Msgbox "File to open: " & Command
As to actually loading the file, see this article from our Classic VB FAQs.