Paste from clipboard, VBA

henrik2h

Board Regular
Joined
Aug 25, 2008
Messages
139
Office Version
2019
Platform
Windows
I have created an overview sheet for a project where I also want the user to include a map of the location. The map should go in a special place of the overview (certain cells or a shape) and preferably look nice. Some user will have very limited experience.

I have found that you could fill a shape by what is in the clipboard (it will be skewed) but have not found how to do it in VBA? Anyone knows?

My thinking is the user use the snippet tool on Google maps or other service, then go to Excel and press a macro-button and the picture is inserted. Could this be further automated, for instance could the snippet tool be opened from VBA? Could the snippet tool even be restricted to some proportion (such as 4:3) to avoid skewing when inserting?

Any ideas are welcome, thanks
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,099,386
Messages
5,468,293
Members
406,579
Latest member
lollypop1389

This Week's Hot Topics

Top