Is there a two a shortcut to Save As with two letters?
I know that Ctrl + S is the shortcut to Save document.
I wonder, is there a shorcut to Save As other than the F12 key?
If it is a new (unsaved) document, then Ctrl+S will trigger the SaveAs
dialog too because Word is unable to simply Save as it doesn't know what
name or location to save it.
Terry Farrell - MSWord MVP
"Octavio" <email@example.com> wrote in message
> I know that Ctrl + S is the shortcut to Save document.
> I wonder, is there a shorcut to Save As other than the F12 ke...Two field entry questions
I don't know if VBA will be involved, but... I have a Word
document with some tables and some of the cells of that
table should have text entered. What I'd really like to have
those cells which require entry to initially be yellow in color,
but whenever text is entered (either when the cursor has left
the table cell, or also acceptable when any text appears
in the table cell) the background color should go away.
My second question is that there are some places in my
document where I have entered spaces with an underline
to indicate that it should be filled out. However, wh...WM_COPYDATA,...
can someone tell me what the path of
a WM_COPDATA is? You start
At SendMessage/PostMessage and
it goes to the target apps Handler
routine, but what happens with the data
in between the SendMessage and getting
it on the target data. Will the Memory
be stored temporarilly somewhere and read
from there or how will the memory delivered?
Beste Gr�sse / Best regards / Votre bien devoue
Latest Project: http://www.codeplex.com/restarts
Latest Open-Source Projects: http://entwicklung.junetz.de
"Thi...overlay two time series in a chart with different data amound
I have the stock quotes of two different companies. Of stock A I have daily
data and of stock B I only have weekly data. I'd like to overlay the two
companies' stock quotes in a diagram.
How do I have to configure excel for that it stretches the quote for the
company for which I only have weekly data?
any help is appreciated?
if you reply via email, please remove the NOSPAM from my address.
Try leaving blanks for the days when you have no data. Excel (using X
scatter graph) can handle gaps.
Put the dates, data for stock1 and data for stock2 in 3 consecutiv
A...How to combine two Money Files?
I have two separate money files, one with all my stock
info, and the other with checking, savings accounts,
etc. I would like to combine the two into one file. Is
there a way to do this?
(I'm using Money 2003 small business)
Decide which one of the two you want to make your main one. From the "other"
one export all accounts in QIF format. Load the new "main" file and import
the QIF files. Make sure to import them all together to avoid any transfers
being double counted (use CTRL + Click when asked which file to import).
Microsoft MVP - M...Conflict of two macros?
I have the below two codes in my worksheet, the first one is run using
a button and the second one is an automatic macro to enter fixed
There seems to be a conflict, as each time I use the button to add a
row, I get an error, and when I go to debug it highlights this row in
the second macro --> If Target.Value = "" Then
Is there a solution? I can't see why there is an error, as both are
Any help will be appreciated! Thanks!
***The first code:
Private Sub CommandButton1_Click()
For i = 1 To 10000
...Averaging a Value between Two Serial Dates
I have two spreadsheets. The first spreadsheet contains two columns, one for
start date/time (in serial format) and the second for stop date/time (in
The second spreadsheet contains two columns. One containing a serial
date/time and the other containing a meteorological value (eg. temperature).
I want Excel to read the start and stop date/time from the first spreadhseet
and then search the second spreadsheet for all temperature values which were
recorded during this time frame.
Lastly, I want Excel to average these values.
Is this possible using a single Excel func...Vlookup for two sheets in same workbook
Ok. I am desparate. I've working on this for hours;
I have VIN numbers in sheet 1 in the range I2:I5521
I have VIN numbers in sheet 2 in the range G2:G4717.
I need to see if the VIN numbers in sheet 2 are on sheet 1, of so highlight
the cell or delete the VIN number. I'd really like to delete the duplicate.
select column G in the second worksheet and name it "ColumnG" without the
Then, select cells I2 down to I5521 in the first worksheet and choose Format
Change Condition 1 to: Formula: =VLOOKUP(I2,ColumnG,1,FALSE)=I2
When using the above keyword and setting it to False with a worksheet change
event. How can I run my macros using worksheet change event, if I forget to
reset it to True?
You can't. With .EnableEvents set to false, events won't fire, and their
corresponding event macros won't run.
Just don't forget!
You can always enter
application.enableevents = true
in the immediate window of the VBE. You could even create a macro to run
that line of code.
In article <8E65B43B-08C5-470E-AE35-F292E36D8D53@microsoft.com>,
"nc" <firstname.lastname@example.org&g...terminating an application
I'm trying to terminated my application from within its CWinApp derived
class, i'm diong this by calling PostQuitMessage, But it isn't working. How
can I get my application to terminate from initinstance?
heres my current non-working code:
m_pMainWnd = &dlg;
int nResponse = dlg.DoModal();
catch (char *str)
I also don't like tha...Two quick questions
Firstly, I am using Excel 97 SR-2. My questions are:
If I enter a date in a cell then drag the fill handle down the column
it increased by one day each time. Is it possible to create 2 rows
with the same date, then the next two increase by one etc. If so, how
do I do it?
Secondly, if there is a formula in a cell but no data for it to use it
displays ####. Is it possible to stop this until data is entered?
timdee's Profile: http://www.excelforum.com/member.php?action=getinfo&userid...SendMessageTimeout, Wm_COPYDATA, interlocking
I am trying to port a sofwtare on pocket pc.
Here is the architecture :
I have two different processes (client/server)that communicates via a
In the direction of Server->Client, SendMessage is used
In the direction of CLient->Server, SendMessageTimeout with SMTO_BLOCK
(Prevents the calling thread from processing any other requests until
the function returns)
The problem is on pocket SendMessageTimeout only have a SMTO_NORMAL
parameter. It means the calling thread is not blocked.
Here is the situation :
My server sends to my client a WM_COPYDATA via a SendMessag...CRM 4 set up with two NICs
Can CRM 4 handle 2 network cards on the application server?
"ilibhart" <email@example.com> wrote in message
> Can CRM 4 handle 2 network cards on the application server?
Yes, it can. I have at least one CRM implementation running on a machine
with 2 NICs, each in different subnets.
...New user not added to TWO database
I've recently noticed that newly created users are not added to the TWO
database when they are created in GP. This prevents the user from being able
to log in (they get an error message saying to contact the system
administrator). Is there a SQL query I can run to fix this problem?
No SQL. Go into Tools > Setup > User Access and add the user to the
companies that you want them to access.
Josh Kandiko wrote:
> I've recently noticed that newly created users are not added to the
> TWO database when they are cre...Comparing two tables 09-17-07
I have a problem which I don't know how to solve. I have two tables. T1 and
T2. T1 has a field with phone numbers named PN1 and T2 also has a field with
phone numbers named PN2. T1 also has a field named F1. What I need is to find
out which records of T2 have the same phone number as in T1. So actually I
want to compare entries of the two phone number fields of the two tables. And
what I need is wherever the entries of both fields are the same to have the
ID number which is in a field in T2 entered in the field F1 of table 1.
So if PN2 of T2 the same with PN1 of T1, then I mu...WM_COPYDATA question
Can you send WM_COPYDATA messages asynchronously? For example, using
postmessage() instead of sendmessage()?
>Can you send WM_COPYDATA messages asynchronously? For example, using
>postmessage() instead of sendmessage()?
AFAIK you have to use SendMessage.
On Jul 1, 10:15=A0am, "Nick Schultz" <nick.schu...@flir.com> wrote:
> Can you send WM_COPYDATA messages asynchronously? =A0For example, using
> postmessage() instead of sendmessage()?
The quick answer is "no": You must use SendMessage and cannot use
The docs formerly include...Comparing two tables 07-05-07
I'm still getting used to Access and needed a little help.
I have two tables with virtually the same data and i was wanting to compare
them using an SQL query so i can see what data is missing?
Is anyone able to help?
On Thu, 5 Jul 2007 16:24:02 -0700, Adrian <Adrian@discussions.microsoft.com>
>I'm still getting used to Access and needed a little help.
>I have two tables with virtually the same data and i was wanting to compare
>them using an SQL query so i can see what data is missing?
>Is anyone able to help?
I've been following Joseph Newcomers tutorial on utilizing WM_COPYDATA
for inter process communicaton.
I need to transfer a variable amount of data to the client program.
Most of the time it is in the order of 40 bytes, but could be up to
I created 5 structures, each with a different array size. I examine
the size of the data to be sent and picked the structure with the most
appropriate size. In the message, I set dwData to a flag indicating
the type of message.
The recipient then casts the received data to the appropriate
Well that was the idea... I havent yet succe...Printing with Two Viewss
I have two views with each document and I would like to print what is in the
second view. When the second view has focus, then Print Preview and Print
are greyed out on the File Menu and I can't find any information on what has
to be done to print. My second view is CView class. I will appreciate any
By far the easiest way to start is createing an empty project with
print/print preview support, and one without. Then, see what code you'll
have to add to view number two. Remove this code from view number one. Then,
just hold your thumbs, hoping that the com...Two sided, fold over business card
I've been asked to create a telephone number list for our
family. There will be close to 50 phone #s,when you take
into account home, work, and cell nummbers. I'd like to
make a double size high business card that could be folded
over. I would like to be able to fill up both sides of
the card. The problem is, I have quite a bit of info that
needs to fit into a wallet.
The question is.....what software would I use to do this?
I have Office 2000 pro, so I thought I could use Excel,
Word, or Publisher. I also have Microsoft Home Publisher
2000 and Avery Designpro as well. ...CWinThread, CWnd, WM_COPYDATA, IPC
I'm trying to use WM_COPYDATA as an IPC method between two applications (a
client and a server). I'd like the IPC to not bother the main GUI thread,
so I thought of having both the client and server apps have a CWinThread
with an invisible CWnd. Then, the client could send a WM_COPYDATA message
to the server CWnd, and the server could send data back to the clients CWnd.
Is this safe? I've never used a CWinThread before. I always use worker
How (where) do I construct the CWnd, and how do I make it not be a child of
the main gui?
Can a CWinThread me...Select two records then select the next two records
I am still somewhat a beginner at this access stuff but I have something that
I am sure can be done but I don't know how to do it. I am using ACCESS 2003.
I have a database with contacts with auto id, last name, first name, ect.
At my company we everyday we get together and pray for two of the contacts.
So I would like to have a query that can select two contacts and then somehow
next time I run that query I get the next two contacts.
I am thinking I need to make a form that selects two contacts and stores
them in a table? and then next time I run a query it can just add...Two ? from an Outlook newbie
Greetings I have two question I need some help with.
First: I am not able to find go to newsgroups at all in my Outlook 2003.
So I have to open OE to access newsgroups. But in Outlook 2003 when I
compose a new message and click on "to:" for addressing the email I get the
following error message. "Can't contact LDAP Directory Server (81)", then
when it opens the address book to select names it is set for opening the
newsgroups and not the contacts folder. I have to click on the pull down
menu to select the contacts folder. How can I eliminate the error messag...how can i relate between two columns in two sheets?
Question no too clear - you can use this space to give a detailed question.
But here goes:
On Sheet1 I can type formulas such as
If I type = and then click on the cell A1 of a worksheet called My Yearly
Totals, I will get the formula
='My Yearly Totals'!A1
Note that a sheet name having spaces get surrounded by single quotes.
Does this answer your question?
Microsoft Excel MVP
email address: remove uppercase characters
REMEMBER: Microsoft is closing the newsgroups; We will all me...Data Verification: Comparing Two Identical Tables in MS ACCESS
I am using Access for entering a large number of questionanaires and
other tests all by hand and in order to reduce errors I am using
manual first entry and second entry. I am looking for a way to compare
the records in each table against one another and be able to view and
edit the discrepancies. It would also be nice if there was a way to
limit the results to a specific record. Does anyone have an idea on
how it would be possible to make this happen in Access? I have tried
the VBA approach using some complicated code I found but it is
limiting and I would like to find a way to do it with mi...