ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open a menu (https://www.excelbanter.com/excel-programming/390368-open-menu.html)

Greg B[_10_]

Open a menu
 
Hi,
I am wondering the code to open up the menu option of insert a picture from
scanner or camera.

Thanks
Greg



Tom Ogilvy

Open a menu
 
If you actually want to show the menu as you state:

Sub aAA()
'1764
Application.CommandBars.FindControl(ID:=1764).Exec ute
End Sub

--
Regards,
Tom Ogilvy


"Greg B" wrote:

Hi,
I am wondering the code to open up the menu option of insert a picture from
scanner or camera.

Thanks
Greg




joel

Open a menu
 
I recorded a macro and then read a picture. this is the code

ActiveSheet.Pictures.Insert("C:\TEMP\Brooklyn bridge 1.jpg").Select

"Greg B" wrote:

Hi,
I am wondering the code to open up the menu option of insert a picture from
scanner or camera.

Thanks
Greg





All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com