insert file defaults to "My Documents" - MSWORD 1

[cramd2]

I have created macros that changes mapped drives, the macro is then mapped to keyboard shortcuts. Example, if a user needs to "insert a file" from mapped drive "L", they run the "mapL" macro which is assigned to keyboard shortcut ALT+L. User hits alt+l, to change to the mapped drive, and then chooses INSERT, FILE, and the insert file dialog appears but the folder appears as MY DOCUMENTS, not the L drive as needed. The goal is to display the INSERT FILE dialog box with the mapped drive that is needed. I do not want my users to INSERT FILE, with the "my documents" folder appearing, then they have to hit the drop down arrow each time to select the network drive.
Is there anyway to preselect the default folder for the INSERT FILE dialog box?
(Using Office 2000 & Office XP)
cramd2

 

[TonyJollans]

Hi cramd,

You don't say how you're showing the dialog, but this should work ...

[blue]With Application.Dialogs(wdDialogInsertFile)
    .Name = "L:\"
    .Show
End With[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[cramd2]

Tony,
MANY THANKS!! Exactly what I needed, works like a charm!
cramd