IF Statement #7
I'm trying to create an IF statement whereby if a certain stock in my portfolio goes up for that day's activity, it will display a green up arrow; if it goes down, a stick person dangling at the end of a rope. (Just kidding about that one). The GIF pictures I want to use will be in the same subdirectory as the Excel spreadsheet. I'm using Excel 2003.
Thanks in Advance!!
If you would care to use the WingDings font instead of a
GIF, try this:
=IF(K3>1," J",IF(H3>F3,"K","L "))
Then format the result as WingDings. You get either a
smile...SBS 2003 and Email Not Receiving
We have SBS 2003 Installed. We had a linkys router that we replaced with
a small business cisco gigabit router. After the router changed,
internet would work, we can send email to extrenal, send and receive
intenral emails but receiving external wouldnt work. We ran the
Email/Internet repair via SBS. Receiving external email worked. Few
hours later it stoped. We ran it again and it works. This keeps
going..it works for few hours and than stops.
Is there something that we missed or a setting that we need to setup on
the router so it keeps it up all the time.
mal...Office 2003 on WinXP is receiving an error...
This operating is not presently configured to run this application.' This
nmessage keeps popping up after I install WInXP Sp2. Right after I install
office 2003, and I try to open MS word 2003, the above message appears. Can
anyone point me in the right direction?
Insert office cd>repair
"RodneyJ" <u58446@uwe> wrote in message news:a43130535cd3e@uwe...
> This operating is not presently configured to run this application.' This
> nmessage keeps popping up after I install WInXP Sp2. Right after I
> office 2003, and I t...Running Money 2003 in Vista
I run this version perfectly satisfactorily in my Vista Ultimate
desktop.with my normal log on. No fiddling was required to get it to start.
It worked perfectly out of the box, just as in XP
Referring to emails on earlier versions in the Newsgroup, my data is in a
Documents folder on the D Drive well away from Vista, though it is secured.
In this machine SSL2 is not enabled
I have a newish laptop running Windows Home Premium with a similar
configuration for all my data on the D drive. I recently tried to open
Money for the first time since installation using a copy of the Money fil...Accessing Windows Office Templates
There are some very nice templates at the Windows Office Template
Gallery. I would like to download (mostly Word, but a few Excel) some
of these templates, but the format comes out with a ".cab" extension
that Office v.X doesn't understand.
Is there any way to get these templates? Unfortunately, they make the
Mac template archive look very weak.
Microsoft has a Mac template download page:
There's a link to the on-line gallery on that page. It looks like a newly
re-designed gallery to m...Monitor Server in 2003?
After installing Exchange 2003 SP1, I'm having some issues monitoring
exchange server via scripting.
1. I can no longer get any instances from
"Win32_PerfRawData_ESE_DatabaseInstances" via scripting.
2. The property "LogGenerationCheckPointDepth" does not even appear as a
property of "Win32_PerfRawData_ESE_DatabaseInstances". (I checked this with
WMI CIM studio)
I can still get the LogGenerationCheckPointDepth from performance monitor.
The following code verifies what I've seen in WMI CIM studio:
set RawProc = GetObject("winmgmts:\\r...Outlook 2003
Just bought new PC.
Everything is Microsoft.
XP Home - Microsoft Works (came installed) - User like to use MSN for
e-mail, Sent Microsoft $300.00 to activate Office that came installed on
Word will not allow MSN to be the e-mail client. System crashed and burned
after activation of Office. Outlook 2003 seems a little unstable.
Why would a new PC with Works, Office Express and Outlook 2003 be shipped?
All these programs do the same thing and they don't seem to talk with each
On top of this all she wants to do is use Word and send the document through
MSN nor...How can I get 32-bit Integers?
I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
is just 16 bits, i.e. its max value is 32,767. How can I configure it so as
to have 32-bit Integers, along with 64-bit Longs?
"Renny Bosch" <firstname.lastname@example.org> wrote in message
> I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
> is just 16 bits, i.e. its max value is 32,767. How can I configure it so
> as to have 32-bit Integers, along with 64-bit Longs?
An Access Integer is 16 bits. A Long Integer is...Can't create Organizational Forms Library in Exchange 2003 with SP
I cannot create an Organizational Form in EFORMS REGISTRY folder (from First
Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When
I right-click the EFORMS REGISTRY folder and select New, there is no
Organization Form. Instead, I only see Public Folder in the popup menu. Do
you have any idea why Organizational Form menu does not show?
My Exchange Server is Exchange 2003 with SP2. The login user is Administrator.
Could you please help me? Thank you very much.
Is that account member of "Enterprise Admins" group?
Yang Zhang wrote:
&...How do I get Powerpoint 2003 fade in 1 by 1 in 2007
I frequently used the 'fade in one by one' feature in Powerpoint 2003, which
allowed me to fade in individual bullet points by way of a click of a mouse.
Not only is this feature now not standard in 2007, but I can't work out how
to create it: anything that I find, tends, instead, to fade the bullet points
in on some kind of automatic time schedule, rather than - as I want - on a
mouse click. I want only to use text, no sounds, no pictures, and nothing
fancy. Currently, I am reduced to copying my material into an old Powerpoint
2003 presentation, but this is silly....Here is fix for Windows file problems
If you have installed a Windows update and started having problems opening,
closing, copying files, see:
A better solution is offered at
http://support.microsoft.com/kb/918165 "Problems in Windows
Explorer or the Windows shell after you install security update
Patricia Shannon wrote:
> If you have installed a Windows update and started having problems opening,
> closing, copying files, see:
> http://ww...Access 97/2000/2003 comparisons
I have a rather large application that uses an access 97 database (DAO). We
also have a version that works with access 2000, Oracle, msde, and SQLServer
(ADO). We would like to retire the DAO version of the product, but there are
places where the ADO version is much slower compared to where we run DAO
seeks (very noticeable when looping). So, I have a few questions.
1. Are there any tips/tricks to speed up ADO queries to compare with DAO
2. Would there be any benifit in using access 2003 over previous versions of
the software besides the added features (xml support, etc).
3...Access 97 can't resize database window
My database window with the listings of forms tables etc was adjusted to a
smaller width, but resizing it is completely disabled and renders Access
2007 utterly useless for me. Is there anyway to 'reset' the window?
...SBS 2003 moving of users files
I run SBS 2003 and due to the amount of data on the users drive it has
become chokers and have installed a new 1tb drive to keep up with demand
I need to move all the data to the new drive but unsure of the process.
Is there an easy way of doing this? As it needs to be done asap
JimmyJames's Profile: http://forums.techarena.in/members/255792.htm
View this thread: http://forums.techarena.in/small-business-server/1357051.htm
You c...Office installation and Windows 7
I got a new computer today with Windows7. It is a 64bit system where I had 32
before. I tried to install my Office Professional 2007 and it would not
install. I got a message that Microsoft would check the problem and get back
to me, then another message that the program was shutting down. I am in
school and really need my Office. Is there a way around this so that I can
get it installed?
Doesnt make any difference, 64 / 32 bit.
Does your new PC have a Trial Version of Office & Activation Assistant that
you failed to uninstall first, then rebooted?
"Linda...unable to read file #7
Does anyone know how to solve this error? This is the
second time I have had the same error on the same file.
Last time I was able to recover from a saved copy and
updated fine. This time whenI opened the copy and updated
it, then saved it, I got the same error when I tried to
open it again, Now I don't have a good copy. I have
downloaded all avaliable updates and tried
running "Excel.exe /regserver>ok" This did not help. I
also ran defran on the drive.
> Does anyone know how to solve this error? This is the
> second time I have had th...About Exit and close window.
I have a dialogue base application. There's an Exit button in it. Eachtime
when exit the program by clicking Exit button, fun() and OnOK() executed,
but if the window is close by clicking (x) on the upper-right coner, fun()
will not be executed. How to make this function--fun()--executed when click
(x) button on the upper-right coner?
Rather than calling your fun() from the Exit event handler, call it from the
dialog closing event handler, so that no matter how it is shut down, that
method is called, and so is fun().
hope that helps.
"sxy7711" <sxy771...how create Quota filter in WIndows 2003 R2 using Script
I need create quota filter in Server 2003 R2 using vbscript. quota
filter should be applied to directories and not by users.
I searched information about it on google without success.
thank's in advance
First you need open your FSRM (File Server Resource Manager), then you
create a quota template, you must specify if your quota is "software" (just
monitoring, but never deny the user) or "hardaware" (deny users when they
use 100% of the quota), you must specify if you want send e-mail to user
when this user use...Exchange 2003 IMAP and Postini
Hello all --
I have a problem and I was wondering if the smart ppl out there could come
up with a solution.
I've enabled Secure IMAP for our users with cell phones with pocket PC
installed on them... Basically, we are using Postini, and they want you to
ONLY accept connections from their servers, so as to not allow SPAMers to
directly connect to the exchange server and directory harvest attack.
However, when Idid that, my IMAP ppl can't SEND email anymore because they
aren't coming from the trusted IP range. Is there anyway around this?
Probably not, but I thought I'...Outlook 2003
In Outlook 2003,
#1 Is there a way to refresh the unread folder so that read
messages no longer apear? Right now I have to click closed the unread
folder and click it again
#2 Is there a way to create a toolbar button that goes directly to
...Limit on Exchange 2003 version included with SBS 2003
Can anyone tell me if the version of Exchange 2003
included with Small Business Server 2003 has the 16GB
limit that exists in the Exchange 2003 standard edition?
>Can anyone tell me if the version of Exchange 2003
>included with Small Business Server 2003 has the 16GB
>limit that exists in the Exchange 2003 standard edition?
...Outlook 2003 rules question again
I have a rule so that after the e-mail comes in, it searches for specific
words in the e-mail header. I set up this rule to search for sober.worm
since I'm receiving a copious amount of spam e-mails which include the
sober.worm attachment. I set the rule to delete the e-mails indefinately
but it does not delete it. It just sends the e-mails to the junk mail
folder. I would like to have it delete the e-mails forever. What can I do
to achieve this?
Nocturnal @ http://www.randomfix.com
Also, I did get it to work a few times but the rule stops working.
Another thing is if ...Creating Exchange 2003 organization
Is it possible to have two Exchange Organizations in the same domain? I need
to reproduce a problem and was hoping to install an Exchange server to an
existing domain however I need the organization to be different. Is this
possible? When I installed EX 2003 I wasn't prompted for information other
than location of files.
Thanks in advance
On Mon, 28 Feb 2005 08:09:03 -0800, "RP"
>Is it possible to have two Exchange Organizations in the same domain? I need
>to reproduce a problem and was hoping to install an Exchange server...IE 7 webpage view
How do I make IE7 keep the webpage I want displayed everytime I open it up,
without having to resize it everytime?
RED in NC
Try stretching the small window to full size. (Do not use Maximize)
Ensure that window is the last one closed and IE should remember the
size next time.
Alan Edwards, MS MVP Windows -Internet Explorer
On Thu, 14 Jan 2010 06:27:53 -0500, in
>How do I make IE7 keep the webpage I want displayed everytime I open it up,
&g...Why will my publisher 2003 not print graphics?
I have recently loaded windows 7, and since then I cannot print any graphics
from any publisher document, text and infills print but lines do not! I have
looked at the advance printer settings and the "Do not print any graphics"
box is not ticked.
I have also tried reloading publisher but this did nothing. Any ideas anyone?
Might take a look at the web site of your printer model to see if there are
Windows 7 drivers. Will the document print okay if you convert it to PDF?
There are free converters around. www.primopdf.com is free.
It is always wise to completely remove ...