> Further to my previous post, try the following macro:
>
[quoted text clipped - 5 lines]
> End With
> End Sub
Once again, I thank you for excellent advice. This macro appears to work
well and meets my needs. I have set it up with a toolbar button.
I am not very knowledgeable about macros.
When in the file selection dialog, using the drop-down menu for Insert,
Insert and Link, etc., has no effect. The file is always linked. This is
just fine for me. Will leaving the .LinkToFile set to True affect any other
command? Should the .LinkToFile be reset to anything in particular at the
end of the routine?
If I cancel the file selection dialog I get a run-time error message 5152.
Is there a little code that can be added to cancel gracefully?
John
macropod - 06 Dec 2003 10:51 GMT
Hi John,
Been offline for a few days. To avoid the run-time error, you could insert:
On Error Resume Next
as the second line. There's no need to set the LinkToFile property at the
end of the macro - it's completely volatile and won't affect anything else.
Cheers
> > Further to my previous post, try the following macro:
> >
[quoted text clipped - 20 lines]
>
> John