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
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
