Operating System: Mac OS X 10.5 (Leopard)
We use MS Office on both PC and Mac in our office and have massive problems opening up Office Documents on the Mac that were put together on PC's, the formatting gets totally messed up, how do I get around this ?
In article <firstname.lastname@example.orgR9absDaxw>,
> We use MS Office on both PC and Mac in our office and have massive problems
> opening up Office Documents on the Mac that were put together on PC's, the
> formatting gets totally messed up, how do I get a...How To Create UI Automation Test Suites for VC++ 7.2 Application
Envoirement -: VC++ 7.2
OS -: Win 2000,XP
As i can Develop UI Automation Test Suite For .NET Application
Plz Anyone tell me,Can I Develop this Tool for VC++7.2 Application ?
If yes ,How ? plz suggest me for it.
Fundamentally, this is hard. There are some commercial programs out there that do this,
but getting a test suite that works well, particularly in all resolutions, and is fully
scriptable, is a nontrivial problem (well, let's put it this way: I would not accept a
fixed-price contract to do this, and wou...Install Office X on 2 Desktops
I have recently purchased and installed Office X on my iMac (did not
register yet) I would like to know if I can also install same on my
new G5 and register at that time? I can uninstall from iMac if
required. Can I do 2 desktops in lieu of a desktop and a laptop?
Unfortunately installing Office X on two desktops is prohibited by the terms
of the EULA, and many people have posted here regarding the fact that on
many occasions doing this prevents the application from launching. You'll
need to uninstall the software from one of the desktop machines.
You have no limitations on product regi...setting up multiple email accounts #2
I followed the rules for setting up the pop3 and smtp
accounts for multiple mail accounts, but when I access
outlook express the additiona account does not recognize
the password I've asked it to remember. HELP!
KCB <email@example.com> wrote:
> I followed the rules for setting up the pop3 and smtp
> accounts for multiple mail accounts, but when I access
> outlook express the additiona account does not recognize
> the password I've asked it to remember. HELP!
Ask in an Outlook Express newsgroup.
If I want my chart to read from 50 to 100 instead of 0 to 100 How do I do
Be Nice to Everyone Everyday
Be Nice to Everyone Everyday
"jr" <firstname.lastname@example.org> wrote in message
> double click on the current chart axis values on the
> desired chart axis. You can set the scale in the popup
> >-----Original Message-----
> >If I want my chart to read from 50 to 100 instead of 0
> to 100 How do I do
> >...How do I chart date ranges with varying start and finish dates?
I want to create a chart that on one axis will show date ranges that have
varying start and finish dates. The other axis is a list of project names.
Example: Project #1, starts 5/1/05, ends 10/1/05; Project #2 starts 3/5/05,
ends 2/2/06, etc. I want a bar chart that I can sort. Any help is very
appreciated. : )
It sounds like you need to create a Gantt chart. Here are some resources
that might help:
----...Avoid plotting refferanced blanks as zeros in scatter plot graphs
I can not figure out how not to plot data that referances blank cells as
zero's. I have a worksheet that links to tables with data orginized by size
(mm) from big to small. This worksheet contains a scatter plot graph that
looks at all sizes in the table. Typically not all sizes have data. The
only way I can figure out to remove the zero values from the blank cells is
by manualy selecting these cells and clearing the content. I have tried
several attempts at differant logic ( if(isnumber(A1),A1,""), and
if(isblank(A1),"",A1) ect. and nothing seems to work. ...How to slant cells in Excel on top of chart at about 45 degrees
Trying to make a chart and slant cells at the top at about a 45 degree angle
with borders and still be able to type into it. Is this possible?
> Trying to make a chart and slant cells at the top at about a 45 degree
> with borders and still be able to type into it. Is this possible?
Try Format > Cells > Alignment Tab and set the Orientation to 45
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2...Can Line Chart Overlaps be Highlighted?
Can the overlap portion(s) of two lines in a chart be shown in a different
color, without having to manually draw a shape? I would like to show the
areas where Line A is above Line B as red, and the areas where it crosses
below in blue - is it possible to do this without manually drawing in shapes?
To some extent it depends how many times the lines cross. If it's just the
once then you can use area charts to provide the shading.
This may help if the used one line as a base line...how to compare 2 values in a report (Invoice Total vs Payments)
while running a report how would I set a message "out of balance" if
my invoice amount (Table 1 ) does not equal the value of my total payments
(table 2). If the values were the same then no message would be printed.
Create a new command button to check the report before you print it.
You will have to enter code for the button along the lines of:
If [Invoice Total] <> [Payments] Then
MsgBox "This account is out of balance"
> while running a report how would I set a message "out of balance" if
> my invo...Help me create sales chart based on state and quantity
We have a production report on excel. It shows the details for our clients.
Part of that data includes the state in which the client lives. We are trying
to create a chart showing the percentages of each state( so we know where the
most deals are closed)
this sounds like a job for a pivot table, using Average as the data
Or, depending on your version of Excel, you can use AVERAGEIFS (in Excel
2007) or calculate an averate with a combination of SUMIF divided by
To be more specific, it would help to s...Password protected #2
i have a spreadsheet is protected and requires a password...problem is
dont know the password and i need to edit the sheet!
Anyone got any tips....
Message posted from http://www.ExcelForum.com
Crack it by installing this free utility at:
>i have a spreadsheet is protected and requires a
password...problem is i
>dont know the password and i need to edit the sheet!
>Anyone got any tips....?
>Message posted from http://www.ExcelForum.com/
...Outlook Security Settings #2
I am trying to use Outlook security settings.
I have installed the settings precisely as described on
the MS site and the settings work perfectly for me and
one or two others but not for the rest of my defined
We are using Exchange 2003, Outlook 2003 and Outlook XP.
I cannot find any debugging or logging info anywhere and
am a little stuck as to what to do next.
Can anyone offer any ideas???
...Need disk # 2 for Home Publishing Premium 2000
The #2 disk of a (6) disk set in my Home Publishing Premium 2000 was
demolished in my CD drive. This is the setup disk and since the CD is no
longer available from Microsoft I need a copy badly. Is there anyone that
can successfully copy a #2 disk? I will be more than happy to pay anyone for
> The #2 disk of a (6) disk set in my Home Publishing
> Premium 2000 was demolished in my CD drive. This is the
> setup disk and since the CD is no longer available from
> Microsoft I need a copy badly. Is there anyone that can
> successfully copy a #2 dis...Hiding Column and Row Bars.
I know theres a way to costumize the way you view an excel page by hiding
toolbars, but is there a way to hide the rows and column bars just so all you
can see is the actual page.
E.G. is there a way to Hide the top bar that defines the colums "A", "B",
"C","D" and Rows 1,2,3,4,5.
Go to Tools>Options>View, there are a number of options you can play with
(remove nothere from the email address if mailing direct)
"tamato43" <email@example.com> wrote in message
news:7D1E5DEB-D6F2-47C8-95E2-2...time line in chart
How do I put a vertical line in a chart in excel at a given point? i.e.
I know this is too elementary, but go from here:
You have a scatter chart from A1:B6
(X A1:A6; Y B1:B6)
A 2nd source series is A8:B9
(X A8:A9; Y B8:B9)
giving you the a vertical line at X=13.
"jon" <firstname.lastname@example.org> wrote:
>How do I put a vertical line in a chart in excel at a given point? i.e.
----== Posted via Pronews.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.prone...Help on adding values to a bar chart
Here is my problem. I currently have a bar chart that has 8 X-axis
bars. I need to add 2 more to the X-axis. The labels for the x-axis
are based on cells within another spreadsheet, but are not consecutive
cells, they are spread apart. So when I go to add the two more cells,
I can only add one. When I click on the second cell to add it to the
list, all of the previous cells get unselected. I have even tried to
manually add these two values in. Is there a limit to how many values
can be on the X-axis? Please Help!!!
To select non-consecutive cells: select first cell, h...Having different gap widths among bars
Hi, I tried to 2 different gap widths among yearly bars and monthly bars. No success. Any resolution or a better way to handle this kind of presentation? Advice is greatly appreciated.
Do you want a bunch of years to the left, and a bunch of months to the
right? Put your months on the secondary axis, and include lots of
blanks in the beginning of the series data range, so the months pile up
toward the right. Include blanks at the end of the yearly series data
range to push those bars to the left. Right click the chart, choose
Chart Options, and click on the Axes tab. Check th...help with Excel Chart, Series name
I am using ORACLE OLE2 package to print a series bar graph in excel. I need
to rename "Series Name" that comes out in as a char in excel. By defual the
series are names as Series1, Series2, Series3,.....SeriesN. How can I access
the handle to "Series Name" which help me change its name. Any help will be
Manally, you do this with Chart - Source data - Series tab. There's a
series name box. Select the series to be edited in the drop-down at the
left first. It may have a cell reference currently in it, or you can...deleting rows #2
i have200 rows in sheet- there are lets say 100 rows the title shipping
i have another 100 rows with the title payments.
they are in mixed in and not grouped together otherwise i could highlight
them all together and delete-how do i delete all the ones that say shipping
without clicking on each individual row. I am on excel 2007 trial
> i have200 rows in sheet- there are lets say 100 rows the title shipping
> i have another 100 rows with the title payments.
> they are in mixed in and not grouped together otherwise i could highlight
> them all together and delete-how d...Export CRM-contacts to Outlook Global Contact (CRM 1.2)
I want to export all the contacts in CRM to the Outlook Global Contact, so
all the non-CRM-users can find contacts with there phonenumber etc. There is
no support for this at all in CRM 1.2
I can do this manually. First export all the contact to Excel and from there
back in Global Contact. Now the problem is the 'Save as'-field. You can only
set this field by opening the contact, set the field and save it. For one
contact is this no problem, for 5000 contacts it is.
When I import the contacts I can't set the value of this field. It has a
default value, but I need anoth...Change bars color
I have a dinamic chart to show the cash flow position, a scrool bar chagne
the data to the past and to the future (estimate), what I am looking for is,
to have an easy identification of the estimated period I would like to chage
the color of the bar.
I am using an Stacked Column chart with two variables.
regards from Brazil
Thanks in advance for your feedback.
What I usually do when I want to show a column chart with one color within a
certain range and another color elsewhere, is create two series, one each
color, and use formulas to change on series ...ExcelReport 2.0 Released!
ExcelReport 2.0 Released! Please check http://www.ljzsoft.com
ExcelReport is an Excel report generator that outputs reports in
Microsoft Excel spreadsheet format. If you know how to use Microsoft
Excel and write SQL statements, you can use ExcelReport to create all
kinds of Excel reports as you need.
Main Changes in ExcelReport 2.0
* Design an ExcelReport file with the extension ".xrf".
* Add a editor of ".xrf" file. You can create, open a XRF file using
* Change the user interface
* Change the syntax of functions.
* Can put data of each record i...Userform #2
I am using a userform which shows me certain information which I would like
to transfer to a worksheet in my workbook. What I am seeking advise for is
I need help with a code to look up the value in textbox.1 and to look up the
same value in column "a" and then copy values from tb2 & 3 into columns b &
Any help would be great
I created a small userform with 3 textboxes and two buttons (ok/cancel) and one
I had this code behind it:
Private Sub CommandButton1_Click()
Private Sub CommandButton2_Click()
Dim ...Mail Merge #2
In Publisher 2002 is it possible to print a roster of
Mail Merge data base records showing multiple entries per
page? I'm essentially looking to print a phone book type
list with Able, Ann (222) 222-2222 on the first line,
Brown, Bob (333) 333-3333 on the second line and so on.
Any help would be appreciated.
Not difficult at all if you make a custom size small in height label the
width of the page.
The US should free all those
illegally held prisoners they are
torturing, abusing and denying
human rights being held at