Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Public Function BrowseForFile() Dim fDialog As Office.FileDialog Dim varFile As Variant Dim strLinkToFile As String strLinkToFile = "" Set fDialog = Application.FileDialog(msoFileDialogFilePicker) With fDialog .AllowMultiSelect = False .Title = "Browse for Spreadsheet" .Filters.Clear .Filters.Add "Spreadsheets", "*.xls" .Filters.Add "All Files", "*.*" If .Show = True Then For Each varFile In .SelectedItems strLinkToFile = varFile LinkExcelSpreadsheet (strLinkToFile) Next Else Exit Function End If End With End Function
|Compile Error - Argument not optional - MS Access - VBA - Adobe Acrobat||2||27|
|Run an action on recently added records to a table||13||62|
|Populating datasheet subform from VBA||6||15|
|Inserting a datasheet query into the body of an email using VBA?||4||20|