LoadPicture function appears restricted in Office:mac

From: steven.allen17_at_gte.net (steven.allen17_at_verizon.net)
Date: 06/29/04

  • Next message: Frederico: "Shortcut to eject CD tray" 
    Date: Tue, 29 Jun 2004 16:06:29 GMT

    I posted this article on microsoft.public.vb.winapi.graphics and received
    a response indicating that I might be having a problem with the file path
    specification on my Mac OS X version of VB. I tried a test and just did a
    chdir and then a filedatetime on the file and then on the full path for
    the file and that worked fine. So I know it is not the path spec that is
    getting me in trouble. It is the LoadPicture function itself is somehow
    restricted in the Teacher/Student edition of Office:mac. Can anyone verify
    if this is true or not. I am an educator and my application requires being
    able to load image files dynamically. Here is the original content of my
    posting to the vb news group. I hope that someone reading THIS group will
    see this posting and be able to give me some feedback. Thanks.

    Original Posting:

    I am fairly new to VB in Mac Excel 2004 or any other VB for that matter. I
    have succeeded in building a gui front end to a workbook with several
    worksheets and was really feeling my oats when I came to the point when I
    wanted to be able to load graphics files into an Image object which I had
    added to my Userform using the VB toolbar. I then proceeded to use the
    properties page to manually set the picture property of the image1 object
    from a "browsed" bitmap file on the disk and that worked great. But when I
    tried "dynamically" loading the graphics file into the image object's
    picture property using LoadPicture as mentioned in the VB help pages
    within Excel. I used the following line in one of the CommandButton_click
    routines:
    Image1.Picture = LoadPicture("Macintosh
    HD:Users:sjallen:Documents:stevebox.bmp")

    I see the following message displayed on the screen when this line of code
    is executed:

    Compile error:

    Function or interface marked as restricted, or
    the function uses an Automation type not
    supported in Visual Basic

    It seems that everyone uses this function so I figured I am doing
    something very fundamentally dumb. By the way, this is the teacher/student
    edition of Office:mac 2004.

    An instructor in need :-)

  • Next message: Frederico: "Shortcut to eject CD tray"