by clicking the browse button window should appear such that i can select the component and get it open in solidworks
Here is an example macro: Open File Example (VBA)
i am able to select the file but cannot open in solidworks
You need to add OpenDoc codes. Check this example: Re: Normal To & Saved Views - Macro
Retrieving data ...