Excel window keeps changing
I have a weird problem on my home computer while using
Excel. If I don't use the screen for a few minutes, the
Excel window shrinks to about a fourth of its size. So I
have to click it again to either Maximize or resize to
about 90% full size, which I prefer using. It is by no
means a fatal fault, but verry annoying!
...Sales Process #2
I have a problem with the opptys/sales process.
In the report "Sales Pipeline --> show all" I get all opptys with the sales
stage "not specified".
Now I am trying to set the sales process and the stepname field by the
workflow, but now I cant see this opptys in the report...
...Handling of savings accounts and 401k accounts in the budget
I noticed that Money treats money that I contribute to a 401k account or
transfer to a savings account as an expense. Basically, the more I
contribute, the worse my budget looks. Is there a way to prevent this from
Right now, I exclude transfers to my savings account from the budget and it
solves the problem, however, I shouldn't have to manually do this each time.
For 401k contributions, I cannot find a way to do this.
Why does it show up as "an expense" (what Category???) instead of something
like Transfer Out of Budget Accounts? The 401k cash account sh...Sometimes have to use "Rebuild All"
I have never noticed this before, but in this project I am working on right now, I made some changes and hit "F7" like normal, but it didn't detect the changes and didn't compile the new code. So for this one file I keep having to do a "rebuild all". Any ideas why this is happening and how to fix it?
>I have never noticed this before, but in this project I am working on right now, I made some changes and hit "F7" like normal, but it didn't detect the changes and didn't compile the new code. So for this one file I keep having to...FileNotFound returned by Bitmap::Save() when saving to stream
I have a little chunk of code which is supposed to take a bitmap image and
save its PNG encoding into a block of memory. The problem is, I keep getting
a FileNotFound error back from Save(). If anyone has any ideas, I'd love to
Here's the code (more or less) in question; there really shouldn't be much
to it, I would have thought:
Allocate an IStream object to write the data into a global
memory block. We indicate that the handle to the underlying data
will be freed when the stream object is released.
VERIFY(S_OK == ::CreateStreamOnHGlobal(nil, True,
static_c...Unable to save password in Outlook 2003
I cannot seem to save my "network password" for Outlook 2003. I tried
everything I can think of. I tried editing the registry. I use XP. I try
going into Control Panel, go to mail and go thru the process there
and....nothing worked there. I uninstalled Office the reinstalled
it.....nothing! I even went as far as unistalling my internet software,
still...nothing! Someone told me that XP will not save passwords. My
Outlook express works fine. Someone HELP!
I also had this issue in Outlook 2003, but also in indows Live Messenger and
Internet Explorer 7.
I spend hour...what encoding does system.xml.xmldocument.save(string path) use to save the xml document if there is no <?xml... in the front of the xml document?
what encoding does system.xml.xmldocument.save(string path) use to save the
xml document if there is no <?xml... in the front of the xml document?
> what encoding does system.xml.xmldocument.save(string path) use to save the
> xml document if there is no <?xml... in the front of the xml document?
UTF-8 is the default encoding.
Oleg Tkachenko [XML MVP, MCPD]
http://blog.tkachenko.com | http://www.XmlLab.Net | http://www.XLinq.Net
utf8 i suppose would be default
"Daniel" <firstname.lastname@example.org> wrote in message
news:e8#...mail problem #2
i used sbs03. i had an external pop3 server. i used pop3 connector for
connecting to external pop3 mail server and routed that mails to local
exchage mail boxwes. it working fine when i retrieve mails.
i registered an domain name as example.com
my exchange server domain is ns1.example.com
when i registered domain i got email address like. email@example.com
in my exchage i had the mail id as firstname.lastname@example.org
when i am sending mails from my exchange outlook it is going as
email@example.com address. then when a person who got my mail
replies me. my emailid is firstname.lastname@example.org...change resolved case form
I need to change the form that appears when a case is
resolved. Is there in easy way to do that or do I have to
edit the file directly.
Anything that the Customization doesn't support (which in
this case it doesn't)... the only other option is SDK (at
least its possible or wait until future versions/3rd party
>I need to change the form that appears when a case is
>resolved. Is there in easy way to do that or do I have
>edit the file directly.
...sorting by date #2
I am having trouble sorting a table by date. When I choose to sort th
column by date - it sorts it alphabetically by date - i.e. with Augus
How can I have Excel sort chronologically, when the date include
month, day, yea
Message posted from http://www.ExcelForum.com
It sounds as if the dates are formatted as text. You can change this to an
Excel date value by inserting a helper column and using the following
formula (assuming your dates are in column A:
and copying down. Excel will then recognize the values as date values, not
text, and will sort chronol...Save and save as
I am looking for some help with a macro, I need to disable anyone from
saving a file or save as and also disable the prompt if the close button is
pressed you get an option to save the file then, I need to disable all of
these, also have a pop up box to warn that save as been disables when a user
tries to save the file fro save and save as.
Can anyone help me with this. I am using word 2003
Once you give someone access to a document, you have ceded all control over
it. You can however stop them from overwriting the original file by making
the doc...Saving Images
When I right click to save an image in an email, it will only save as a .bmp.
I need to use it as a .jpeg or a .gif. How can I fix this?
Angi <Angi@discussions.microsoft.com> typed:
> When I right click to save an image in an email, it will only save as
> a .bmp. I need to use it as a .jpeg or a .gif. How can I fix this?
Clear your internet explorer temp file cache.....go to control panel,
internet options, and choose 'delete files'
"Angi" <Angi@discussions.microsoft.com> wrote in message...Changing views in a CSplitterWnd
I have a CSplitterWnd in a multiple document. I need to be able to changes
views of type CScrollView in one of the panes in a static splitterbar. Is it
possible to change them without destroying and creating them every time? I
found some examples, but it seems they work only for FormViews.
Why not hide the previous view and (create) show the new one. If I was
doing it I would create the intial one, and when I would need to display a
new one, hide the old view, I would check to see if I have created one of
the new ones yet, if not create the new view, if so simply sho...how do I change the default name of a column from numbers to lett.
my default used to be column a, column b etc, somehow it has been changed to
column 1, column 2 etc. how do I change it back? Because of the default
change it changes my formulas to sum(R - C etc.
In EXCEL 2007 try the following:-
Office Button / Excel Options (lower right hand side) / Formulas (2nd option
down on left hand side) / Working with formulas (2nd option down on right
hand side) / make sure that R1C1 reference style is not selected (that is, it
does not have a green tick in it)
If my comments have helped please hit Yes.
"mac" w...Date Question #2
I am creating a worksheet that will last specific dates in column B. In
Colum C I want it to just list the month. There is going to be about 20-100
lines for each day, so i guess i want to use a formula that says if b6 =
1/15/2006 then in column c6 put January, etc. Is that possible?
Try this formula
and format cell as "mmmm"
daddylonglegs's Profile: http://..."Unattainable" savings goals
I've learned to mostly ignore it, but it drives me
batty. I have a particular loan with a goal to pay it
off by 7/4/04. The loan balance is 14,000. I have
marked a savings account to be "used for budgeted savings
goals." I deposit $1300 per month into the account which
has a balance currently of $13000. Money 2K4 says that I
cannot reach my savings goal. What can I do to help fix
this? Any feedback would be appreciated!
...Saving default tabs
I can't seem to get a change in the default tab setting to
When I reopen publisher the tab setting reverts to .5
which was original default.
I'm I the only person who is having this problem? I'm
using the 2003 verson but had the same problem with 2000.
Why not take the default page, set the tabs you want and save it as a
template with a file name of,
"My Very Special Tabs Settings for Future Files.pub"
(jerking your chain a bit<G>)
Then when you want to create what you want, use your created template file
and when your pub file is what you want, do a Sa...trendline #2
I am trying to fill in the blanks here and come up with a graph and trendline
forecasting sales in $.10 increments when I have history of sales at .99,
1.49, 1.99, and 2.49. Obviously as the price goes up, unit sales come down.
So how can I forecast what might be sold at all these price points.
Thanks in advance.
Arrange the data with the known values in A1:B4
An XY chart trendline shows th...Save to unProtect a Document?
Our company has word documents that we use as templates on a fileserver. How
could I protect the documents so that when they open them, they dont make
changes to the server version, but save their OWN version and do what they
First of all, make use of true *template* files (with the *.dot or *.dotx
extension). Also, assign the template files the read-ony attribute.
Microsoft Word MVP
"Chris" <Chris@discussions.microsoft.com> wrote in message
> Our company has word docum...Exchange 2007 And Daylight Savings Time Update
Is there a patch I need for Day light savings time and Exchange 2007?
No CDO patch required (no equivalent of KB 926666). However, the Windows
Server 2003 OS will required KB 931836 time zone update and Calendar-items
in 2007-hosted mailboxes created using old DST 2006 rules will need to be
MVP - Exchange
NEW blog location:
"D303M" <D303M@discussions.microsoft.com> wrote in message
> I...Transferring track-changes
Is it possible to transfer track-change comments from a word document to an
excel document? Need to document the track-change comments as a separate
document, but don't know how.
See the following article that includes a macro that will extract all the
track changes to a Word table within a new document, obviously this table can
then be copied into Excel.
I have used this myself several times and after a few minor cosmetic changes
got a good result.
If you are not used to working with macros, see the helpfu...Save csv format to dbf format
I have a .csv file with 13 columns of data opened in excel. I make a
few changes to a field and then want to save to .dbf format.
After saving as .dbf when I open the file only column 1 data is
Any insights into where the rest of the data goes? Why does the data
mdelasaux's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28889
View this thread: http://www.excelforum.com/showthread.php?threadid=486365
Try using Notepad and open your .dbf...Coloured rows #2
Max & Don
Thanks for your assistance. I have opted for the variation provided by
Max as it worked first time. Thanks again.
> A variation of Don's suggestion ...
> If you have it set-up with the days in A2 down, i.e.:-
> Press CTRL+A to select the entire sheet
> Click Format Conditional Formatting
> Under Condition1, make the settings as:
> Formula is| =OR($A1="Sat",$A1="Sun")
> (Note that the dollar signs are important!)
>...Counting Cells #2
How can I tally values in different cells that do no fall
into a specific range. For example, I would like to tally
all the values in E2,I2, L2, and P2 which meets a certain
criteria such as containing the number "3". While these
numbers do fall into the range C2:R2, I don't want all the
values for the other cells which I am not interested in.
So, how can get excel to isolate the cells that I am
interested in and giving me a value?
where NCrange refers to:
=Sheet1!$E$2,Sheet1!$I$2,Sheet1...Linking Word and Excel #2
I have a Word document with a large number of tables
linked to cells in an Excel spreadsheet. The tables in the
worksheet are in the same order as those in the Word
document. I would like to insert a new table between other
tables linked to the Excel spreadsheet but when I insert
the new table between the others in the Excel spreadsheet,
it invalidates all the other linked information. I take
this to mean that the links are not absolute references.
Is there any way to do this without having to reconstruct