Hi everyone,
I would like to enquire if anyone know how to write a micro that allows the user to select the file for data query function instead of a fixed file everytime you run a micro?
Thanks very much.
Best regards
KL
Printable View
Hi everyone,
I would like to enquire if anyone know how to write a micro that allows the user to select the file for data query function instead of a fixed file everytime you run a micro?
Thanks very much.
Best regards
KL
What application?
VB ->
common dialog active x?
api calls
VBA (Excel/Access?) ->
application.FileDialog (msoFileDialogFilePicker).Show <<--- read the help files
api calls / common dialog