Is there any way to extract an icon from an application?
Take a look at the ExtractIcon[Ex]() API
<email@example.com> 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...[SOFT TOOL EXE DLL ISO C PHP NIX WIN CISCO] search & download === www.GEGEREKA.com
Project of the year: Incredible unique search machine like nothing on earth.
any kind of useful data: WIN,NIX,CISCO,MAC,DLL,PHP,EXE,ISO, ...and much more
Millions files for everyone. Also music, movies and other media.
http://www.GEGEREKA.com : THE LORD OF DOWNLOADS.
Win XP HE, XL 2002 SP3
I am doing a rush presentation and am stuck...!
Under Tools|Options| Chart tab, the otion to "Plot empty cells as: Not
plotted" is grayed out.
Yet, that is precisely what I need to do.
How can I fix that?
I have other charts where the optin is available.
What am I doing wrong?
I found out the following: I had an "area chart" which (by definition I
guess) will build the area from "0". Changing it to a line chart, did the
> Win XP HE, XL 2002 SP3
> I am doing a rush presentation and am stuck...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 firstname.lastname@example.org to contact us......
Schedule an appointment for assistance, or email email@example.com with your
All on one line:
(" ",A1&" ",FIND("@",A1))-1)," ",
REPT(" ",...Inbox Repair Tool #11
I have had to recently rebuild my pc running Win ME and Outlook 2000. Some
folders that I saved as .pst have corrupted when I try to load them back
into personal folders, and Outlook suggests closing all mail programmes and
then using the Inbox Repair Tool.
I can't find it to use it to repair the folders
Inbox Repair Tool = scanpst.exe. Location tends to vary based on language,
but a search for the file in Windows Explorer should flush it out.
"Ron" <firstname.lastname@example.org> wrote in message
> I have had to recently rebu...Synch Tool
can anybody tell me if there is a tool for exchange server 2000 which can
automaticly translate the comming email attachments from works format to
office format and also in the other way. Thanks
None that I have ever heard of. Exchange doesn't do anything with
attachments. 3rd party antivirus and antispam can delete and replace
attachments, but not convert them. Can the works users save them as a
different format? I haven't used Works before (I've always used full-blown
Office). You might try asking in the Works newsgroups (m.p.works.docs and
m.p.works.win) and as...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, ...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...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...Support Debugging Tool for Microsoft Dynamics GP Released
The Support Debugging Tool for Microsoft Dynamics GP has been released to
Please see my blog post below for more information and download links:
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
Any views cont...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"...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...Shortcut Tools - Options
I was wondering if somebody would know the shortcut key to toggle between
"Tools - Options - Calculation - Automatic" and "Tools - Options -
Calculation - Manual". Do I have to assign one or is there already one? If
the former, how should I go about it? I know that I could push a Shift+F9 to
recalculate but I would also like to do the toggling.
Thankyou for any response.
You could set up a macro that toggles between calculation modes.
Dim msg As String
If .Calculation = xlManual Then...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...MS Money's Budget tools?
Have there been any upgrades to MS Money's budget tools from 2003 to 2004? I was very un impressed with how limited 2003 was as far as setting up a budget. I'm considering upgrading to 2004, but only if the budget tools are better.
If that's your criteria, don't upgrade. See
http://www.microsoft.com/money/info/upgrading.asp to identify budgeting
changes in the last several versions.
"Mike" <firstname.lastname@example.org> wrote in message
> Have there been any upgrades to MS Mon...How do I use the transparency tool in Publisher?
Though I can see the transparency in my working document (I am trying to
place a graphic behind a 45% transparent gradient fill to show through only
part of the fill), the transparency doesn't seem to be visible when in print
preview or with printing. Please help!
Transparency is difficult in Publisher, copy the transparent object, "paste special"
as an enhanced metafile.
Mary Sauer MSFT MVP
"Lil Lisa" <Lil Lisa@discussions.microsoft.com> wrote in message
news:9A342A80-D259...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...a visual tool showing C++ class structure ..
Does VC 2005 provide a tool to visually show the C++ class structure
(inheritence, aggration, etc) diagram in a project? Thanks.
Not that I've found. Check out doxygen:
"JD" <email@example.com> wrote in message
> Does VC 2005 provide a tool to visually show the C++ class structure
> (inheritence, aggration, etc) diagram in a project? Thanks.
But I do remember to see a visual tool when attending a studio seminar long
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 ...