Colouring in areas within a shape (Part 2)
Perhaps it would have helped if I'd actually typed something in before
hitting [Enter] but here goes...
This kind of carries on from my previous post about triangles, but, for
example, having drawn a line that vertically bisects an autoshape triangle,
is there any way in which I can colour the left hand side of my triangle in
one colour and the right hand in another?
Peter Rooney <PeterRooney@discussions.microsoft.com> was very recently
heard to utter:
> This kind of carries on from my previous post about triangles, but,
> for example, having drawn a li...Shared workbook increase dramatically in size
Using Excel2k3 and Win XP Professional some 7 or 8 persons are sharing
a Excel Workbook.
However, the workbook seems to increase dramatically in short time.
The file size went from 68 MB one day to 128 MB the next day. So what
I did was copy every sheets data and pasted it into a new workbook.
When finished the new workbook file was not bigger than 1.3 MB?
How is this possible? How can this be?
Help is very much appreaciated.
...hyperlinks in pub 2003 #2
I cannot get my hyperlinks to work on this site. I have another site that is
successful but for that one I did each page separately rather than as a
publication as this one is. I've tried just adding the hyperlinks to the
text and I also tried with html coding - neither worked. I've downloaded the
html files and the name_files in question to the ftp html folder. Can
someone offer any advise?
The hyperlinks in question are on the 'locate a consultant' page.
appreciate any help!
All the links work here but all seem to go to the...Moving Exchange 5.5 #2
I am having problems with my hardware and want to move Exchange onto another box. We currently have Exchange 5.5 sp4 running on Windows NT. I want to buy a new server and run Exchange 5.5 sp4 on Windows 2k. They will not let me upgrade the version of Exchange. Are there any white sheets or any links that could be suggested to handle this migration from an NT server to a W2k server?
best way to do this is to bring up your new server, joining the site, then
move all the mailboxes, and replicate all public folders...then see this
article about removing the first server...
http://support.microsof...Publish A Workbook Onto The Web, Then Access Using My Web Browser.
How do I access my spreadsheet, or workbook, on the web once I've saved it as
a webpage from the file menu? I've found that even though I've save my
workbook as a webpage, it does not have an http:// address which I can type
in my web browser to access the workbook from my home computer or from a
Should I have to sign up with an http:// service provider or can this all be
done from using Microsoft Office XP without going through a third-party?
You have to have a website first of all, otherwise, where do you want to host
"sigmad&q...Graph question #2
Quick query with regards to how data is read by a graph. I have a sheet
featuring the number of staff assigned to the call centre at 1/2 hour
points throughout the day. This data is stored in a sheet called 'Data'
and in cells D17, E17, F17 etc etc.
The data within this page is not very well presented as it is run
automatically from the system we use here so I have made a more
presentable table and graph. For the table for each 1/2 i simply
reference the cell in the data page so that all i have to do to update
the sheet week by week is paste fresh data in. Using =Data!D17 t...xsd.exe and the resulting cs classes.
I'm embarking on a c# based project in which I would like to make use of a
lot of XML including database access and using hte xml and .net tools as a
What I'm trying to understand at the moment is how to use xsd.exe and result
..cs files to mange the xml.
My XSD includes <sequence>s which have > 1 value. the cs produced renders
this as a single instance, though if I change this to an array (manually)
the deserialization works as expected (nice!). How can I tell xsd it SHOULD
be an array (I've tried setting maxOccurs, but this seems to...Move server between Admin Groups #2
We are going to be going through a reorganization soon and will need to move
some exchange servers from one admin group to another. I know there is not
a native way in Exchange 2003 to do this. Does anyone have ideas on how to
accomplish this besides a swing server to the new Admin Group?
Third party Software?
Our environment is 2003 Forest functional and domain level. Exchange 2003
On Tue, 3 Jan 2006 14:16:23 -0500, "Tim Kalligonis"
>We are going to be going through a reorganization soon and will need to move
Is there any problem in diabling Office 2003 in start-
up,it must take a lot of resources for a program of this
size. Most of my work is in photography and though I
would not like to be without Office, I only use it about
ounce a month.
theoldone <email@example.com> wrote:
> Is there any problem in diabling Office 2003 in start-
Of course not.
...Are there MFC subclasses that give a different "look and feel" to the UI?
I was wondering if there are free implementations of MFC subclasses of
windows and controls that give you a different look and feel? I like
the Windows 2000 look, but it's quite a bit dated now, and the XP look
is hideous for my taste, so I'm looking for something new, more modern
looking, sleek. Thanks in advance for any suggestions.
See if this has something your looking for.
"Franco" <firstname.lastname@example.org> wrote in message
>I was wondering if there are free implementa...Save single worksheet from workbook using the sheet name?
I have had a search through some of the previous questions and I cant quite
find what I am looking for,
I have a master sheet which I split into seperate sheets using one of Debra
Dalgleishs macros all works fine.
However my next step is to save each of these sheets into seperate folders
using the individual sheet name.
As ever I hope this isnt too muddled a question!
Any help would be greatly appreciated
You need to copy it to its own workbook and save that
ActiveWorkbook.SaveAs Filename:= "myfile.xls"
H...how do I make place cards #2
I am trying to make small, tent fold table assignment cards, using a guest
list that I have created in Publisher (2003)- I want to use the 'name'
'title' and 'organization' fields from my guest list to create the cards, and
add a table assignment field, with one table/name/title/organization per
card, but am not sure what template to begin with- Do I need to select an
Avery product first and then create the place card document, then do a mail
merge or start from Word, or...? Thanks in advance for your help-
What are your dimensions? Will the card have printing on...short cut keys #2
I am using Excel and trying to assign a short cut key to a symbol, everything
I try doesn't do anything (example altQ, altG & etc)
what have you tried exactly?
"Carmen" <Carmen@discussions.microsoft.com> schrieb im Newsbeitrag
> I am using Excel and trying to assign a short cut key to a symbol,
> I try doesn't do anything (example altQ, altG & etc)
Actually what symbol are you looking for. . And in general
when you ask a qu...HELP! Need Access DB to show realtime changes in different location
I was wondering about how access refreshes it's data within forms and it
seems that it doesn't.
If i have a form open in one location on a network and update fields on the
form the changes are not shown on the form opened in another location.
(I.e. if 2 users are in the same form at the same time and one adds a new
record the other users form will not show this change).
Is there anyway that Access can be setup to show real-time changes over
Preferably without having to do a manual refresh by clicking a button or
All i want to do is show change...display result of formula
How do I make a cell which contains a formula display the result of that
calculation rather than the formula (it is formatted as "number" and I have
Peter Chadbund expressed precisely :
> How do I make a cell which contains a formula display the result of that
> calculation rather than the formula (it is formatted as "number" and I have
> tried "recalculating")
Change the cell format to 'General'.
Redo the formula.
Change the cell format to 'Number' and apply your display preferenc...What are the different methods of representing numerical data?
Can someone answer my questions "What are the different methods of
representing numerical data"?
"Excel Problem" wrote:
> Can someone answer my questions "What are the
> different methods of representing numerical data"?
Sounds like a test question. What's the context? Is it asking about
numerical formats? Or is it asking about date v. time v. other numerical
(Which really is not "different methods" per se. All are floating-point aka
real numbers. But the test might be asking for the specifics of date and
time rep...xml edit #2
I am trying to edit an xml receipt in notepad..whenever I try to save I can't
save as a xml file ..it wants to save as a text file..How can I save as a xml
You can just change the extension manually after you save it. Example - File
saves as "report.txt" Rename it to "report.xml" and that's all there is to
Try doing a Ctrl+S to save it. It should save it as the name it opened.
Are you using a Notepad replacement program? Help | About | should say
Get Secure! - www.microsoft.com/security
Yo...After 12.2.4 update, cannot open some Word docs with Open passwords
Operating System: Mac OS X 10.5 (Leopard)
After installing the 12.2.4 Office update, I am unable to open some Word files that I had password-protected with an Open File password. How can I open? Thanks
Basically, "you can't".
Sorry, the other passwords are crackable, but "Password to Open" is
effectively the encryption key. The entire file is encrypted, and unless
you have the correct password, you can't get it open.
However, are you sure you are not attempting to open files that were
password-=protected on the PC? ...Integrating Great Plains 8.0 and CRM 1.2 and Windows Small Busines
Integrating Great Plains 8.0 and CRM 1.2
I run a Windows Small Business Server 2003 Premium box along with a Windows
Server 2003 Standard box used for my Great Plains 8.0 and SQL 2000. I’m
considering introducing CRM 1.2 Professional into the mix. From a hardware
stand point I know I’m fine all around. I’ve been researching how I should
configure CRM and am a bit confused. The info I’ve found in KB887153 states
“When you install Microsoft Business Solutions CRM Integrations for Great
Plains 7.0, 7.5, or 8.0, Microsoft BizTalk Server is also installed. However,
BizTalk Server 2000 and B...JPG Files #2
Just installed Outlook 2003. Can no longer view jpg
files...either those sent to me or ones I try and attach???
Have cleaned out my temp internet
Make sure you have a default program set for opening jpg-files. Rightclick
the file from within Windows Explorer nd choose Open With... and make sure
you select to always open that file with the selected program
You probably had set Microsoft Photo Handler as thedefault program which has
been replaced by Picture Manager.
Tips of the month:
-Cre...Cannot close opportunities #2
I upgraded from CRM 3.0 to 4.0
We encountered issues with SQRSS - I had to uninstall and reinstall SQRSS.
I am now encoutering issues when closing a new opportunity it error out
throwing an Exception of type "System.web.HttpUnhandledException'
[NullReferenceException: Object reference not set to an instance of an
at Microsoft.crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
at System.web.UI.Page.ProcessRequestMain(Boolean includesStagesBefore
A...Outlook 2002 Address Book #2
New entries do not appear in address book contents list.
Thought it might be a space problem, but have deleted all
extraneous data (i.e. deleted items. However, when I try
to re-enter the contact, Outlook asks if I wish to
replace the earlier entry for the same contact. Any ideas?
Explain more accurately what you mean. Where are entries not appearing that
you expect them to? Are you selecting the correct Contacts Folder from the
"Show names from..." dropdown?
"Lulu" <email@example.com> wrote in message
I presently have an XY line chart showing asset price over time. Pretty
X Axis - Time Scale
Y Axis - Asset Price
I would now like to add an additoinal series showing the volume of
assets traded, ideally this would be as a bar chart sitting
"underneath" the asset price on the chart. They would share the same X
I have added another series, but this simply displays the volume traded
as another line, and even when this is set to a secondary axis the
scaling makes this unworkable. i have adjusted the scales of both,
still this does not make it workable, i want the series...SK 40175 Tuff-1 1/2-Inch Drive 15-Inch Reversible Ratchet
Best deal: http://thediscounfinder.info/index.php?id=B0009U5RRM
Item #: SKT40175. Features & Benefits:Tuff 1(r) Ratchets 72 tooth head design delivers a short 5" stroke for use in tight areas.17 teeth engage when torque is applied to provide a strong grip without slippage.Thumb falls naturally into position, giving instant control with one hand.Easy to reverse, 4 point cap.SuperKrome plating for long tool life and maximum corrosion resistance.Description: 15" Reversible Tuff Customers also search for:...Percentage difference calc that knows the largest figure
I have a calculation in cell A3 which looks at the content of Cell A1 and
Cell A2 and then works out the difference between both as a percentage
Cell A1 = 100
Cell A2 = 10
Cell A3 returns the difference as being 90%
My simple calculation in Cell A3 is as follows =(A1-A2)/A1
Cell A3 is formatted to give the answer as a percentage to 2 decimal places
The above works fine as long as the number in Cell A1 is greater than the
number in Cell A2
If the number in A2 is greater than the number in A1 then my calculated
answer is incorrect
Cell A1 = 10...