View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Excel Macro Q: Insert-Picture-Scanner....how to?

This brings up the dialog for the user to select from.

Const FromScannerorCamera As Long = 1764
Application.CommandBars.FindControl(, FromScannerorCamera).Execute

NickHK

"Maximus" wrote in message
...
Can't make this work using the Macro Record auto process. I am trying to
automate scanning a picture (dvrs licence) into an area in an Excel sheet.

It
works when I go through the steps manually but when I record a macro it

does
not add the selecting of the Insert-Picture-Scanner-Scan.
I am a rookie so be gentle. Thks