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...Object Linking & embedding error
An .xls attachment give the 'cannot use object linking &
The file fails to open and appears on screen for just a
Any ideas! where the problem is!
I' ve run into the same error, and am to the point that its time to
throw this piece out the window. Has a solution for this problem been
OS. win 2000 pro.
PG. Office 2000
error. cannot open object linking and enbedding.
I had the same error on another PC and was able to re-install the pg.
and it stopped. Go figure....
~~ Message posted...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(" ",...Publisher 2002 Photo Crop Problem
I apologize if I am posting this problem twice. However, I couldn't tell if
the first time posted or not.
The problem is: When I crop a photo I've placed in a Publisher 2002
document, it looks fine on the screen. However, when I print it, the portion
of the photo that is cropped is exactly the reverse of what it looked like on
the screen. For example, if I crop the top of the photo off, it prints with
the bottom of the photo cropped off. How do I fix this so that what shows as
cropped on the screen is what prints? Thank you so much for any help!
Is this all photos? Might ...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, ...embedded clipart not showing up in recieved email
Has anyone come acrossed the problem where embedded
clipart will not display in recieved email. I have messed
with changing between html and rich text.
Thanks in advance for any help you can give.
Oui save et toi
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"abdellah" <firstname.lastname@example.org> wrote in message
> salut çava
...Inserted photo in Pub blurred; in print preview it's normal-why?
Earlier today I inserted several photos from MS on-line clip art into my
company newsletter template and they looked great. However, when I viewed
them later, they were very blurred. BUTin the print preview mode, they are
fine. Does anyone have any thoughts on what is causing this and how I can
fix the problem?
Kathryn@Biffen <Kathryn@Biffen@discussions.microsoft.com> was very
recently heard to utter:
> Earlier today I inserted several photos from MS on-line clip art into
> my company newsletter template and they looked great. However, when
> I viewed them later, they w...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
news:11893397...Building an Embedded Device/System? Tell VDC about your experience for a chance to WIN!
VDC is conducting its annual survey of mobile and embedded engineers
so if you are involved in the engineering of mobile or embedded
systems/software, this is your chance to influence key solution
The research covers embedded software, hardware, tools, and
development practices. Your thoughts will improve our insights into
the engineering community and help to influence next generation
In addition, VDC will provide all respondents who complete the
* Instant access to a summary of VDC's 2009 survey findings;
* Entry into a prize drawing for one...Extraction Tool
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...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...WLM photo email
There appears to be two ways of creating an email with photos attached.
Clicking the arrow next to New and selecting photo email and opening an
normal email and using what appears to be the same feature ie. layout frames
Is there some subtle difference?
There are actually 3 different ways on including images with messages.
The two you mention are essentially the same (see #3 below).
1) You can actually Attach the image. This can be done with plain text
or HTML format messages. With this there are several ways to actually
get the image attached. How you do that do...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
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...Extracting folder data / Outlook won't open
I can't open Outlook, because it doesn't recognize Outlook Express is
installed (I have the often reported, but apparently rarely solved,
Is there a way to pull the mountains of data (calendar, tasks,
contacts and saved messages) out of my Outlook data file from another
PIM program? I'm willing to go with any other program to get away from
buggy Outlook, and figure one of the third-party sync programs will
handle the issue of how to sync with my Pocket PC.
firstname.lastname@example.org, you wrote on 23 Mar 2007 14:57:55 -0700:
> I can't open Outlook, beca...Image for CEVM (Win Embedded Compact 7) does not include .NET CF
I am working on a .NET CF application and want to test it on a Windows
Embedded Compact 7 system. So I installed the Public CTP and created an
image for the virtual PC. This image is correctly loaded by the virtual PC,
but when I start my application an error occurs, because the .NET CF is not
found. I checked the catalog in my project, it says that CF should be
Am I missing something?
It's hard to say from where we are sitting. Did you configure the OS, build,
then add the .NET CF, then build again? Or did the .NET CF go into the OS
before the first bui...preview only or embedded fonts driving me nuts editing & tring to save
I created this ms publisher thing in ms pub 2000. Now every time I try
and edit it and save it gives me thing "I can't because fonts are preiw
only / embeded" error.
1st I used MS arial. Then I changed it all to arial black, then arial
and it just seems no matter what I do I get the same problem.
Anyone have any ideas? Need to save the things I've added.
There must be something about the way you originally saved the file.
MVP Microsoft [Publisher]
<email@example.com> wrote in message