Control Name

[Richard]

Can someone please tell me the name of the control that allows you to browse
the directories and folders. I would like to be able to browse to an excel
file in "My Documents" to import. And second can I do this from my Import
spreadsheet macro?

Thanks
Richard

 

[Ken Snell MVP]

See this article:

Browse to a single EXCEL File and Import Data from that EXCEL File via
TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpBrowseFile

 

[Albert D. Kallal]

Can someone please tell me the name of the control that allows you to
browse
the directories and folders. I would like to be able to browse to an excel
file in "My Documents" to import. And second can I do this from my Import
spreadsheet macro?

Thanks
Richard

In 2002 and later, you can place a button on a form, and the code behind
that button can be:

Dim f As FileDialog

Set f = Application.FileDialog(msoFileDialogFilePicker)
f.Filters.Clear
f.Filters.Add "Excel", "*.xls", 1
f.Show

DoCmd.TransferSpreadsheet acImport, , "myTable", f.SelectedItems(1)


In the above, you have to change "myTable" to the name of the table you want
the data to go into...

I not 100%, but the FileDialog feature might have only been added to access
2003 and later. So,if you have a earlier version...there is other code
possibilities, but the above is the least amount of code.

 

[Richard]

Thank you.

See this article:

Browse to a single EXCEL File and Import Data from that EXCEL File via
TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpBrowseFile


--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Richard]

Thank you Albert

In 2002 and later, you can place a button on a form, and the code behind
that button can be:

Dim f As FileDialog

Set f = Application.FileDialog(msoFileDialogFilePicker)
f.Filters.Clear
f.Filters.Add "Excel", "*.xls", 1
f.Show

DoCmd.TransferSpreadsheet acImport, , "myTable", f.SelectedItems(1)


In the above, you have to change "myTable" to the name of the table you want
the data to go into...

I not 100%, but the FileDialog feature might have only been added to access
2003 and later. So,if you have a earlier version...there is other code
possibilities, but the above is the least amount of code.

 

[Alicia Susana Satas]

Can someone please tell me the name of the control that allows you to
browse
the directories and folders. I would like to be able to browse to an excel
file in "My Documents" to import. And second can I do this from my Import
spreadsheet macro?

Thanks
Richard