Pasting text into VBA macro?
GS wrote:
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.
Thanks, yes, that proved to be the reason.
I've archived your version filed for future use, but this is a very
specific project as you may have gathered from my illustrations.
Terry, East Grinstead, UK
|