Excel Macro Q: Insert-Picture-Scanner....how to?
 

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

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

Excel Macro Q: Insert-Picture-Scanner....how to?
 

Thanks. It worked perfect the first time. I really appreciate it.

"NickHK" wrote:

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