Function TTEst in Excel
I need write function TTEst in my own program, which return value same TTEst
I try use code from:
I found algorithm for T-value only. How can I find T probability using
How work TTEst in MSExcel?
If your program is written in Excel's VBA, simply use Worksheetfunction.TTest
Otherwise, you could use
AFAIK, the best double precision implementation ...Excel Font error message
I am getting an error message that says "No more fonts may be added to this
workbook". I cannot find any information on this in the help module. What
does this mean and how can it be fixed? When I save it and re-enter the
workbook, it lets me work for awhile and then I again get the same message.
Read this KB
XL2000: Error Copying Worksheets Containing Charts
Regards Ron de Bruin
"Mcripe" <Mcripe@discussions.microsoft.com> wrote in message news:96C57166-0...Outlook Creating Sync Problem Folders.....HELP
When Outlook 2003 perform the send/receive action. My mail comes in/out,
however a box pops up showing there was an error. This error then goes into
a sync folder as an email. I DID NOT create this folder. If I delete the
sync folder, it re-creates itself. Any ideas on how to stop this madness?
The sync folder is a system folder that Outlook needs and uses. Would
probably be better to address the error, rather than merely trying to hide
the reporting mechanism, no?
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.officeforl...some of the color palletes in excel do not show there name when I.
some time I have to color certain item(s) in a certain color, but when I put
the arrow on the color pallete, in Excel it does not identifies the color
name and since many of the colors look similar than how do I know that I
chose the correct one.
I also can not find the cent symbol. Example--99cents
please advice me
Thank You BYE
can't help you with the color pallete question
but (as far as i know) there is no cents symbol, generally people enter 99c
however, if you really want the c to show up after numbers (and be warned
this does not...Excel updating from XML file
I'm having a littl edifficulty getting Excel to dynamically update from an
XML file. The XML file is generated from a program and I would like the Excel
file to dynamically update.
Problem is that the location of the XML and Excel file can change, that is
they can be anywhere on a hard drive but both are in the same directory. The
mapping of the XML file in Excel appears to be a complete file path
C:/data/report/.... but the location could change. They could be in
C:/data/report/run1 or run2, I don't want to have to re-map each time a
report is generated.
Ideally I would like t...POS Sync After Every Z Report
I'm wondering if it's the expected behavior to have a POS on another
station sync every time a Z report is ran? Should the database sync
every time? I thought only when the POS was in offline status.
I don't believe the POS is offline everyday, but everyday when we take
a Z report, the database syncs with the POS with the database.
Is this expected?
It syncs every z because there may be changes to the items, taxes and other
"Jerry Penna" <firstname.lastname@example.org> wrote in message
news:email@example.com...DPM 2010 RC and SharePoint 2007 item level
We use DPM 2010 RC to protect a SharePoint 2007 server and some of the sites
are not cataloged for item level with the following error message:
"DPM failed to gather item level catalog for 1 database(s) of the SharePoint
Farm Sharepoint Farm\database2009a\SharePoint_Config on [...]. Some of the
recovery points for these databases in the farm would be associated with an
earlier successful catalog. (ID 3133)"
Can anyone tell me how to determine which are those recovery points or how
to deal with this association problem?
Can you ple...Remote sync
Is there a software out there that I can use to either remote sync my
Outlook contact and calendar from my office to my home pc, or remotely
update the calendar to my home pc without connecting to an exchange server.
I have a standalone desktop running xp and connecting to a cable modem at
home and I want to update my outlook calendar and contact from the office(T1
line). I will buy any device that will do the job. Ipaq, Palm or AT&T
blackberry 7210 or anything works. If there is no software to do this, is it
possible to do it with any other solution.
Any suggestion will be very greatly a...Macro error after switching from Excel 2000 to Excel 2003
My company recently switched from Excel 2000 to Excel 2003 and now a macro I
created does not work. It gives me the error 1004 and highlights the line of
code where I set it up to open certain files in a folder. This macro has
been working for 6 months without fail and only has problems opening the
Excel files I created after the switch to 2003. Any help would be
Without any other info the only suggestion is to see if your sheets
have different names.
For example, a statement like:
Sheets("Feb Sales").Cells(i, j+5) = k
might cause a 1004 error if the new workb...Outlook 2007 and digital certificates
I've been using Outlook 2007 for a while with a digital certificate I have
from Comodo. It is annoying how every signed e-mail I sent, Outlook has to
ask me _twice_ about granting access to the certificate in order to send
_any_ e-mail I want to sign.
I have already trusted the certificate using the Trust Center in Outlook but
it doesn't help. If the window for granting/denying access showed up only
once I would not be bothered at all, but why twice? I didn't have this
problem in Outlook Express nor in Outlook 2003.
Is there anyway to fix this? I'd be very thank...OneNote sync no linger syncs
I have oneNote 2007 installed on Laptop with Windows Vista. It has been
syncing with my Pocket PC but it no longer does. Updates on either device are
not carried to the other.
I have uninstalled OneNote on the Pocket PC with no effect.
What should I do?
....and I assume you REinstalled OneNote on the Pocket PC? What OS is the
Pocket PC running?
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/ol4law-amazo...Excel Chart as Image (no file)
VB2005 and Excel2007
I am looking for a method using Office Interop to load an Excel chart
as an image into a picturebox. Note that I can already open the Excel
file through code, i can create the chart, I can save the chart as an
image to a file on the disk, and then load the file into the
I am hoping there is a way to get a picture in memory from the chart
and load it directly into the picturebox without saving to disk.
picBudget.Image = xlChart.Picture
Has anyone tackled something like this?
...open older version of excel in excel 2002
I just got this excel 2002 instal in my computer.
I can not open any of my earlier verion of excel 2002.
Please advise what I should do.
Excel 2002 can open previous Excel versions - what version Excel file are
you trying to open?
"Myphuong" <firstname.lastname@example.org> wrote in message
> I just got this excel 2002 instal in my computer.
> I can not open any of my earlier verion of excel 2002.
> Please advise what I should do.
There...Modify "quick part" in Outlook 2007
Does anyone know how to modify the contents (not just the description,
category,...) of a "quick part" saved in Outlook 2007?
Insert the Quick Part, modify what you want and then add the Quick Part
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"Philippe De Ridder" <PhilippeDeRidder@discussions.microsoft.com> wrote in...Just put Cd-rom disc in to save Excel Spreadsheet and its not let
Need to save Spreadsheet on CD- Wont let me do it!!Says incorrect function I
dont have access to Drive D!!!!!What is this?? Need help Fast!!!
morgan51, it is best to save to your hard drive first and then put the file
on the CD as you would any other file
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"morgan51" <email@example.com> wrote in message
news:A60E4F38-747F-445C-AC54-66E662B7C17B@microsoft...Excel 2007 with 2003 issues
Hi all gurus, i have issues with 2003 with a button, if i press a button it
will ask the user to select a cell with an email address in and it will then
email the relevant user, this works fine in 2007 but not in 2003.
Is they any code i should put in to make it compatitible with 2003?
Try the below macro..
--Edit the extternal workbook name and path
--Edit the destination sheet name...
--Edit the copy desitnation. Currently that is mentioned as cell A1
Dim wb1 As Workbook, wb2 As Workbook
Application.DisplayAlerts = False
Application.S...Microsoft Money Deluxe 2007 for Canadians
I upgraded my PC tried Microsoft Office and then bought it. . . tried the
trial of Microsoft Money 2007 deluxe for two months and 25 days . . . and
Digital River will not let me buy it. Microsoft Support says well if Digital
River won't sell it to you try Amazon.com . . . Amazon.com will not let me
buy it either.
I very very much resent the fact that I've loaded three months worth of data
into a software program that I cannot purchase. It would have been far
better to have received a warning that this software could not be purchased
in Canada before I down loaded the trial ...Rounding in Excel
I need to round a time to the nearest 30 minutes in Excel
XL stores times as fractional days, so since 30 minutes is 1/48 of a day:
format as a time.
In article <85471F3C-009B-468C-826A-FE979AE7E9BD@microsoft.com>,
"DG" <DG@discussions.microsoft.com> wrote:
> I need to round a time to the nearest 30 minutes in Excel
...Outlook 2007 Backup Command not showing up
After downloading and installing the Personal Folders Backup Tool, the Backup
command is not showing up under the File menu. I'm using Outlook 2007 in a
Win7 environment. It all worked fine on Outlook 2002 in a Win XP environment.
Can anyone please help? Thanks in advance.
You can just close Outlook and copy the PST file instead.
> After downloading and installing the Personal Folders Backup Tool, the Backup
> command is not showing up under the File menu. I'm using Outlook 2007 in a
> Win7 environment. It all worked fine on Outlook 2002 in a Win...Excel CountIF Function
I am using the CountIF function in excel to add up the
number of occurances of a single letter such as "a" or "b"
in a colum. However, I need a formula that will recognize
the "a" when it is in the form "a & d" in a single cell.
How can I do this?
>I am using the CountIF function in excel to add up the
>number of occurances of a single letter such as "a"
>in a colum. However, I need a formula that will...Outlook not syncing correctly
Friday I had a nasty disk failure of a server which services a small
network, it has only about 5 users. It's the only server in the AD,
running as DC ofcourse, W2003 Sp1, Exchange 2003 Sp2. The disk was dead
as dead can be. So the disaster recovery plan kicks in... yeah right.
Last good tape turned out to be from august 15th 2005. Don't get me
started on why.
I put in a new disk, installed W2003 SP1 eval edition (only cd
arround), restored from tape the c-drive, system state and exchange.
After a few reboots solving minor issues about WMI etc, I started
checking my mailboxes. Wit...Subtotals in Excel 2007
A1 contains the column heading "NAME"
A2 thru A700000 contain names (each name can occur 1 thru 25 times).
B1 contains the column heading "AMOUNT"
B2 thru B700000 contain amounts
In the SUBTOTALS dialog box:
In the "AT EACH CHANGE IN" box, I select NAME
In the "USE FUNCTION" box, I select SUM
In the "ADD SUBTOTAL TO" box, I click NAME and AMOUNT
When I click OK, why does it take at least several HOURS to compute
the subtotals for the 80,000 unique names? How can I speed up the
Have you considered using a pivot ta...vba 97 excel lookup formula
i have this code
which will lookup the prices, if woodlawn's name is in H18 it will draw
prices from a different list. i would like it to also include the "IF"
for the name "spencer" as well, but when i try to extend the formula it
tells me i have too many arguments. what does the formula have to look
like in order to make this work. thanks
chief's Profile: http://www.e...sync
I have the hebrew calendar enabled as the alternate calendar in my
outlook2003. I have the latest version of Active Sync. I am able to sync the
normal english calendar but i cannot sync the hebrew calendar. Can some body
> I have the hebrew calendar enabled as the alternate calendar in my
> outlook2003. I have the latest version of Active Sync. I am able to
> sync the normal english calendar but i cannot sync the hebrew
> calendar. Can some body guide me?
Hi - might want to post in a PocketPC / Activesync group f...ASP to Excel Image Alignment Problems
I'm exporting an ASP page to Excel using 'Response.ContentType =
"application/vnd.ms-excel"' and it is working fine for the most part
except the particular page I'm exporting has images, and no matter
what style/alignment/etc. that I provide to the <td> tag that contains
the <img> tag, it always left-aligns the image in the Excel cell.
Has anyone had any success with controlling the alignment of images
when exporting from ASP to Excel using
'Response.ContentType = "application/vnd.ms-excel"'? If so, would you
be willing to share...