The use of the CHOOSE function and how to use it.
The use of the CHOOSE function and how to use it.
what is your exact issue - except looking at the example in Excel's
"Darren" <Darren@discussions.microsoft.com> schrieb im Newsbeitrag
> The use of the CHOOSE function and how to use it.
...Using CDOEXM to move mailboxes in an Exchange 2003
I posted this in the scripting newsgroup, but I was wondering if anyone can
point me in the right direction.
Is there a limit when you use CDO to move mailbox in an exchange 2003
environment? It seems like on the seventh mailbox move the script fails.
We have a couple hundred of mailboxes that we need to move.
we are using code some what like this
...Using Concatenate function to generate text in Text Box
I would like to have a text box on my chart, whose text is generated by
concatenating the values from two different cells (B4 and B6) on a specific
worksheet in my Excel file. I was able to use a reference to cell B4 to
generate the text for my text box using the following formula:
However, when I try to enter either of the following formulas for the text
='SSTyp-AllD'!$H$4 & 'SSTyp-AllD'!$H$6
I get the error message "The text you entered is not a valid refe...Protect Distribution List being used
Is it possible to protect DL being used by other except by
I have a DL to all users, and last days I have got a problem, that
this list was used by spammer.
What version of Exchange are you using?
"Matthias Schneider" <firstname.lastname@example.org> wrote in message
> Is it possible to protect DL being used by other except by
> I have a DL to all users, and last days I have got a problem, that
> this list was used by spammer.
> Greet...How do I use MSPowerPoint template background with MSPublisher bus
I downloaded an MS Powerpoint template with a background I would like to use
with MS Publisher to create business cards. However, when I try to copy it
to the MS Publisher business card template it is oversized. If I try to
re-size it to fit the business card template the image is elongated. Any
I am using Microsoft Office XP.
If the proportions of the card is not the same (or all but the same) as the
PPT image, you have two choices. Either distort the image or crop it.
MVP Microsoft [Publisher]
"JBrit" <JBrit@discussio...Use of a Chevron in a toolband
I've been trying to use a chevron is a toolband for IE. I've managed
to get the chevron up... But I'm facing a few problems.
1. When the browser is smaller than the specified size... The chevron
is shown. When I maximize it, the buttons which were shown in the
chevron aren't shown on the band. If I start the browser as a
maximized window, the buttons are shown properly in the chevron when I
reduce the size & the buttons are again shown properly when the size
is maximized. Basically, if the chevron is shown when the browser
comes up, the buttons aren't shown whe...How to use
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
"Iris M. Ballard" <email@example.com> wrote in message
...How can I put two variables with different scales on the same char
Plot both series together in the chart, double click on one series, and on
the Axis tab, choose Secondary.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
"Candace" <Candace@discussions.microsoft.com> wrote in message
...How can I get a columnar pad look using Excel?
How can I get a columnar pad look using Excel?
Define "columnar pad".
What is your view of it?
Gord Dibben Excel MVP
On Tue, 28 Sep 2004 13:41:17 -0700, "Valerie"
>How can I get a columnar pad look using Excel?
...How to use scalar functions?
I have this scalar function:
create function [Headlines].[HeadlineCount]()
declare @Rows as int
select @Rows = count(*) from [Headlines].[Headlines]
Wierd question: How do you use it now?
"Andy B." <firstname.lastname@example.org> wrote in message
>I have this scalar function:
> create function [Headlines].[HeadlineCount]()
> returns int
> declare @Rows as int
> select @Rows = count(*) from [Headlines].[Headlines]
> return @Rows
&g...Increased CPU use with 916803 Exchange Patch
Is anyone else seeing about a huge increase in CPU use with the 916803
patch? I have a two-node cluster that historically ran at about 21% CPU use.
On one side of the cluster that has gone 79% and the other side about 65%.
The Store.exe application is the culprit (at least the critter that is using
the CPU). Before I start panicking, I'm curious if anyone else has noticed
These boxes are fully patched Windows 2003 SP1 Enterprise servers, running
Exchange 2003 Enterprise SP2. The front end servers do not elicit this same
issue, but they have no real store (that is n...What CDO is in use
When I have both Outlook and ESM from the Exchange 2000 CD installed on a
PC. How do I figure out what
cdo.dll is in use?
If you are asking because of this month's security bulleting on
Collaboration Data Objects, you are actually after CDOEX.DLL and CDOSYS.DLL.
Both of these buggers deal with handling event sinks in the SMTP service.
Do not confuse this with CDO.DLL that handles manipulating items in
If you are asking because you are writing code that uses CDO.DLL and are
curious to know when the solution runs on a desktop that only has Outlook ...Using the Microsoft Outlook Personal Folders Backup tool
Using the Microsoft Outlook Personal Folders Backup tool
how can i specify just to backup or restore my contacts
You can't. It backs up the PST file in its entirety, with Outlook closed. If
you want to manually back up your contacts folder, you can use file |
import/export to export just that folder to a separate PST file.
> Using the Microsoft Outlook Personal Folders Backup tool
> how can i specify just to backup or restore my contacts
JOE, I READ YOUR QUESTION ABOUT BACKING UP PERSONAL FILES AND WONDERED IF YOU WERE USING 2003 OR 2002 AND ...what formula could I use?
If I have a data from a1:g8 and I want to be able to copy a row of dat
to another location, if the row row contains data that meets a certia
criteria, what is the best formula to use? Is this possible. Thanks:
petevang's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2503
View this thread: http://www.excelforum.com/showthread.php?threadid=49774
I don't think a formula is what you are looking for, you could howeve
use the advanced filter within Excel. Try the Data/Filter/Ad...Using 1 Stencil in a network
How do I take a pre-made stencil and put it on the network where many people
can open it at once? I think I need the file set in some kind of locked
mode so it can be opened, but not edited by others to allow this. Thank you
very much for any help in what is probably an obvious fix. For others
To make a Stencil ReadOnly, use SaveAs and pull down the arrow on the Save
button to reveal the ReadOnly option.
You can include a stencil in the Visio environment with:
Tools / Options / Advanced / File Paths / Stencils
but ... network paths can be slow
However, you could bui...using tab key in a form created document in Word 2004
Another question, I have created a form with a template in Word. The
text form fields work fine, but when I hit the tab key to go to the
next text form field..the typing starts just next to the first text
form field and doesn't jump to the second form field. I can place the
cursor in the 2nd text form field and type but cannot use the tab to
jump to the next available text form field.
I need help....
The following statement is being used in a do loop.
ActiveCell.FormulaR1C1 = "=IF(" & TagNmeMe & "!R[" & Cnt1 &
"]C[-1]="""",""""," & TagNmeMe & "!R[" & Cnt1 & "]C[-1])"
What I need it to do is this:
if(sheet1!A5="","",sheet1!a5) then 9 rows down paste this:
Problem is when recording a macro the cnt1 changes from nothing to 9 then to
18 but the formula does not mimic what...Mail sent using Outlook 2003 not received???
Have recently using Outlook 2003. I have esperienced a problem - some of my
mail that I have sent (and is in sent folder) has not been received by
person I sent it to. Is there a problem here? What can I do to fix?
"M!" <email@example.com> wrote in message
> Have recently using Outlook 2003. I have esperienced a problem -
> some of my mail that I have sent (and is in sent folder) has not
> been received by person I sent it to. Is there a problem here?
> What can I do to fix?
If an item gets moved from the Ou...Anyone use Mailwasher?....
If so does anyone have problems with their outlook form time to time
If so is the kind of problem when outlook won't find your pop servers?
Not sure if this helps, but I love mailwasher...
Turn off your automatic receive. Use mailwasher with 2
minutes or so receive, after you open it when you see new
messages in the taskbar, clean up and confirm THEN press
F9 in outlook to receive mail.
p.s. get the pro version, its worth the 20 bucks!
>If so does anyone have problems with their outlook form
time t...Using Time in formulas #3
Thanks for the link. I found that if I add 0.042 I'll get the nex
hour. Every so often it needs to be adjusted to 0.041 instead.
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=107
View this thread: http://www.excelforum.com/showthread.php?threadid=26920
...Using Foxpro from within Ms Excel using macros
Does anyone now how to incorporate the foxpro code "=sys(3050,1,100000) into
a VB macro so that the remote machines I am using restrict
foreground/background buffer memory. The following is taken from Microsoft's
"Using the commands COPY, APPEND, DELETE, INDEX, PACK or SQL-SELECT on a
large table in Visual FoxPro causes long pauses while the data is being
manipulated. The hard drive continues processing the data, but Visual FoxPro
seems to be inactive. This happens because computers that have large amounts
of RAM and are running Windows 95 or Windows NT g...Trying to use the INDIRECT funtion with a relative Row reference
I have a worksheet where I have rows of information. Each row is made up of
several columns of information. I am constantly updating the information by
inserting cells and moving the old cell to the right. I am trying to use the
INDIRECT function to reference the "G" column but I need the row number to be
relative because I sort the worksheet based on the information I get back.
INDIRECT works great until I sort then it is still refering to the row where
the information WAS at. . .not where it is NOW. I hope this makes sense and
any help would be greatly appreciated.
Tha...Access Version being used
This work only if the version of Access matches the version of Excel. How do
you detect the Access version being used?
Private Sub CommandButton5_Click() 'Go to customer database
Dim X As String
Dim nVer As Long
nVer = Val(Application.Version)
If nVer = 11 Then
X = Shell("C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE
If nVer = 12 Then
X = Shell("c:\Program Files\Microsoft Office\Office12\MSACCESS.EXE
If nVer =...I clicked a wrong button...am I destined to never use outlook now?
So I was trying to set up my new copy of Outlook 2007...I clicked on exchange
server instead of web based email system...now every time I open outlook it
says "cannot connect to exchange server" then it gives me the server
location and mailbox name, which I've tried to change...but then it just says
"cannot connect" and shuts down the whole program...how do I get back into
the setup page to fix my blunder?
I even tried uninstalling it and reinstalling it, but I guess that gets
saved? Wierd as all heck....Any help would be welcome....
Tools | A...ByVal copy a variable
I understand the significance between memory pointers with a function using
byVal and byRef.
However I have code that I want to do something like this:
Dim UsMailmsg As MailMessage = EmailOrderClass.createEmailOrder(False,
For nI As Integer = 0 To SendToEmailAddresses.Count - 1
ToEmailAddress, UsMailmsg) <------- this line
Now When I am using the UsMailmsg, even though the function is specified as
"byVal" it will always pass in as a reference to a mem...