MS Excel / VBA help thread

You are reading a single comment by @dst2 and its replies. Click here to read the full conversation.

•

aggi in reply to @dst2
This will get you close
```
Sub OpenFile()
Dim myfile As String

With Application.FileDialog(msoFileDialogFilePicker)
    .InitialFileName = "C:\TEMP\filename*"
     .Show
    myfile = .SelectedItems(1)
    End With

Workbooks.Open Filename:=myfile

End Sub
```
(Obviously replace c:\temp with your directory). Have a google of msoFileDialogFilePicker for some of the other variables

Although if you really don't want them to select other files I'd be tempted to use VBA to create a sheet with a list of the files that they can open hyperlinked to the location.

•

dst2 in reply to @aggi

Thankyou, will have a look if I get time tomorrow.

•

christianSpaceman in reply to @dst2

I think you can use 'chdir' right before your getopenfilename to change the location it opens up in. I've not tried this on a SharePoint drive.

The code above from @aggi looks like it's probably the better way to do it though.

About

Avatar for dst2 @dst2 started