Is there any way to extract an icon from an application?
Take a look at the ExtractIcon[Ex]() API
<firstname.lastname@example.org> wrote in message
> Is there any way to extract an icon from an application?
...extracting totals from within a spreadsheet
I need to know how to take different information from within a spreadsheet
--where two conditions/catogories must apply so that a third column where i
have inputed hours, will total for those conditions only... can anyone help?
Please spell out what you want we are not mind readers
Bernard V Liengme
remove caps from email
"Jovetta" <Jovetta@discussions.microsoft.com> wrote in message
>I need to know how to take different information from within a spreadsheet
> --where two condi...Notification Icon #2
I have worked out that once a mail item is processed by a rule, Outlook
ignores all your notification settings. So for every rule I've got I have
had to explicitly tell Outlook to play a sound and show a Desktop Alert -
but I can't find any way of showing the mail icon in the system tray.
Is there anyway of getting a mail item that is processed by a rule to show
the new mail icon in the system tray?
...Excel: extract and sum numerals from mixed text/numeral cell range
I have a large (30x20) grid of cells with data, and I want to extract
and then sum up certain numerals from this entire range. The catch is
that the data is mixed numerals and text, as you'll see below.
Here's an abbreviated 3x3 example, with a value in each of the nine
V7.1 T H
P1 A T
B V3 P4.5
If I just wanted to sum up the instances of "T" appearing, I could use
COUNTIF() for the entire range to come up with answer ("T" appears 2
times). Easy enough.
But, what I'm trying to accomplish is to sum up the numerals associated
w...Extract emails from cells with text
I have a row in column A which includes an email address in the text that I'd
like to extract to column B. Is there a formula I can use to accomplish
extracting the email address only to column B?
Here's an example of different cells in column A:
Please email email@example.com to contact us......
Schedule an appointment for assistance, or email firstname.lastname@example.org with your
All on one line:
(" ",A1&" ",FIND("@",A1))-1)," ",
REPT(" ",...extracting individual numbers from "ranges"
I'm trying to get EXCEL to extract stock prices quoted in individual cells
as 52-week ranges --e.g. 11.76-19.90-- and do the following calculation:
(higher price - lower price)/lower price
Obviously, this a problem because each cell appears to handle the range as
text or something. Is there are way to get EXCEL to handle the "text" (or
however else it is interpreting what's in the cell) as individual numbers?
Great thanks for any help.
do your entries always look like
if yes you may try the following formula in the adjacent row (lets
assum...Query and Extract
This seems basic, but I just cannot get it. While using SQL Server 2005 and
the Microsoft SQL Server Management Studio, I created a database called
AssetQuote. Inside I have on table called assetquotes.
From there, I have three columns, (date, quote, author)
The column type for date is datetime and the other two are just text.
My Query is something this:
INSERT INTO AssetQuote (date, quote, author)
VALUES('052010','No act of kindness, no matter how small, is ever wasted.',
When I run the query I get this result:
Msg 208, ...256 color BITMAP to ICON
Hi, anyone can help me to convert 256 colors bitmap to 256 colors icon?
Sam Shi wrote:
> *Hi, anyone can help me to convert 256 colors bitmap to 256 colors
> Thanks! *
Did you find a solution to this?
Posted via http://www.codecomments.com
...extracting hours from a sum of time
I have a cell which sum a bunch of cells containing an elapsed time.
The sum totals to more than 24 hours.
I have to a cell with a cost per hour and I need to caclculate the
The problem is that the hour function returns values in the range of
0-24. My current sum is 25:30 and the hour function return 1 and not
Any ideas how to bypass it?
It "returns" the correct number, but doesn't show. Format Custom as [h]:mm and it will.
To convert to a number that you can multiply with an hourly rate, first multiply by 24; times in Excel are fractions of a day and
a day is s...Outloot printer icon showing wrong printer
We have a strange problem with Outlook 2000.
When hovering over the print icon, the tool tip shows a different printer
than the one that the print jobs come out of.
Anyone else seen this before?
...Can I extract unique cell values from every nth column?
I have a range that covers B5:XA160. For each row, data is entered in
11-cell groups: date, some numbers, description (a text value), more
numbers, and more numbers. At first it was enough to merely count how
many times certain descriptions appeared, because those were the only
ones we would see - or so the story went. Now, I need to extract the
unique descriptions AND provide a count!
Actually, I'm cheating a bit. I'm using SUMPRODUCT to return the
number of times the expected descriptions appear, and by subtracting
these from the total number of text values I get a count of &quo...Extract Text
I have this text in a field:
and I need to separate only the data after the six first data:
How can I do it?
Thanks a lot!!!
Take a look at Access HELP for the Mid() function. Open a query in design
view and add a new field something like:
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
<email@example.com> wrote in message
Do anyone know of a tool or script which I can use to extract users email
address from a windows 2000 domain we are using exchange 2000
Here's a script to extract ALL email addresses form a domain:
Do you need something for a single user?
"wmb" <firstname.lastname@example.org> wrote in message
> Do anyone know of a tool or script which I ca...Icon Definitions
I cannot seem to find the definitions of the icons used on
the Review recent bills and deposits page. Can someone
direct me to where they are defined? Thanks.
Well, you might want to see http://www.bollar.org/msmoney/#S8 and the page
it frequently refers to,
"Tom S" <email@example.com> wrote in message
> I cannot seem to find the definitions of the icons used on
> the Review recent bills and deposits page. Can someone
> direct me to where they are defined? T...Go to Desktop Icon
When I used Windows XP, I had an icon on my launch toolbar that
brought me directly to the desk top. Is there something that does the
same in Windows 7? It saves me time from having to minimize all open
applications in order to get to the desk top. I appreciate your help
"SanCarlosCyclist" <firstname.lastname@example.org> wrote in message
> When I used Windows XP, I had an icon on my launch toolbar that
> brought me directly to the desk top. Is there something that does the
> same in Wi...to form tray icon
I wrote a VC pragram.I wanted to form a tray icon when the program is
runnining....Is there any MFC function for doing this??????
Take a look on this article
> I wrote a VC pragram.I wanted to form a tray icon when the program is
> runnining....Is there any MFC function for doing this??????
On 10 Jan 2007 23:16:01 -0800, "Joseph" <email@example.com>
>I wrote a VC pragram.I wanted to form a tray icon when the program is
>runnining....Is there any MFC function for doing this??????
You m...Extracting data to make mailing list
My neighbour has a .PUBS name and address doc. The doc is 10 pages long. Each
page of the document is a table with 10 rows and 3 columns.
Each cell is name on top the line followed by 2 or 3 lines of address. She
then just cuts the full sheet Avery into mailing labels.
This has become too difficult to manage, sort, filter, etc.
Anyone have a suggestion how to extract this data so I can make a Publisher
try bringing it into Excel...you'll some "massaging" to do.
Microsoft MVP Expression
"Ross"...New Mail icon gone
Hi, wheneven new email arrives, I use to have a small
yellow envelope icon at the bottom of my Task Bar.
Recently, I am not having it. How do I reset this
function. Note that I am NOT referring to Display
notification message when new mail arrives. Thanks in
advance! Please reply to firstname.lastname@example.org
...Disabling form search and filter icon in navigation buttons bar?
I need to upgrade an Access 2000 .mdb database to run with an Access 2007
installation. This gives me access to a lot of new features. But some I would
like to be without.
In quite a few forms I display query results in one or more subforms
presented in datasheet view. I have enabled the navigation buttons. This is
mainly done because it gives an easy access to the total number of records in
the query. And it also give easy access to last and first record
In Access 2007 the bar in the bottom of a form in datasheet view now not
only displays the navigation buttons with the record count...MID formula not extracting what I want.
I'm trying to extract the date from a cell using the MID formula and all
I'm getting is some weird number that does not seem to make sense.
I have tried formatting the target cell but still no change.
Any clues about it? How can I do this?
1/13/2006 12:16:29 AM
wayliff's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29860
View this thread: http://www.excelforum.com/showthread.php?threadid=501062
That's because Excel stores dates as...Extract
these r the data given in Sheet 1 and i want the highest number in the month
of august in sheet 2
this is an array formula, so commit with Ctrl-Shift-Enter not just Enter
"sajith" <email@example.com> wrote in message
> Month Number
> AUG 1
> AUG 2
> AUG 3
> AUG 4
> AUG 5
> AUG 6
> S...Extract text content from MS office files
I want to extract text content MS-OFFICE documents like word, ppt, xls...
Plz gimme some tips.
...Extracting First Letter
Can anyone help, i'm trying to extract the first letter of each word within
any given phrase. I'm using excel 2003
Perhaps this might suffice
With text running in A1 down
In B1: =LEFT(TRIM(A1),1)
> Can anyone help, i'm trying to extract the first letter of each word within
> any given phrase. I'm using excel 2003
Sorry Max, let me be more specific, eg. Lets say I have the phrase "The quick
brown fox jumped over the moon&qu...String extraction
How can I extract the first line form a multi-line string?
> How can I extract the first line form a multi-line string?
Use Left(yourString, InStr(yourString, Chr(13) & Chr(10))) to get the
--> stefan <--
"Stefan Hoffmann" <firstname.lastname@example.org> wrote in message
> hi John,
> John wrote:
>> How can I extract the first line form a multi-line string?
> Use Left(yourString, InStr(yourString, Chr(13) & Chr(10))) to get the ...envelope icon in tray
For some unknown reason, the envelope in the tray is no
longer appearing. I have checked the advanced email
options and it is still toggled. I have untoggled it and
restarted Outlook (2002 by the way on XP home) and that
did not fix it either. Any suggestions?