Results 1 to 3 of 3

Thread: Excel question

  1. #1
    Shannell
    Guest

    Default Excel question

    As much as I hate to ask off topic, I always get good replies here...



    I want to insert text like this in a cell

    'C':\Documents and Settings\SS\My Documents\websites\Bannersidebar.jpg

    And have the image show up in excel.

    Perhaps showing a small version of the image, because theres about 3000 of
    these, and memory and height of spreadsheet would become an issue I guess??

    EDIT: just had a brainwave, all Im actually wanting to do is check if the
    image is there or not, in the folder , I dont actually need to see the
    graphic (although Id be interested to see how thats done)
    So I think theres a "isthere" function or something? I did actually get a
    "true" displayed for one cell earlier with a local link, but have now
    forgotten how I did that..!!???



  2. #2
    stuart
    Guest

    Default Re: Excel question

    dont know if the text thing will work, but you can use the insert menu to
    add a picture, and then resize it down to the cell size
    "Shannell" <sjs@chargin.org> wrote in message
    news:f2s7lk$muf6@flsun90netnews01.netobjects.com.. .
    > As much as I hate to ask off topic, I always get good replies here...
    >
    >
    >
    > I want to insert text like this in a cell
    >
    > 'C':\Documents and Settings\SS\My Documents\websites\Bannersidebar.jpg
    >
    > And have the image show up in excel.
    >
    > Perhaps showing a small version of the image, because theres about 3000 of
    > these, and memory and height of spreadsheet would become an issue I
    > guess??
    >
    > EDIT: just had a brainwave, all Im actually wanting to do is check if the
    > image is there or not, in the folder , I dont actually need to see the
    > graphic (although Id be interested to see how thats done)
    > So I think theres a "isthere" function or something? I did actually get a
    > "true" displayed for one cell earlier with a local link, but have now
    > forgotten how I did that..!!???
    >




  3. #3
    Shannell
    Guest

    Default Re: Excel question

    Thanks stuart, Im trying to lookup a few thousand pictures to see if they
    exist or not...
    I found it though, its called "filethere" in excel, worked a treat.

    "stuart" <e-znetworks@hotmail.co.uk> wrote in message
    news:f2sb1j$nqb3@flsun90netnews01.netobjects.com.. .
    > dont know if the text thing will work, but you can use the insert menu to
    > add a picture, and then resize it down to the cell size
    > "Shannell" <sjs@chargin.org> wrote in message
    > news:f2s7lk$muf6@flsun90netnews01.netobjects.com.. .
    >> As much as I hate to ask off topic, I always get good replies here...
    >>
    >>
    >>
    >> I want to insert text like this in a cell
    >>
    >> 'C':\Documents and Settings\SS\My Documents\websites\Bannersidebar.jpg
    >>
    >> And have the image show up in excel.
    >>
    >> Perhaps showing a small version of the image, because theres about 3000
    >> of these, and memory and height of spreadsheet would become an issue I
    >> guess??
    >>
    >> EDIT: just had a brainwave, all Im actually wanting to do is check if the
    >> image is there or not, in the folder , I dont actually need to see the
    >> graphic (although Id be interested to see how thats done)
    >> So I think theres a "isthere" function or something? I did actually get a
    >> "true" displayed for one cell earlier with a local link, but have now
    >> forgotten how I did that..!!???
    >>

    >
    >




Posting Permissions

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