I want some set of questions on Word-2007 to check competency level of the
user. Please help.
Ananta, please refer to my other 2 postings: just check out the WORD part.
If my comments have helped please hit Yes.
"Ananta Gupta" wrote:
> Hello Everyone,
> I want some set of questions on Word-2007 to check competency level of the
> user. Please help.
> Ananta Gupta
> Ananta, please refer to my other 2 postings: just check out the WOR...Getting the ROW of a COUNTIF result?
For a cyclingclub i want to make a simple statistic of the members and how
many 1st places, 2nd. plcases and so on, they have had during the season.
I have a excel sheet with all races in a season. In the 1st. coloum i have
the name and in the second coloum the final position in the race.
xxxx xxxxxxxxx 3
yyyy yyyyyyyyy 1
zzzz zzzzzzzzzzz 5
yyyy yyyyyyyyy 1
The statistic i want to make:
Name Pcl-> 1 2 3 4 5 6
xxxx xxxxxxxxx 0 0 1 0 0 0
yyyy yyyyyyyyy 2 0 0 0...I want more!
I need to extend a form that aleady has some 100 lines. For instance, one
column has the date, but only until tomorroq. How do I create more lines
based on the same formula?
I usually select the last row in the range and copy it down a few rows.
If you're using xl2003, you may want to look at Data|List.
And if you're using xl2007, this feature has transformed into Tables.
(Data tab on the ribbon|Data tools Group|What if Analysis|Data table)
> I need to extend a form that aleady has some 100 lines. For instance, one
> column has the da...How can I get a MFC DLL with NO own CWinApp/AfxGetApp() ?
I have a DLL which uses MFC and is compiled with /clr (because it contains
classes which must be callable from C#).
That works well when being used from a C# application by calling :
if (!AfxWinInit(::GetModuleHandle("<dllname>"), NULL, ::GetCommandLine(),
0)) return false;
so that the DLL has its own App-Object/State which is initialized by the
above source code.
But now I also want to use that DLL in a C++ MFC application which already
has a CWinApp object; so I would like not to establish a new one for the DLL
but use the one...How do I get the sum total of all sheets in a workbook?
I have a 52 sheet workbook, all sheets have the same number of columns and
data. What do I need to do to arrive at the sum total of all these sheets
without printing them all out and adding them up manually? Thanks in advance
for your assistance.
Ortega, try something like this
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
"OrtegaGroup" <OrtegaGroup@discussions.microsoft.com> wrote in messa...XML serialization problem #2
I'm a .NET beginner and I've got a problem on a program where I try to do an
I get the following error :
"An unmanaged exception of type 'System.IO.FileNotFoundException' occured in
Additonal information : the file or asssembly named n9gu4-bo.dll or one of
its dependencies cannot be found"
Here is the code :
(I've uploaded the complete project at this url
public class Form1 : System.Windows.Forms.Form
TextReader reade...I don't want a page of the same label, I want one of each...
I can't find where to tell Pubisher that I want one of each label and not a
page of each label.
I'm using Publisher 2003 (Office 2003)
I see a post that says to enter "<<Next Record>>" but Publisher doesn't see
this as a field, just as text.
This can't be that hard, but I can't figure it out...
Any help would be appreciated.
I see that it prints correctly, but the print preview displayes it wrong....
I think I have it figured out...
"Kelvin" <email@example.com> wrote in message
news:OSpLwThUIHA.5508@TK2MSFTNGP04.phx....Text want wrap in text box
I can't get the text to wrap in a text box, word wrap is set to true, I put
some text boxes on a sheet today and the text will not wrap, I did this
yesterday and it worked fine, I can copy the ones from yesterday and paste
them on a new sheet and they work, any ideas? I have rebooted but this did
not help. Using Excel 2000 (9.0.6926 SP3) Thanks Paul B
If you're referring to a Control Toolbat text box make sure that the
MultiLine property is True.
"Paul B" <firstname.lastname@example.org> wrote in message
news:%23ovLUkuLEHA.2456@TK2MSFTNGP12.phx.gbl......Cannot access office out, getting POP3 Reporting Error 0X80042108
Hi there, i understand MS made some changes and now i am locked out from my
MS Office Outlook. I get a POP3 Reporting Error # 0X80042108.
The server does not recognize me.
Is there any instructions on how to set or re-set this?
Is there any REAL PERSON i can talk to for FREE Tech Support???
Thanks, Ray @ email@example.com
The changes were to how Outlook pulls Hotmail.
Verify your settings against this:
"Ray" <Ray@discussions.microsoft.com> wrote in message
> Hi there...Will illegal immigrants get deported?.........Of course not.....................
Our politicians just wanted to blow us some
sunshine. Get the details from The Expert:
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com ***
...Want to Add more Sub description Field
How I can add more sub description field like 1,2,3,4,5
You have only limit up to 3 fields in RMS 1,2,3 sub-description also you can
use the extended description and there is main description for the item. so
Altogether you have upto 5 description limit and I think that is enough. Let
me know if this won't fulfill your requirements else use the Item Notes for
Rate if like
"Saleem Suri" wrote:
> How I can add more sub description field like 1,2,3,4,5
> Saleem Suri
...I want to add a sound event when the cursor bumps left margin
I want to know (via an event sound) that my cursor movement has bumped the
left edge of the spreadsheet. I am entering thousand of rows of data, and it
would help if there was a event sound when I returned the cursor to the left
edge. I have this feature in 123, and find it helpfull.
Put this in the sheet module:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static ColOld As Integer
If Target.Column = 1 And ColOld > 1 Then Beep
ColOld = Target.Column
mvpearl omitthisword at verizon period net
"m...Can I get Outlook 2007?
I have Office 2007, but Outlook Express. Am I able to get Outlook since I
have Office 2007? If so, how can I get it installed?
Depends which version of Office 2007, H&S doesnt feature Outlook
Do you have any other Office version installed?
"Marla" <Marla@discussions.microsoft.com> wrote in message
>I have Office 2007, but Outlook Express. Am I able to get Outlook since I
> have Office 2007? If so, how can I get it installed?
How can I tell? Where do I look? The menu items show Word, Pow...Excel wants to create a page break in every cell!
After saving revisions in an Excel worksheet, I get a popup message that
states "Margins do not fit page size". After clicking "ok" (because this is
my only choice) a page break is automatically created in ever cell. At
times(depending on the sizeof the work sheet) it can be over 100 pages with a
page size 14% or smaller.
Why does this happen, and how can I avoid it?
I saw this suggestion in a different forum.
Try closing excel.
Clean up your windows temp folder
Windows start button|Run
and hit enter
Clean all those files that you ca...How do I get my email notifications to show?
I have all of the appropriate boxes checked under options, but when I minimze
outlook, my notifications do not show up when an email is sent. Is there
any help for that?
"beezer" <firstname.lastname@example.org> wrote in message
>I have all of the appropriate boxes checked under options, but when I
> outlook, my notifications do not show up when an email is sent. Is
> any help for that?
Outlook doesn't present a notification with its tray icon on e-mail
*sent*. I...I get a #VALUE! msg.
I'm adding two columns,
first- A7:A125 with the formula in A126
second- E7:E125 with the formula in E126
Then I divided the results for a percentage in a cell at the top E3.
First question: Can I do this: =SUM(E7:E125)/(A7:A125) I mean obviously I
can't because I get this error/if I can it will save me a bit of work... am
I missing something?
Second question: cell A126 has a total that I want to use in every calc as I
copy it from E3 to F4 etc....
WTB: I BUY SOFTWARE - CHECK AROUND - YOU PROBABLY HAVE SOME OF THE
BELOW TO SELL TO ME.
SEE A LIST OF SOME OF THE SOFTWARE THAT I AM BUYING!
I AM BUYING ALL OF THE BELOW. THE MORE QUANTITY THE BETTER!
I am looking to buy large quantities of Windows 7 Professional Upgrade
Dell DVDs with unactivated COAs included in a SEALED package
I am looking to buy quantities of SYMANTEC NORTON ANTI VIRUS, NORTON
INTERNET SECURITY AND 360 OEM AND RETAIL BOXES
I will buy 2010, 2009, 2008, 2007 and 2006.
If you have good quantities setting around and no longer need send me
detai...get/change and SY_User Company_Access_REL errors
I am testing a conversion from GP7.5 to GP8.0 and after the installation is
completed and all data is transfered and the nesessary scripts run I am
getting the following errors:
when signing in with regular user:
"A get/change first operation on table 'SY_Users_MSTR'failed accessing SQL
when signing in with the 'sa' account:
"SY_User_company_Access_REL'failed accessing SQL Data"
Any thoughts on what might be causing this?
Are you transfering the data from 7.5 to 8 or have you done a v 8.00
upgrade from GP Utils?
I dont recomm...Check boxes
Hi---I am setting up a form with various check boxes. I want to set up a
range of check boxes so if any of these boxes are checked, then one
corresponding check box if also checked. On the flip side, if none in the
range of boxes are checked, then the one corresponding box is also not
I hope this can be done with a formula or conditional formatting, instead of
a macro....if it takes a macro, whoever resonds to this question, please
explain in easy terms---I don't have a lot o fmacro experience.
A boolean checkbox reflects the TRUE / FALSE value of the cell it ...My OnVScroll is not getting called!
I have a dialog class with an OnVScroll handler that is never getting
called. My list box has the notify flag set, and I can't think of anything
else to try. Any suggestions?
What does gettting OnVScroll for your dialog have to do with a list box, and vice-versa?
A list box does not notify its parent when it scrolls. OnVScroll would be sent to a window
if the window itself has a scrollbar, either explicit or implicit, which has been
On Thu, 07 Apr 2005 00:39:19 -0500, Eric Adem <email@example.com> wrote:
>I have a dialog class with an OnVScro...Getting Shell Task ID from lost process
I am experiencing problems when using the Shell function in that
periodically the returned task ID connection is lost.
The external task/application launched via the Shell is still active,
but the task ID becomes invalid.
I seem to remember that somewhere in Access there used to be a way of
scanning all active processes on the machine and interrogating their
details in order to "grab" the appropriate process again. However, I
cannot remember the technique or the add-in that does this.
Can anyone remind me of the technique please?
I am using Access 2003 on Win...When repeating city want zipcode to populate
Making a data base of mailing addresses. Is there a formula to use to get a
zipcode to populate in a cell when a city and state is entered in two other
See help on VLOOKUP function.
Or go here for excellent help and an example workbook.
Gord Dibben MS Excel MVP
On Wed, 21 Feb 2007 08:05:32 -0800, jrw - esq. <jrw -
>Making a data base of mailing addresses. Is there a formula to use to get a
>zipcode to populate in a cell when a city and state is entered in two other
>...I want to know something about Visual Studio 2005
I want to know something about Visual Studio 2005
the size of it , and the System Requirements, who knows , please tell me.
Thanks a lot.
Ajay Kalra [MVP - VC++]
"fcvcnet" <firstname.lastname@example.org> wrote in message
> I want to know something about Visual Studio 2005
> the size of it , and the System Requirements, who knows , please tell me.
> Thanks a lot.
Thank you so much!
But I can not find the Visual Studi...Want Windows Mail to open my live.com mail
What are the server settings to have my live.com mail open in my Windows
To access Hotmail accounts with Windows Mail, you have to use POP3.
Use port 587 for SMTP (outgoing)
With the newer Windows Live Mail, it's much easier.
Windows 7 Ultimate 64
"Sue Ann" wrote in message news:e$a0jezMLHA.1868@TK2MSFTNGP05.phx.gbl...
What are the server settings to have my live.com mail open in my Windows
...How do I get Visio 2003 to update shapes from Visio 2000?
I have upgraded to isio 2003 and when opening drawings created in Visio 2000,
I get a message that says "The MS Visio building plan shapes in the drawing
must be updated to function in the current version of Visio."
When I click 'Yes", all the shapes are deleted. When I click "No", it opens
with the shapes intact.
Any way to point Visio 2003 to the Visio 2000 shapes?