Recent content by sjlevine34

Actually, what I posted was a test program that isolates the issue. In the real application, the links are stored in the database. What concerns me is that, when the filepicker window displays, the file is highlighted in the filename field and one inadvertent keystroke can wipe it out. I...

My major concern is a user inadvertently blundering into the dialog and breaking the link

I tried .SelectedItems.item(1) and it does not solve the problem. Understand that the problem was never with returning the name of the selected file. It is just with the initial file being highlighted when the field is entered.

I am using the following code to select files using Microsoft Office's file dialog: Public Function fTestFilePicker() As String Dim fdFileSelection As Office.FileDialog, lstrFileName As String Const kInitialFile = "F:\Testbed\Test.txt" Set fdFileSelection =...

The approach of shelling OUTLOOK.EXE also has the problem of creating additional instances of Outlook if outlook is already running when you invoke the command. At least this is true for Outlook 2010:banghead: