<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
Been a while since I used the common dialog box and Iv fogot the commands avaiable. <br />
I want a open &nbsp;file box to pop up and allow the user to search for Excel files (post and pre 2007), I also want the dialog box to open in the my documents folder, I have the code below &nbsp;- its opening the file open box but not applying the filter (I can see all other files) and its defaulting to a templates location on the c drive<br />
<br />
<br />
Me.cdExcelFile.DialogTitle<wbr /> = &quot;Select new source file&quot;<br />
<br />
Me.cdExcelFile.Flags = cdlOFNFileMustExist<br />
Me.cdExcelFile.Filter = &quot;Microsoft Excel Workbooks (*.xls;*.xlsx;*.xlsm)*.xls<wbr />;*.xlsx;*.<wbr />xlsm&quot;<br />
<br />
Me.cdExcelFile.ShowOpen
</div>
</div>


Hi Experts

Been a while since I used the common dialog box and Iv fogot the commands avaiable. 
I want a open  file box to pop up and allow the user to search for Excel files (post and pre 2007), I also want the dialog box to open in the my documents folder, I have the code below  - its opening the file open box but not applying the filter (I can see all other files) and its defaulting to a templates location on the c drive


Me.cdExcelFile.DialogTitle = "Select new source file"

Me.cdExcelFile.Flags = cdlOFNFileMustExist
Me.cdExcelFile.Filter = "Microsoft Excel Workbooks (*.xls;*.xlsx;*.xlsm)*.xls;*.xlsx;*.xlsm"

Me.cdExcelFile.ShowOpen

VBA common dialog box to search for Excel file

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.