<div>
I used to use the API call provided by mbizup, but now use the Office.FileDialog method used in Helen's example; &nbsp;I find it easier to use.
</div>


I used to use the API call provided by mbizup, but now use the Office.FileDialog method used in Helen's example;  I find it easier to use.

<div>
I have not forgotten this, am trying suggestions amid system crisis eps!
</div>


I have not forgotten this, am trying suggestions amid system crisis eps!

<div>
<div class="content wysiwyg-content">
I have code that let's the user select files from the browser but then populates a list box &nbsp;but I need to have the user only select ONE file, have this populate a text box on the form and then use this to be passed into the procedure to Import an excel worksheet. &nbsp;My attempts to change the excising code do not work, so any suggestions on how to go about this would be appreciated. &nbsp;Normally I would do research, but. Y deadline is too tight.<br />
<br />
Sandra
</div>
</div>


I have code that let's the user select files from the browser but then populates a list box  but I need to have the user only select ONE file, have this populate a text box on the form and then use this to be passed into the procedure to Import an excel worksheet.  My attempts to change the excising code do not work, so any suggestions on how to go about this would be appreciated.  Normally I would do research, but. Y deadline is too tight.

Sandra

Select file for upload from browser in access2010

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.