Question about what "Home" means in the Home and Student Edition
I was wondering if someone could answer a question for me please.<br>
I am seriously considering buying the "Office 2008 for Mac - Home and Student Edition" and I want to check what is allowed by the EULA.<br>
I like the 3 licenses because both my wife and I have a Mac and would be able to use Office 2008.<br>
However, both of us receive both "work" related email as well as "personal/home" email (we each use one email address for everything). Also, occasionally we might write a �work...Outlook 2002 "The remote Procedure call Failed"
I have found many posting of the error occuring but none of them have
answered my situation.
OS: WinXP Pro SP1 (can't install SP2 until updates for CAM software
Office: Office 2002 updated (Server running Exchange 2003 Stand.)
AV: Norton Corp v8.0 updated
Open Outlook/ create new mail / click the TO: button...
system waitings and reports "The remote Procedure call Failed" and
Outlook shuts down...
I know that there is no virus on this computer many different AV
products scans confirms this.
Client currently using OWA to email...
Any th...Closing another database with VBA
I’m having a problem with the code to do the following…
1- A user opens a file called Core.
2- Upon opening the splash screen (on the Form_Load event), it compares a
version number it finds within the database to one that is in another
database called Data.
3- If the versions are different, the Core file opens the Updater file.
4- The Updater file closes the Core file.
5- The Updater file copies the latest version of the Core file (located
somewhere else) and replaces the first one with the latest version.
6- The Updater opens the newly copied Core file.
7- The Updater closes itself.
...macro for comparing fields in two work books
I have two excel spread sheets (say A1 & A2). A1- is the master sprea
sheet and A2 is smaller spread sheet with very few details.
Suppose Column B in A2 has 100 partnumbers and Column C in A1 has th
superset of partumbers (1000) and corresponding details for each par
number, I need to:
1. Check if all the 100 part numbers in A2 has a corresponding match i
2. Extract the info for the matched partnumbers from A1 and list in
3. Even if there in no match A1, let's say for 40 of them, it shoul
still list those parts in the new sheet.
Can anybody help me with t...Out of Office Question
We're new to O at our office. On occasion, I get OOO replies when I email
people. I ask how they set it up and everyone tells me Tools, then Out of
Office. My choices under Tools do not include OOO but they do include Rules
Wizard. I feel sure somewhere in there is a way to set up OOO replies but I
haven't hit upon the exact procedure. Help is no help at all. I have the disc,
I run W2000 Professional. Can someone give me the drill to set up an OOO reply
so I can turn it on before I go on vacation next week? Thanks in advance to all
who help or try. Steve Ignots
You need to be u...VBA Autocomplete
I am having trouble with autocomplete that has stop working in the IDE
while coding. Then it will suddenly start again for a while, before
I have tried restarting excel and the PC but no joy
Any ideals what causes this?
VBA IDE 6.0.8714
...shift and down keys in macro
I want to mark four cells.
How can I write shift+down+down+down in a macro.
(Then I say copy paste etc).
OR starting from cell A1 copy 4 cells to the same sheet cell J1
> I want to mark four cells.
> How can I write shift+down+down+down in a macro.
> (Then I say copy paste etc).
> Cousin Excel
Hi and thank you Jacob Skaria.
This was something new for me...How to stop tracking a Contact in CRM 4.0
How do I stop tracking an Outlook Contact that has been set to "Track in CRM"
The "Track in CRM" for contacts turns to "View in CRM" when a matching
contact record is created in the CRM database. If you no longer want that
contact in CRM then you can delete it, then it will say "Track in CRM" again.
"Ken Florian" wrote:
> How do I stop tracking an Outlook Contact that has been set to "Track in CRM"
Our (non-profit) organization puts out a newsletter (created in Publisher),
and we'd like to convert it to PDF to send it to some people that way. I
know how to do this (I have Primo PDF), but when I just did it, the fonts in
(small) sections on two of the pages were garbled. In one instance it was
an unusual font, so I thought that might be the problem. But in the other
instance it's not an unusual font. Is there any way I can change/correct
the garbled font? I have Adobe Acrobat reader 5.0. Seems like I might
have tried to upgrade a while back and it didn't "ta...Calender related question
Is there a way to tell what time and date an appointment was created.
We have Outlook 2003 with Exchange 2003 and Windows 2003 Server.
In outlook, you can add the "Created" column and that will show the create
time for that item.
"Vic Abrahamian" <VicAbrahamian@discussions.microsoft.com> wrote in message
> Is there a way to tell what time and date an appointment was created.
> We have Outlook 2003 with Exchange 2003 and Windows 2003 Server.
> Thank you
...Update stored procedure question
We are using VS 2008 and SQL Server 2005.
I have a table Spread that has 1 Integer column called SecurityID.
I have a stored procedure spUpdateSpread that increment the SecurityID by 1,
and returns that value.
If more than 1 process call the stored procedure at the same time, will it
return the correct SecurityID ?
CREATE TABLE [dbo].[Spread](
SecurityID [int] NOT NULL,
PRIMARY KEY NONCLUSTERED
) ON [PRIMARY]
CREATE PROCEDURE [dbo].[spUpdateSpread]
@SecurityID int output
update Spread set SecurityID = SecurityID + 1
select @Secu...Calling VBA subroutine from a query?
Can I call a VBA subroutine from within an Access query? I wrote some English
to Metric conversion routines in the Access VBA code and would like to run a
query on the data that will return coverted values. I need to be able to
execute this from outside the database (run the query from another program).
Yes. The function must be a Public Function in a standard module. You use a
calculated control to return the results of the query.
Dave Hargis, Microsoft Access MVP
> Can I call a VBA subroutine from within an ...rules question
This is a multi-part message in MIME format.
I'd like to make a rule similar to the one I have - move all emails from
a certain SENDER to a specified FOLDER.
I want to also make a rule to move to a specified folder, when an email
is sent to a specific USER.
I don't see how to do this in the canned rules? Has anyone got
creative with this and made it work? I can get it to do a COPY, but
not a move.
------=_NextPart_000_0008_0...SQL select statement question
My dataset has 3 columns: customer id, store location, charges
I'd like to write a single select statment that will show each customer id
once, with the store location where they have the most charges, and the sum
of the charges for that store location.
This gives the max charges for each customer, but doesn't give the location:
select a.custID, max(new.amt) from smallchg a inner join;
(select custID, location, sum(charges) as amt from smallchg group by custID,
location) as new ;
on a.custID= new.CustID group by a.CustID
Try this --
SELECT TOP 1 ...macro protection problem
What is the preferred method to deal with macro protection? I have just
updated all the machines to office2k3 and now a critical worksheet that
uses benign macros doesn't run because of the protection. Bringing security
to "low" allows it to run but each user has to set that themselves.
I have heard about creating a local CA for trusting the macro and I am
interested in that but isn't there an easier way?
Setting security to low is very unwise. Stupid even, in a company.
All methods involve making changes on each machine unless you have Group
Policies set up (which...Shared Contacts Master Categories question
I need to have 50 users on Outlook/Exchange specify a number of contacts
that need to be exported to another system. I had my Exchange admin
give me shared access to each of the mailboxes in question. My plan was
to go through each set of contacts, and add a new category to the master
categories for each user. When I got the the second contact, the
keyword identifier was already there! It looks like Outlook/Exchange is
allowing me access to the correct contacts, but is using my master
category list. How can I access and update each users category master
list? Isn't this kept ...Newbie question, can't get a handle on the handles <g> ... ?
How do we manipulate text that needs to flow to another box, i.e.,
when working in two columns and we need text to flow to a third, how
do we do this?
I'm sorry for such a simple question, but I've looked through the help
and on the web and I think it's because I don't know what it's called.
Anyhoo, pls advise!
Whilst attempting to develop brick-based storage technology, Ed reads a
message from Dylan56 <No@SpamAtAll.com>
> How do we manipulate text that needs to flow to another box, i.e.,
> when working in two columns and we need text to flow to a third,...Macro to open print window and set to print entire workbook
I need help getitng a macro created to open the print window, then se
it to 'print the entire workbook'. Then the macro would stop. At whic
the user would then specify additional specs for printing. I.E. # o
pages, paper size etc.
I am trying to default the 'print entire work book option' withou
restricting the user from other print specs.
I have a macro that will print once a button is clicked on th
spreadsheet but it goes directly to print and does not let the user se
other specs. I.E. # of pages, etc.
Thanks in advanc
---------------------------------------...WLM Stopped working 02-20-10
I'm running Vista Home Premium, SP2, 2 GB of RAM, Firefox, WLM, all WU's
I was in WLM mail newsgroups earlier today and things just stopped. WLM
stopped responding. Now I cannot log into WLM. It used to log into window
Live by itself (password and all) from my desktop icon, but now the only
thing that happens when I try to open my WLM app window is I'm taken to IE
(7). Then when when I try to sign in Windows live it won't do it.
I've already ran SAS, MBAM, CCleaner and Avira in Safe mode but found
nothing. Then I did a system restore back to a fe...checking for existance of file before running macro
I have a macro that opens a source file to retrieve information. I want to
be able to check to see if it's there first and if it's not send a msg to
the user stating that the file isn't there. When the user clicks okay on the
box I want the macro to end without error. Can anyone help?
You can use the Dir() function:
dim myFilename as string
myfilename = "C:\autoexec.bat"
if dir(myfilename) = "" then
'it's not there
'yes, it is
> I have a macro that opens a source file to retrieve information. I wan...Entourage has stopped retrieving just one certain person's email
Operating System: Mac OS X 10.4 (Tiger)
Email Client: pop
I have been receiving all my emails normally apart from just one sender, who i previously had no problems with. The email is sitting in my inbox when i log in via the browser account, however it just doesnt get sent directly from the sender. if I then send this person's email to myself, it gets delivered to my inbox. THe problem ahs only started in the last week, no settings have been changed and every other email is getting delivered. <br>
My hosting provider says it is not their issue and they don...Macro to "save as"
Am using excel 2003 and am wanting to create a macro, attached to a button,
that will save as a particular cell #, say A2, and then print. Have the
print down pat, but can't figure out the save as part.......
Thanks for the help
What is in cell A2? Try things like these, depending on what you have and what you want to do....
ThisWorkbook.SaveAs Range("A2").Value & ".xls"
ThisWorkbook.SaveCopyAs Range("A2").Value & ".xls"
ThisWorkbook.SaveAs "C:\Folder Path\" & Range("A2").Value & ".xls", Ad...VBA Command to Deselect a Shape
I've written a VBA program that drops shapes (from a stencil I created) on a
page, but at the end of the exercise the last shape is selected (it has a
dotted line surrounding it). Is there a VBA command that will deselet this
shape (or select the page on which it sits?
On Fri, 22 Sep 2006 12:16:02 -0700, MikeM
>I've written a VBA program that drops shapes (from a stencil I created) on a
>page, but at the end of the exercise the last shape is selected (it has a
>dotted line surrounding it). Is there a VBA command that ...Advanced Filters question
I sometimes use Msft Access to run a query, and then revise the query,
or build off of the new query by creating a separate query of that
However, in using excel, at least at first pass, I noticed that I was
unable to pivot the data that resulted from an advanced filter, and I
was unable to see the total amount for a given column, once an
advanced filter was applied to a list (i.e., the sum that I saw was
for the entire field and not for the records that were visible once I
had applied the filter).
Does anyone have any perspective they could share with me regarding
this? Is there a wa...Mail (outlook 2002), 'To' field, general question
Why do some names of some messages in the 'To' Field appear with single
quotes in my Sent Box? I'm using Outlook 2002.
I'm sure there's an easy explanation but it stumps me.