Results 1 to 5 of 5

Thread: Update Excel 2003 Code to 2016

  1. #1
    New Member
    Join Date
    Jan 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Update Excel 2003 Code to 2016

    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!

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,375
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Update Excel 2003 Code to 2016

    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/art...8-403625a0b460
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,375
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Update Excel 2003 Code to 2016

    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)?
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  4. #4
    New Member
    Join Date
    Jan 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Update Excel 2003 Code to 2016

    Quote Originally Posted by Joe4 View Post
    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!

  5. #5
    New Member
    Join Date
    Jan 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Update Excel 2003 Code to 2016

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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •