Update Excel 2003 Code to 2016

Lisichka

New Member
Joined
Jan 18, 2018
Messages
4
I have a code in my Excel sheet to upload multiple pictures from a scanner. In the 2003 version of Excel, I have a Macro for "Insert Picture from Scanner or Camera" function called "TWAIN" with the following code:

Application.CommandBars.FindControl(ID:=1764).Execute

With the changes in Excel, the 2016 version no longer supports this Macro, but my coding skills are minimal so I am in need of assistance on how to write this code using the 2016 version. All help is appreciated!
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,104
Office Version
365
Platform
Windows
I am guessing that maybe this macro uses a special Add-In or Library/Reference.
If you look at it in 2003, go to Visual Basic, click on the Tools menu, and take a look at the References and see which ones are checked.
Then, do the save on 2016 and check to see if any are missing. If so, scroll the list, and see if there are any similar versions.

Likewise, check for Add-Ins, as described here: https://support.office.com/en-ie/ar...in-excel-0af570c4-5cf3-4fa9-9b88-403625a0b460
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,104
Office Version
365
Platform
Windows
I see that you "liked" my reply. Does that mean it solved your issue?
I am curious, which one was it (missing library or missing add-in)?
 

Lisichka

New Member
Joined
Jan 18, 2018
Messages
4
I see that you "liked" my reply. Does that mean it solved your issue?
I am curious, which one was it (missing library or missing add-in)?

I made the post in place of my coworker in the facility. Once I hear back from them, I'll let you know how it went!
 

Lisichka

New Member
Joined
Jan 18, 2018
Messages
4
My coworker's response:
"To answers your questions Yes and no. Excel doesn’t support capturing from a scanner or web cam, so there is no code that supports that. But, looking through the Reference tables pointed me to a “screen clipping tool”. With that tool I am able to capture any pictures off the screen, and insert that into Excel, as long as I have my web cam viewer open. The screen clipping tool works better than the Macro.

I’m still working on the Excel sheet and another Macro. This one is to place the pictures in the top right corner and to the edges of the cell.

Long story short…. Thank you.
You pointed me in the right direction."
 

Watch MrExcel Video

Forum statistics

Threads
1,096,455
Messages
5,450,564
Members
405,617
Latest member
Passi

This Week's Hot Topics

Top