Me.Image1.Picture = LoadPicture(path & file name) --> Error 53 File not found

Posted on 2012-08-22
Last Modified: 2012-08-22
I attach an excel file in which I attempt to load a JPEG into a UserForm image control.
Also attached is the graphic: Note_Icon.JPEG
I get Error 53 File not found.

'Graphic details:
    'Graphic name: "Note_Icon.JPEG"
    'Graphic size from its properties box: 34.0 KB
    'Graphic location from its properties box: "C:\Users\Roger\Desktop"
Me.Image1.Picture = LoadPicture("C:\Users\Roger\Desktop\Note_Icon.JPEG")

Run active X cmd_Button on sheet 1 - to load UserForm1
Rest of code is in UserForm1.

Please can you help me?
Question by:Kelvin4
    LVL 44

    Accepted Solution

    Are you absolutely certain that you have a path named "C:\Users\Roger\Desktop because there's nothing wrong with your code?

    Author Comment

    Thanks, again
    None of these scripts work:
    Me.Image1.Picture = LoadPicture("C:\Users\Roger\Desktop\Note_Icon.JPEG")
    Me.Image1.Picture = LoadPicture("Desktop\Note_Icon.JPEG")
    Me.Image1.Picture = LoadPicture("Windows\Desktop\Note_Icon.JPEG")

    Me.Image1.Picture = LoadPicture("C:\Users\Roger\Desktop\Note_Icon.JPEG") is taken from the Properties box, location value for Note_Icon.JPEG

    I tried Me.Image1.Picture = LoadPicture("Desktop\Note_Icon.JPEG") as the address bar in Explorer (Windows7) only shows "Desktop"

    How can I diagnose my way through this?
    On the web, this error is not infrequently reported... but there again one trawls stuff up..

    LVL 44

    Expert Comment

    by:Martin Liss

    C:\Documents and Settings\Roger\Desktop\\Note_Icon.JPEG

    if in fact there is a user named 'Roger'
    LVL 44

    Expert Comment

    by:Martin Liss
    Otherwise do a search for it via Start|Search and use the path that you find.

    Author Comment

    Ho Hum:
    It is a 'JPEG image' but a .JPG file extension:
    This works:
    Me.Image1.Picture = LoadPicture("C:\TestImportFile to Excel\Note_Icon.JPG")

    Foolish! I've yet to test out and explain some of the 'failed paths' reported (vs failed files).


    Author Closing Comment

    Panic over.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now