Solving an equation in a cell
I have an excel spreadsheet that has a list of numbers
that are 55% of a total that is unknown. Is there a way
I can create a formula to figure out the total in a cell?
26 - 55% of total
My equation is:
..55 * x = 26
I need to solve for x.
Is there a way to solve this in a cell?
Answered in Worksheet forum. Please don't multipost.
"Mark" <email@example.com> wrote in message
> I have an excel spreadsheet that has a list of numbers
> that are 55% of a total that is unkn...Excel 2003 Slowness problem in Windows XP
I wish to get your help to solve the problem happened in our organization.
A group of users who are heavy user of Excel, complaint that after computer
upgraded to Windows XP SP1 (Pentium 4, 256MB Ram) and Office 2003 STD SP1,
excel file tend to be slower when the computer running Winnt, office 97.
After study and find out not all the excel file opening are slow in their
PC. These most frequently access excel files that causing slowness are
either too many formula, macro enable or too many sheet. File side about
2MB-4MB. I have advised them to reduce number of sheet, form...Problem solved
at first I want to thank you for the answers. I mentioned in my first
posting that I need something like a redirection of messages to another
class. I found the solution and made it like this:
I call SetWindowLong with the handle to the window that normally
receives the messages and gave another fn (a replacement) for the
WindowProc (which is located in the other class) to the routine.
m_pWndProcOld = (WNDPROC)::SetWindowLong(CCaptionButton::m_hWndCap ,
cobuser at gmx dot de
cobuser at aol dot com
--- XCr...Is office 2003 compatible with windows 7 professional 32 bit?
Hi every body
I was wondering whether office 2003 is compatible with windows 7
professional 32 bit or not?
> Hi every body
> I was wondering whether office 2003 is compatible with windows 7
> professional 32 bit or not?
Yes it is
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"Al" <Al@discussions.microsoft.com> wrote in message
&g...Office 2004 update failure
Operating System: Mac OS X 10.5 (Leopard)
I have a Mac iBook G4 with a recently installed OS 10.5.2 (i.e., Leopard). During the last month or so, when I've been prompted to update my Microsoft Office 2004 by my OS, the update seems to download nicely, but when the installation process commences, I receive the following message:
"The installer could not locate the correct version of the software required to install this update. See the Read Me file included with this installer to determine if your software meets the requirements for this update."
Assuming my system ...How to know if a window is shown (not hidden)?
To know if a window is shown (i.e. not hidden), should I use
SW_SHOWNORMAL like the code below, or SW_SHOW? Besides, do I also need
to check SW_SHOWMAXIMIZED and SW_SHOWMINIMIZED too?
if (placement.showCmd == SW_SHOWNORMAL)
Thanks for any help.
Take a look at the IsWindowVisible() ( or CWnd::IsWindowVisible() MFC
member function ) API.
Check Abdoul [VC++ MVP]
"May Young" <firstname.lastname@example.org> wrote in messa...Outlook XP Contacts to OE6
I need to export my Outlook contacts to my OE6 address book but it is
proving to be a bit of a problem. When I try and get Outlook to export the
contacts as a CSV file it tries to install the translator but it keeps
coming up with an error saying it can't find the required files on the cd
(PROPLUS.MSI) which I am pointing it to...
Any other ways of getting my Outlook contacts into my OE6 address book??
Thanks in advance.
Did you try importing to OE6 from Outlook (ie using OE6
to control the import?
2 . try exporting to excel and th...Save or Update command
I have looked through this discussuion group for how to create an update or
save button to use on a form. Apparently everyone knows how to do it, they
keep mentioning it in their posts but how exactly do you create it?
I have a form based on a query, based on one table.
The form has 30 fields that can be updated and right now the data entry
person is clicking on the next field to update the table. This works, but I
would rather have a button that she can use.
Ok Gurus, stop laughing and direct me to some help!
There isn't a need for such a button. Access "auto-saves&...How do I install outlook 2000 on Windows 7?
I have had multiple problems getting Outlook 2000 to work on a brand new
System 7 machine. To my knowledge, it has no other versions installed, yet
each time I launch, I get the setup screen again that says there is another
version. I can receive mail but when I try to send it says I can't because
it can't find the WAB DLL. I have uninstalled and reinstalled with the same
result. (Word, Excel and PPt work fine.)
Outlook2k is not compatible with Vista let alone win7
It may work if you setup outlook2k in workgroup mode, but not neccessarily
without proble...updating summary account balances for prior years
We are finishing the implementation of GP 10.0 at this new client site, and
I have a question on integrating the summary account balances for prior years.
The client has fiscal years set up for 1995 to 2008. We are going to bring
in from the client's old accounting system just summary account balances for
1995 through 2006. We will bring in detail transactions for 2007.
After bringing in the summary account balances for each of those prior years
through 2006, I will run the GL year-end close for each year in order to
update the beginning account balances for each succeedin...close window disabled
When I open up an excel document, the close window (X) button is greyed out
(disabled). What might be causing this.
Windows XP (SP2)
Excel (office 2000)
mfc)i create a class , its derived from CDialog class. A main window
has one button .i click the button ,then the modeless dialogbox is
open. i minimize the dialogbox ,it appear the top of the status bar.i
want it appear into the statusbar.how it is possible.please explain
with sample coding.
open modeless dialog:(button click coding)
CDilog constructor:(Derived from CDialog)
CChatting...Temporary Form with 2 Sub form Update Main Form And its Sub form ?
I have 2 table both are exactly same
PatientRecordTransTb And PatientRecordTb
I know many programmer don’t like TempTb, but in my case I don’t trust some
one to mess
with my Main record table. So simple solution is make tamp table and after
review I click to transfer all records from temp Table to main Table So I
have two forms .
PatientRecTransFm record sources = PatientRecordTransTb
PatientRecordMainFm record source = PatientRecordTb
PatientRecTransFm has 2 button AddRecord And Delete Record
Here is a short story of my code (NOT A Actual Code)
mySQLString = &quo...how to solve "Non-modal forms cannot be displayed in this host application"
I am trying to make a modalless form in VB6 that is compiled as an
ActiveX DLL. When i use VC6 to instance the activex DLL, my problem appears
"406 Non-modal forms cannot be displayed in this host application from an
ActiveX DLL, ActiveX control or Property Page."
I have my form in modalless style in VB6 and they should be instanced in VC.
Does anyone know how to get this to work ?
Nish [VC++ MVP]
"arbidol" <arbidol@tom...Cant access updates
I have a system that I know has some sort of virus or is in some way
hijacked but I can't find the problem. The only way I know it is still
hijacked is that I can no longer access Windows updates. I can try through
control panel or by going directly to the site. Always says page cannot be
This is a Windows XP Pro SP3 system. I've run full scans with Malwarebytes
and Avira. Have also run HijackThis and fixed anything that seemed
suspicious. This is the second system this has happened to me on. The last
one I gave up finally and just reinstalled t...Modala dialog windows
I just wonder if you can mention any modala dialog windows in windows
A modalt dialog windows means that you can't continue without answer the
modala dialog window.
If you are talking about a system modal dialog box, they don't exist
"Tony Johansson" <email@example.com> wrote in message
> I just wonder if you can mention any modala dialog windows in windows
> A modalt dialog windows means that you can't continue ...Money will not update balance on 1 checking account
I have set up Money on computer with Vista.
When I go to update the balances they all update except one checking account.
My other checking account and credit cards all update.
I have put in adj. balance but still on Money records I have a zero balance.
...Getting RichEdit's TOM/ITextDocument by its Window Handle?
I cannot get the sample code from microsoft's example here of looking
up in the running object table by window handle for a RichEdit's
(scroll midway down to subtitle: Interface from Running Object Table)
I suspect the example code is in error as CreateFileMoniker makes no
mention of working with a windows handle number passed as a hex string
as the example shows...
Can anyone confirm it works or doesnt work or tell me how to
accomplish this another way?...Canadian Payroll Tax updates #2
Just a heads up...as I donot see it here...or on the KB
I just spent 3 hours updating 6 machines.....
Which actually only took an hour...then we had to convert our Canadian
Payroll files...then...Canadian payroll just disappeared from the users
install...although..when logging in as SA it would be available...
Seeing I have been running the Canadain Payroll for 5 + years now...and am
well used to the "bugs" with the yearend updates....I remember seeing this
error after an application version upgrade from 7.0 to 7.5...where no one
other then SA could run payroll.....and I spen...Explorer tries to write DLLs when searching Windows
When using 'My Computer' to Search for any file name in the C:\WINDOWS
directory, Explorer (not IE) tries to write a number of files. (Details at
It does this _only_ when searching C:\WINDOWS. I tried searching other
directories and it keeps quiet.
So a number of questions arise:
* Is this expected behaviour? I certainly would not expect search -
essentially a read only application - to be writing files.
* Is this indicative of some virus? Antivir does not think so, but a
sophisticated virus can defeat any virus checker.
* Is there a cure?
I am running ...IMF update not detected in Windows Updates
I have Exchange SP2 inside SBS 2003 and can not get Windows Update to detect
I have added the key ContentFilterState (1) in
Hkey_Local_Machine\Software\MicrosoftExchange and restarted the SMTP service
I have applied the IMF checkbox in the General - Advanced properties for the
SMTP Virtual Server and restarted the SMTP service.
When I run Widows Update, no updates are detected. I understand the key
ContentFilterState with a setting of (1) is supposed to trigger the update
from Micrososoft but Windows Update seems to be missing it.
Any suggestions what next? I have had f...need help on updating figures
i've attached my file.
i hope it makes it easier to understand and hope you can help me
minxy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1533
View this thread: http://www.excelforum.com/showthread.php?...Windows XP Home Sticks going into Hibernation/standby
It just sticks on the blue screen going into hibernation or standby when I
chooseto put it in.
Any ides would be helpful. Not sue this is the correct thread as wll.
On Jan 19, 7:10=A0am, Bob <B...@discussions.microsoft.com> wrote:
> It just sticks on the blue screen going into hibernation or standby when =
> chooseto put it in.
> Any ides would be helpful. =A0Not sue this is the correct thread as wll.
Which blue screen is that - an empty blue screen or does it have some
words on it?
Has it ever worked before and what do you think has changed if it used...request to solve my problem
hello friends this is vijay,i got a problem while doing my project
based on vc++ (i.e)"How to implement Fit Window feature in VC++6.0 in
an MDI Application" if any of you got any idea about that please do
reply me with the proceedure.i will be waiting for your reply
hello"vijay",do u min resize the window 2 feet content or way around other?
Can u say which kind of view u use?Maybe even a snippeterooby of code.
"vijay" <firstname.lastname@example.org> wrote in message
I have a main form which has combo boxes which pull from a table to fill in
Sometimes these tables need new data added. I have added a command button
which opens a second form where the list can be updated.
When I close the second form the new choices do not appear in my combo box
unless I close and re-open the form.
Is there a way I can do an automatic refresh or update without having to
close the main form?
Thanks in advance
After you have updated the table behind the list,
you can requery the main combo form like this: