Now paste the below code in a module and run the procedure Sub Sample() Next for testing purpose, we will take the folder C:\Users\Siddharth Rout\Desktop\Test1 which has 5 csv files numbered from 1 to 5 as shown below. Open a module and add a reference to Microsoft Shell Controls and Automation and Microsoft Internet Controls as shown below Having said that, is it possible to achieve that in VBA since the API SHOpenFolderAndSelectItems is not available? The answer is You may confirm that by checking this MS KB Article There is no other option which will let you select multiple files. Selecting by Description displays a dialog box where you can describe the files you want to either select or deselect.Unfortunately /select option will only let you select single file. Selecting by Patterns, Date & Times, File Sizes and Attributes Locking only prevents the selection state from being changed with the mouse. ( Note: Selecting and deselecting files with the keyboard can be done even with the selection status locked. To deselect a range of files, hold down the Ctrl key along with the Shift Key. To select a range of files starting with the current file, hold down a Shift key while using the Up or Down Arrow keys to move the highlight bar.If the file is already selected tapping the Space Bar will deselect it. To select the highlighted file tap the space bar.Use the Up and Down arrow keys or the Page Up / Page Down keys to move to the file you want to select or deselect.Shift + Arrow keys to select as highlight moves.You can select and deselect files and folders in the contents window using the Space Bar or the Arrow keys You can still change selections with toolbar buttons, menu commands and keyboard. Note that this only applies to actions of the mouse. Prevents any changes to the selection status of files by clicking or clicking and dragging the mouse. When Sticky Mode is active, hold down theĬtrl key while clicking the mouse to temporarily cancel Sticky Mode. When Sticky Mode is not active, hold down theĬtrl key while clicking the mouse to make the selections additive just like in many other programs This allows you to quickly selected multiple entries and ranges of entries without worrying about loosing the selected status of previously selected items. Specifies that when an entry is clicked with the mouse other selected entries will not be automatically deselected. Two options affect how the mouse selects files: Sticky Selections Hold down the left mouse button while dragging across multiple files to select contiguous files, hold down the Shift key while dragging the mouse to deselect contiguous files. Selecting by MouseĬlick on any item to select or deselect it. To deselect files or folder hold down the Shift key while clicking the appropriate menu item or toolbar icon. Versions V3.101 and later, fix the problem.