L
Lee Hunter
I am using Access to process an excel spreadsheet using GetOpenFilename to
allow the user to select files.
I am also using InputBox to ask the user if the entire directory of files is
needed or only selected files.
Either the InputBox is not displayed in the Access application and the user
must go to the Excel application to get to the dialog box or the
GetOpenFilename dialog Box is not displayed and they have to go the the
Access Application to see it..
What are the proper settings of "ScreenUpdating" which will allow both
messages to be presented to the user without further user action?
Or is there a better method to achieve my results?
Thanks for your assistance.
Lee
allow the user to select files.
I am also using InputBox to ask the user if the entire directory of files is
needed or only selected files.
Either the InputBox is not displayed in the Access application and the user
must go to the Excel application to get to the dialog box or the
GetOpenFilename dialog Box is not displayed and they have to go the the
Access Application to see it..
What are the proper settings of "ScreenUpdating" which will allow both
messages to be presented to the user without further user action?
Or is there a better method to achieve my results?
Thanks for your assistance.
Lee