Hello folks, I'm trying to add a standard "File Open" dialogue box into a userform, in Excel 2016 64-bit version.
(1) There is a way to do this in Excel 32-bit version, described here:
Design a VBA User Form - ComboBox and Open File Dialogue Box Controls
In short, [VBA Editor - Tools - Additional Controls - Microsoft Common Dialog Controls] would add File Open diaglogue box to the VBA Editor toolbox.
In 64-bit Excel, "Microsoft Common Dialog Controls" is not available.
(2) If I were not adding this "File Open" dialogue box to a userform, it is pretty easy to just launch the "File Open" dialogue box using "Application.FileDialog(msoFileDialogFilePicker)".
This is not what I am trying to do.
Can anyone help? Thank you in advance!
IJ, Seoul
(1) There is a way to do this in Excel 32-bit version, described here:
Design a VBA User Form - ComboBox and Open File Dialogue Box Controls
In short, [VBA Editor - Tools - Additional Controls - Microsoft Common Dialog Controls] would add File Open diaglogue box to the VBA Editor toolbox.
In 64-bit Excel, "Microsoft Common Dialog Controls" is not available.
(2) If I were not adding this "File Open" dialogue box to a userform, it is pretty easy to just launch the "File Open" dialogue box using "Application.FileDialog(msoFileDialogFilePicker)".
This is not what I am trying to do.
Can anyone help? Thank you in advance!
IJ, Seoul
