Oops, have just reread the last bit of the macro and it does say inline.
Would appreciate advice about the other two queries, though
Many thanks
Sol
On 4/9/05 12:49, in article BF409DF0.764A%Sol@solapache.com, "Sol Apache"
<Sol@solapache.com> wrote:
The following code will allow the user to select the folder that contains
the pictures
Dim MyPath As String
'let user select a path
With Dialogs(wdDialogCopyFile)
If .Display() <> -1 Then Exit Sub
MyPath = .Directory
End With
'strip quotation marks from path
If Len(MyPath) = 0 Then Exit Sub
If Asc(MyPath) = 34 Then
MyPath = Mid$(MyPath, 2, Len(MyPath) - 2)
End If
'MyPath will now contain the path to the folder that the user selected
To delete anything from the cell, delete the .Range of the cell.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
> Oops, have just reread the last bit of the macro and it does say inline.
> Would appreciate advice about the other two queries, though
[quoted text clipped - 73 lines]
>>
>> Thanks for any help and thanks very much Jay for this excellent macro.
Sol Apache - 04 Sep 2005 19:13 GMT
Thanks Doug. This presumably opens a dialog box, but I wanted to ³hard wire²
a file path (directory path) within the macro.
Also I have tried your ³delete the .range² but the macro keeps stopping
here. Obviously I do not know the proper syntax to get it to work.
On 4/9/05 16:01, in article uchQOGWsFHA.3216@TK2MSFTNGP12.phx.gbl, "Doug
Robbins" <dkr@REMOVEmvps.org> wrote:
> The following code will allow the user to select the folder that contains
> the pictures
[quoted text clipped - 18 lines]
>
> To delete anything from the cell, delete the .Range of the cell.
Doug Robbins - 04 Sep 2005 20:59 GMT
If you include the following in your code
Options.DefaultFilePath(wdPicturesPath) = "C:\Documents"
when the Insert>Picture>From File menu item is used, the C:\Documents folder
will be opened in the File>Insert Picture dialog.
Change the C:\Documents to the path that you desire.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
> Thanks Doug. This presumably opens a dialog box, but I wanted to ³hard
> wire²
[quoted text clipped - 28 lines]
>>
>> To delete anything from the cell, delete the .Range of the cell.