Opening File using default viewer
Hello, how would I go about opening a file using the default viewer, so
for example, if the file is a txt file, then notepad would open it. Or
if it is an XML file, then maybe firefox woulld open it.
I was hoping to use a CButton and if the user clicks on it, then it
would grab the path specified and open the file with the corresponding
> Hello, how would I go about opening a file using the default viewer, so
> for example, if the file is a txt file, then notepad would open it. Or
> if it is an XML file, then maybe firefox woulld open it.
> ...Use of Pop3 accounts for external email
We've been using a pop3/smtp account to recieve our external email. I've
heard that using those is a bad idea for a buisness.
I don't understand it that much and wondering what are the issues with pop3
and what is an alternative to recieve external mail if not using a pop3
We have Exchange 2003.
The issue is the company can't archive all user's mail. You know, company's
email is representing the company, so the company should keep it as archives.
With POP3 email will be moved from server to the client. Instead, you can
use IMAP, Exchange Server, or ...Trouble with hyhens within text when using LOOKUP
I have two columns, each containing a list of part numbers. Some of the part
numbers contain hyphens.
I am using LOOKUP and/or VLOOKUP to determine if the value in one column
exists in the other. This works great on non-hyphenated part numbers.
However, it will not find or return the hyphenated part numbers from the
specified arrays. As a test, I did a quick if statement to compare the
instances of identical hyphenated values that exist in both columns. Those
statements did not have a problem with the hyphens. Can anyone offer any
help? If hyphens cannot be used in conjunction with the ...Using formulas to filter
Is there a way to filter a list by formulas the same way
the Data->Filter option works? I'd like to take the matrix:
Col A Col B Col C Col D Col E
===== ===== ===== ===== =====
Smith 30 $104.2 Yes 52
Jones 31 $155.3 No 51
Jones 31 $422.2 Yes 49
Freer 31 $424.3 Yes 42
Waylan 30 $322.5 No 50
Smith 31 $288.3 Yes 49
And, using a formula, filter on Col B = 31 to produce:
Col AA Col AB ...RE: Use that security update
Content-Type: multipart/related; boundary="yzkfzsfqtv";
Content-Type: multipart/alternative; boundary="qeviqcxczwaquy"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to hel...Name Range with using Data Form
I first created a variable with A1:D1, four columns with named variable
Data. How to expand this Data range to A1:D2 after using the DataForm to add
one row data in the worksheet?? The same, the Data range should be A1:D3
when adding one more data row...
use the following formula in the name definition dialog
>I first created a variable with A1:D1, four columns with
>Data. How to expand this Data range to A1:D2 after using
the DataForm to add
>one row data in the worksheet?? The...Has anyone used the Remove MO Utility?
I have a closed Quick MO that did not process properly somehow. The MO is
flagged as closed, but sime items were not issued and are stuck in WIP.
I ran the Tools > Utilities > Manufacturing > Remove MO process in a test
database. It removed the MO and the items re no longer hung up in WIP. Has
anyone else ever executed this process? Are there any gotcha's I need to be
I too have used this in a development/test environment and have not
encountered any problems.
mlopat@lu...How to use CxImage?
I want to display a jpeg picture by using CxImage but I am new to visual c++
so I couldn't understand how to use this class in my project.Is there someone
who have used this class and can you help me about using it?
On Jul 3, 7:12 am, ibrahim <ibra...@discussions.microsoft.com> wrote:
> I want to display a jpeg picture by using CxImage but I am new to visual c++
> so I couldn't understand how to use this class in my project.Is there someone
> who have used this class and can you help me about using it?
Its all here: http://www.codeproj...How to use MSExcel to plot Column A against Col B?
I want to plot col A (x axis) against col B ( y axis). I cant seem to
do it. Can anyone here please give me step by step primer. Thanks in
All I get is the graph of (1,2,............n) (x axis) against the n
values of either col A or B.
i.e 2 graphs instead of one.
(In the old Lotus this was so simple: select the column for the X axis
and then select the col for the Y and press enter, and you'd get the
Why is it so diff in Excel?
Select the entire range you want to graph such as a2:b44>insert>chart>>>>
dguillett1@au...buy from this E-hermesol company is fast only used my 5days
I would like to introduce you a very good company which I knew. Their
company homepage is www.ehermesol.com. They can offer you all kinds of
electronical products which you need, such as motorcycles, laptops,
mobile phones, digial cameras, TV LCD ,x box, ps3, gps, MP3/4, etc.
Please take some time to have a look at it, there must be something
you 'd like to purchase.
Their contact email: email@example.com
Hope you have a good mood in shopping from their company!
...Using Outlook to access and compile information in calendar
I want to create an application that will compile schedule information from
Excel worksheets or an Access database and display them in a calendar type
format. I know this type of application can be built using PivotTables in
Excel, or forms in Access, but I was wondering if I could use the calendar
in Outlook to display the information rather than creating PivotTables or
custom forms which would wind up looking something like a calendar anyway.
Before I start the job I'd like to know if I can work Outlook into the
equation or if I really have to build it from scratch.
...Using cell text in a formula
I am trying to use derived cell references in a VLOOKUP formula to matc
data in several tables. For example, A1 contains the cell reference fo
the top left of my array (A3) whilst cell A2 contains the cel
reference for the bottom right of my array (D14). The array I'
checking against starts in column E3.
However, when I use the formula =VLOOKUP(E3,A1:A2,4,FALSE) I get a #N/
error. I need to use the cell references in each VLOOKUP as the arra
sizes may vary in each case. (PS, I've used =INDIRECT(ADDRESS(A1,A2)
to derive the cell references.
Message posted from http://www.Excel...Using two conditions in a formula
How do I write the following formula:
I am in cell I6
If g6 AND h6 is blank, then blank, else I5 minus g6 plus h
Richard Pitt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1533
View this thread: http://www.excelforum.com/showthread.php?threadid=27042
In cell I6, enter the formula:
Though you don't check for case when G6 is blank and H6 isn't, etc.
MS Excel MVP
"Richard ...Data validation #63
I have a list for data validation. It is a long list and when I click on the
cell the first thing I see is the options from the end of the list. Can I
change a setting (no code) so that the list of options first shown when you
click in the cell is the first item on the list
There is probably a blank cell at the bottom of your list source. When
the dropdown list opens, it matches the cell value to an item in the
list, if one exists.
Delete the blanks from the source, and the problem should disappear. If
you're leaving blanks so the list can grow, you can use a dyna...Using CMFCToolBar and CMFCMenuBar?
After initial frustrations indicated by recent messages, I am now getting on
with these classes relatively cordially.
The user of my program can add or remove buttons to/from the CMFCToolBar(s),
and menu items to/from the CMFCMenuBar - all beautifully customisable.
The program knows about the available commands and they can be added to any
toolbar or menu. And new custom tool bars can be added by the user. It's
all fiendishly clever.
However: my questions (today) are as follows:
1. The MFC Customise dialogue, from which one can drag commands to toolbars
and menus,...How did you add text into publisher, without using boxes?
how do you add text to publisher without using text boxes
I suppose you could create your text as an image and insert the image into
your publisher file.
"Calvin Scott" <Calvin Scott@discussions.microsoft.com> wrote in message
> how do you add text to publisher without using text boxes
Calvin Scott <Calvin Scott@discussions.microsoft.com> was very recently
heard to utter:
> how do you add text to publisher without using text boxes
Text in Publisher has to e...I want to design both side of a post card using publisher 03
I have go side one completed. How do I do the other side???
"bettboop" <firstname.lastname@example.org> wrote in message
>I have go side one completed. How do I do the other side???
...Bug in Office Outlook 2003
Does anyone know whether there is a Microsoft Article dealing with the
removal of a bug, which produces LDAP dialog box on opening Outlook 2003,
that cannot be removed by any other recommended means?
Why do you classify this as a bug?
If you don't use the LDAP service remove it from your profile.
Control Panel-> Mail-> button E-mail Accounts-> View or change existing
Roady [MVP] www.sparnaaij.net
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Setting Permissions on a ...Using Outlook over a Network
Hi, I would like to know what software I need to allow
multiple users to access one MS Outlook Calendar. The
computers currently have Outlook 2000 and I would like the
users to be able to edit one central calendar
simultaneously, directly in the calendar (ie. not
requiring users to send emails etc.) What sofware beyond
Outlook 2000 do I need and is there any info on how this
is done? Thanks Adrian
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick.com?
-Plea...how to use 2007 styles in Word 2003
we have Word 2003 but we really like the Styles that come with Word 2007. Is
it possible to export these Styles and use it in Word 2003? And if yes, how
can i do that.
In Word 2007, click the Home tab of the ribbon. In the Styles group, click
Change Styles | Style Set | Word 2003. To make this choice the default,
click Change Styles again, and then click Set as Default. If/when you are
prompted to save the changes to your template, choose to do so.
Microsoft Word MVP
"skoub" <email@example.com> wrote in messa...Validating Tender Entries
I need to be able to validate entries on the Tender screen as they are being
input. I see (in the customization guide) that there are hooks available at
the begining and at the end of the tender process... does anyone know how to
tap into events (i.e. entry of a gift card, check, coupon, etc.) on the
> I need to be able to validate entries on the Tender screen as they are being
> input. I see (in the customization guide) that there are hooks available at
> the begining and at the end of the tender process... does anyone know how to
> t...How is the ease of use for salespeople compared to other tools?
With the goal of keeping it simple, it seems like there are a lot of steps,
drop downs, etc. that slow up the inputting of information.
Is there customization that is needed to speed this up would you think?
is this a crm 1.2 or 3.0 question. Microsoft made a big effort to reduce the
time to navigate around and input data in crm 3.0.
you always have the option of building custom forms to allow you to enter
data quickly then have these populate crm
Microsoft CRM MVP
http://www.microsoft.com/businesssolutions/crm/community/microsoft_crm_co...how can i use countif function inside a filtered range
How can I use countif function inside a filtered range
Not much detail here, so this is the general idea:
If this helps, please click the Yes button
> How can I use countif function inside a filtered range
Shane Devenshire wrote on 02/24/2009 02:05 ET :
> Not much detail here, so this is the general idea:
> ...How do I use the "Correlation" dialog box with multiple ranges?
I'm using data in an Excel 2003 in a workbook, trying to see if there is any
correlation between specific offices in which people work and the length of
time they have been employed, their age the amount of sickleave taken and/or
the amount of sickleave balance they have. I'm attempting to use Data
Analysis and the Correlation dialog box. Although the dialog description
tells me that I can use multiple comparison ranges, I don't see how to do it.
Thanks for any help.
Arrange your data in list (database) format, i.e., names in the top row
(Time Employed, Age, ...)...bug in Excel 2003; need to install Excel 2002
I have Office 2003, and I found a bug in Excel 2003. The linear regression
results using Excel 2003 differs with that of Excel 2002 for some cases.
How do I can uninstall Excel 2003 (and install Excel 2002) without affecting
the other Office apps (like Word 2003 and Powerpt2003)?
Excel 2003 has solved some bugs/errors with statsitical functions. So I
would guess the 'new' result are more correct than the old ones
"Speqter" <Speqter@discussions.microsoft.com> schrieb im Newsbeitrag