Is it possible to assign to a variable's value, the file that a user selects from within the dialogue window that opens from a SendKeys command?
For example, the following is the procedure linked to a command button on a form;
Private Sub Command15_Click()
AppActivate "Microsoft Access"
SendKeys ("^o"), True
End Sub
When the open file window opens and a user browses and selects a file, can that file path and name be assigned somehow to a string variable within a procedure? I'm trying to create a way for a user to specify an Excel file they want to import, by allowing them to browse to the file and select it.
For example, the following is the procedure linked to a command button on a form;
Private Sub Command15_Click()
AppActivate "Microsoft Access"
SendKeys ("^o"), True
End Sub
When the open file window opens and a user browses and selects a file, can that file path and name be assigned somehow to a string variable within a procedure? I'm trying to create a way for a user to specify an Excel file they want to import, by allowing them to browse to the file and select it.