Installing and using Office: MAC 2008 Home and Student Addition
Operating System: Mac OS X 10.5 (Leopard)
My husband recently purchased a new MacBook Pro. He gave me his MacBook Air. Office Home and Student addition was installed on his old computer (MacBook Air), and was loaded on the new computer. I purchased my own copy of Office: MAC 2008 Home and Student and installed it on the MacBook Air but can't use when my husband is using his version. The product keys are obviously different, but when he's writing in Word, I cannot. The message is that two people can not use the program at once who are on the same network. What do I do so ...VB Code help
Here is a portion of one of my VB Macros in Excel:
If Selection.Count > 0 Then
MsgBox ("Average = ") & (RunningTotal / Selection.Count), vbInformation,
My question: How do I format the number (RunningTotal/Selection.Count) to
look like 0.000, instead of 0.0000000000000000?? What should my code look
like with the new formatting.
....Format((RunningTotal / Selection.Count), "0.000")...
mvpearl omitthisword at verizon period net
&qu...Automatic Updates 09-12-10
I have a Dell Inspiron e1505 with Windows XP Home Edition - SP3. Overall
workinig pretty good. I have Automatic Updates turned on and for some reason
it keeps wanting to "Installing Microsoft .NET Framework 1.1 Service Pack 1
(update 1 of 1)... ", however just as it's starting a window entitled
"SL18.tmp" pops up and says "SL18.tmp has encountered a problem and needs to
close. We are sorry for the inconvenience." My only option at this point is
to Close the window and then the Automatic Update stops, but then after a
while it tries again with ...Move Mailbox errors
I'm currently migrating from Exchange 2000 to Exchange 2003. We're in a
native mode Windows 2003 AD. I am migrating about 500 mailbox from a
standalone Exchange 2000 to a WIndows 2003 / Exchange 2003 Active/passive
cluster configuration. Mailbox moves have been going great up until
yesterday. While moving the users in the normal way,2 mailboxes hung at
100%. In the "state" column, it says: "Saving changes to the directory". I
let it sit at this stage for more than 10 hours. I then have to cancel the
task, then it says cancel running tasks, and this wil...outlook 2007 error message in archive folders
for no discernable reason some and only some of my archive folders will no
longer open and give the following error message:
the message interface has returned an unknown error. If the problem persists
I have restarted not only outlook but rebooted my computer with no positive
result. I have also gone back a month to a restore point but this has not
changed the position. As I say it is only some files and then only some
subfiles in larger files.
One month ago there were no issues. I have added no new programs to the
Try running scanpst.exe against y...update from Office 98 to newer version?
How do I update my microsoft Office 98 to a newer version? I have a
office 2000 CD, which I received years ago, but I cant get it to work.
Can I update over the internet on Microsoft homepage - and WHERE?
Thanks a lot,
You will need to purchase Office 2004 for the MAC
See this for info on purchasing
Control the things you can and Don't Worr...code to sum 8 textboxes
I am trying to get a text box (txtsubtotal) to sum 8 other 'price' text
boxes (txtprice1...txtprice8) when a command button (cmdCalculate) is
clicked. Each 'price' text box is filled via a combo box (cboitem1) change
Here is briefly what I have:
Each combo box is coded like this:
Private Sub cboItem1_change()
Me.txtprice1 = WorksheetFunction.VLookup(Me.cboItem1, Worksheets
_("Pizzas").Range("A:B"), 2, 0)
Each 'price' text box is coded like this:
Private Sub txtprice1_change()
txtprice1.Value = Format(Me.tx...Error Number: 0x800ccc0e when I try to get messages
I am a postmaster of our network and I am having some problems with
Outlook 2000 and our pop3 server.
The problem is that randomly, Outlook's users can not download their
mail because they get the error number 0x800ccc0e when they try to
send amd receive mail.
We are using Microsoft Outlook 2000 SP-3 (22.214.171.12427) and our server
is a Linux Debian running a 2.4.27 kernel. I have tried with ipop3d
and in.qpopper as a pop3 daemons and with both I get the error.
There is no firewall between them and this is the tcpdump capture from
the server (our pop3 server runs at port 40110, bu...80040e19 error occurring with 2nd NIC installed
I am experiencing the 80040e19 error when expanding public folders in
Exchange System Manager, Exchange 2000. I have exhausted all suggested MS
articles and *still* have not resolved the issue. No evidence of URLScan or
iislockdown being run on the server. Strange thing is is that when I disable
the newly installed NIC through device manager the public folders can be
expanded perfectly. On enabling the NIC, same error. The server is the PDC,
Exchange and Intranet server, running IIS on port 80 for local intranet site
and the admin website on port 7715. I have checked the host head...Workbooks that are not directly linked updating?
I have 3 workbooks: WB1, WB2, and WB3. WB1 and WB2 are both linked to WB3 but
not each other.
WB1 contains volumes and WB2 contains costs. When I open these two together
and say no to updating the values change anyway.
Any clue on why two workbooks update even if I say no or don't want to have
...Installing SBS SP1 after Windows 2003 SP2 ?
I have a Small Business Server 2003 that has had 'Windows Server 2003
Service Pack 2' installed on it but 'Windows Small Business Server 2003
Service Pack 1' has NOT been installed on it.
I found this out by running Best Practices Analyzer in preparation for
migrating to Small Business Server 2008. Having SBS SP1 installed is one of
the 2008 pre-requisites.
Are there any issues with installing SBS SP1 after Window 2003 SP2 ?
Shouldn’t be any problem. Just follow the procedures in the following
How to install ...how to put in sql code
first of all many thanks to Klatuu who has already helped me a lot!!
I create my SQl code by means of some string concatenation. I do this so i
can use the values of my field to create my SQl code.
The problem is that some of these fields are double-populated
eg. field location contains England and Brazil.
My string creates "IIf([Table]![Location]" & [Location] & ",'OK', 'problem')"
how can i populated the field location so that it is SQl-code?
as =(Brazil or England) does not work
as =Brazil or = England do...Copy sheet in Excel
Wonder if anyone of you encounter this problem before? When I try to copy
worksheet in a workbook, the following prompt comes up, indicating name
"A formula or sheet you want to move or copy contains the name 'aaaa', which
already exists on the destination worksheet. Do you want to use this version
of the name?
- To use the name as defined in the destination sheet, click Yes
- To rename the range referred to in the formula or worksheet, click No, and
enter a new name in the Name Conflict dialog box"
When I clicked yes, another prompt comes up indicating ...space then date causes error
On my spreadsheet they have to type in a date and other calculations are
taken from this point. Of the hundreds that have used it there have been
no problems, however as always there will always be one.......
When they fill in the date they type a space and then type the date,
this throws up errors in the other calculations.
Not altogether important but is there an easy fix for this, so that if
anyone types a space it is ignored, I dont want to get involved in
Right click the sheet tab>view code>insert this>modify range to suit
Private Sub Worksheet_Change(By...ameritrade plus error
When I try to download my information from ameritrade
plus i get a invalid org error. Anyone else experience
this problem. Help Please..
>When I try to download my information from ameritrade
>plus i get a invalid org error. Anyone else experience
...Money2002 Setup Error
When I try to setup (windows98) I get the following:
"This program has performed an illegal operation and will be shut down. If
the problem persists, contact the program vendor."
Here are the details:
SETUP executed an invalid instruction in
module ADVPACK.DLL at 015f:715f5858.
EAX=0066cf04 CS=015f EIP=715f5858 EFLGS=00010206
EBX=0066d364 SS=0167 ESP=0066cdf4 EBP=0066d014
ECX=0066f8d0 DS=0167 ESI=00000348 FS=6017
EDX=0044003c ES=0167 EDI=0066d350 GS=0000
Bytes at CS:EIP:
fe ff ff 50 ff 15 68 11 5f 71 56 8d 85 fc fe ff
00000080 bff77b14 71604004 00667000 0...[Excel 2003] problem in files with pivottables after install Office Service Pack 3
System: Windows XP Pro SP2, Office 2003 Professional + Service Pack 3
I have a problem with some xls files after install office service pack
3. With service pack 2 this files normal open. With service pack 3 after
open file displays dialog (my translate from russian) "In workbook ...
have contents which can not be read. Try restore contents of workbook ?
If you trust source of this workbook, press button YES". If I press "No"
- file not opens. If I press "Yes", displays next dialog. This dialog
form content a list of corrections in file. Biggest pa...Uninstall/Re-install CRM for Outlook
After installing CRM for Outlook on a client computer
(Win XP and Office 2003), CRM 1.2, Exchange 2003, Server
2003, I had a problem with a profile, which I deleted.
From that time on, nothing worked, the CRM for Outlook
would not work, I could not uninstall the CRM from
Add/Remove Programs (I get this message: "This action is
only valid for products that are currently installed"). I
can't re-install either as I am notified that the product
is already installed.
I can't remove folders (Microsoft CrM) as some files are
What to do? Could you please give ...Gradual migrate from 5.5 to 2003 on 2000 Server
Can I concurrently run a 5.5 Exchange server and a 2003 Exchange server on a
2000 server AD domain?
one 2000 AD domain w/100 users
w/ two 5.5 exchange servers running on 2000 (member) servers.
I would like to add 2003 exchange (temporarily) on either a 2000
(member)server or a new 2003 (member) server and gradually migrate my users
to that server. Once all the users are cleared off the old servers, upgrade
the old servers to Exchange 2003 and move back the users.
A. Is this nuts?
B. Can this be done?
C. Licensing during migration? Exchange CALs?
> Can I concu...Error Occured Trying to Promote this email
This happens when trying to promote a email to CRM
Can anyone help?
...conversion ? #5
This is a multi-part message in MIME format.
How do you convert Quicken 2005 Files to Money 2005 ?=20
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
<...Installing Exchange 2007 into exsiting organization
This is the first Exchange 2007 we have. Current environment is a mix
of Exchange 2000 and 2003 in native mode.
During the installation step, it is asking me to enter the name of
organization, which I am hesitate to do -- I don't want to create a
new Exchange organization under our domain.
What should I do so it will pick up the exsiting organization and try
to add itself into there ??
I am sorry, let me provide more info about the above post. I read
this arcitle: http://technet.microsoft.com/en-us/library/54c6e6d4-aa19-4d30-87b6-31a1ca018a3f.aspx
and was following the instruction ...New User
Using Outlook 2003 with Exchange Server 2000 on XP Pro SP2 - all
service packs updated. Attempted to setup a new user account on this
system because previous employee has left and need new profile
established. When attempt to setup email through Exchange and click
'Check Name' we get the following error:
The new user account will work fine on another system on the network,
so the problem is not with Exchange but with this local system.
Have tried deleting the pro...Slow VBA Code
Any idea why this code is so slow? It used to run fine it now take
around 20 seconds to complete
any help would be appriciated.
Dim prev As Integer
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
prev = ActiveCell.Offset(rowoffset:=-1, columnoffset:=0).Value
Selection.Value = prev + 1
' gives record an individual number automatically
Sheets("...GP 9.0 should allow to pin the drop down like in 7.5
I would like to have the ability to pin down the drop down's in GP 9.0.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.