But instead of immediately pasting the image from the text on the
clipboard (into fixed cell A30) it brings up a browser dialog.

The purpose of my version is for efficiency:

1. It has no external dependancies;
-doesn't use the clipboard and so doesn't require a ref to Forms2.0
-it doesn't require using Macro Express

2. It inserts the picture wherever you decide before running the macro;
-gives you greater flexibility over using a hard-coded target

3. It allows you to specify the full path to the pic;
-encapsulates the process within a single app

4. The code is reusable in other projects;
-except for the selection of row27 (could be done manually
-allows you to do similar process in other projects

So unless this is a dedicated task project, generic code that's reusable is
always a better asset to have in you repertoire!

I'm happy enough using my fully working macro below (based on my
trial/error adaptations from killme2008's), but I'm keen to know why
(unlike yours) it fails when placed outside PERSNAL.xlsb.

Your PERSONAL.xls probably has a ref to the Forms2.0 lib by way of
Tools::References or it contains a Userform.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion