As we know it is meant for choosing the type of file which we want to open it. Step 8: Now as per syntax we will use Filefilter into the bracket of GetOpenFilename application. It will show the path of that file which we have selected previously into a message box as shown below. Here we have followed the path and selected the excel file named as Test File which usually is in. Now browse the file which we want to select. Step 7: Now compile the code by pressing the F5 function key and run it on clicking on the Play button. Step 6: Now use MsgBox so that we would get the location of the file which we select. Step 5: Now search and select the GetOpenFileName from the activated list of applications as shown below. Step 4: Now in defined variable A use Application as shown below. Choosing a String because we will be choosing or selecting the file name. Step 3: Now define a variable and give it a String as shown below. Step 2: Write the subcategory of VBA Getopenfilename or choose any other name as per your choice to define Subcategory.
0 Comments
Leave a Reply. |