-
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..!!???
-
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..!!???
>
-
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
-
Forum Rules