An XML question
I would like to produce the following output based on my XML file:
My Album (2005)
Elapsed Time (hh:mm:ss): 00:07:00
Song 1: title1
Length (hh:mm:ss): 00:02:30
Song 2: title2
Length (hh:mm:ss): 00:02:15
Song 3: title3
Length (hh:mm:ss): 00:02:15
<...Social Security & Medicare payment deductions
Using Money '04.
I need advice on keeping up with Social Security pension received where the
Medicare insurance is deducted from total payment.
When I download the deposit from the bank it just lists the total amount
deposited, which is the amount due less the deduction for Medicare
I would like to keep up with the total S.S. amount received and then record
the amount paid for the insurance.
How should this be handled?
Edit the downloaded transactions into a split. In the splits, change the
amount for the income category to the total. Add a second l...graphics in Publisher #2
When viewing my document in Print Preview, only graphics appear.
Does the document print in toto? Have you gone to the manufacturer's web site of
your printer model and looked around for an updated driver?
Mary Sauer MSFT MVP
"cmeeker" <email@example.com> wrote in message
> When viewing my document in Print Preview, only graphics appear.
Yes, the document does print. No, I haven't gone to the printer...EXCEL: Separating data from 1 cell into multiple cells
I have thousands of cells in a report with information that I need to
separate into different cells.
Ex. one cell: Arch | South | All Points | Extreme
I need an automated way to get each of the 4 names separated by "|" into its
Highlight the column, Text to columns, Delimited, next, check only the Other
box and copy your | in the box beside it, next, finish
> I have thousands of cells in a report with information that I need to
> separate in...Totals on Sales Inquiry native windows
We would like to have the totals on the Sales Inquiries:
Transaction by Customer
Transaction by Document
Today we can retrieve this information in separated inquiries and reports,
be we would like to heve a easier way to see this totals...
The same suggest can be applied to Smartlist. If possible, you can create a
tool to sum a field after you make a filter
I created a screen where you can see all sales, separated by day of week,
and week of year, and totals YTD,MTD and WTD, but I am not able to have the
same information grouped by item number, for example.....Setting ID# to 1 & Total on bottom of query result
I have 2 separate questions. First how do I set the ID# to 1 for the
first record. I copied my whole database including queries and forms
which were 2009 records and changed the titles to 2010. I did a
"compact and repair" to the 2010 database. But when I start to enter
records for 2010 the ID# is 2550. How can I reset the ID# back to
start at 1?
On many of my queries I have the results be for example 28 Caucation,
43 African American, 65 Hispanic, 4 Asian, 2 Native American. I need
these numbers separate like they are but I would like a total line at
the bottom...attachments removed #2
I receive the following message when receiving emails
"OE removed access to the following unsafe attachments in
your email: (file name)"
Can this barrier be overcome?
Open Outlook Express and select Tools | Options | Security tab and uncheck
the second box from the top concerning attachments.
"Lisa Fry" <firstname.lastname@example.org> wrote in message
>I receive the following message when receiving emails
> with attachments:
> "OE removed access to the following unsafe attachments in
> yo...Alternatives to VBA in Excel #2
excuse my cross-posting, but I do not know which NG is the appropriate for
I wrote an Excel-Macro in VBA which reads a text file, interprets this file
and then does in Excel what has o be done: format cells, put values to it,
storing files, inserting worksheets etc.
This works well, as designed, but is not very fast.
So I look for a way to increase speed.
I have Visual C++ 6 in Visual Studio. Can I rewrite my macro in Visual C++
so that it gets faster? If yes, where do I find "easy to understand"
descriptions how to do this? What do I need additionally?
Thomas Kre...Money 2004 standard & VAT
Does Money 2004 Standard automatically calculates & enter
VAT (Value added /sales Tax)?
At the end of everyday I import up 20 files into an excel worksheet
These are filesaves from a dos database and have no suffix. (Example
are OP1, OP2, etc)
Following the import I have a corresponding number of open workbooks
the contents of which I manually cut and paste into another workboo
(onto a single page) in which I extract the required information.
Can anybody help me automate this process.
To my limited way of thinking, the process would need to consider th
Select Drive/select files
convert to Excel
Combine all on open worksheet
Thanks in advance for any ad...pivot table help #2
I am extremely new to pivot tables and trying to just get ave, max, and
min of a couple of columns ... I keep getting #DIV/0! errors and don't
know what the problem is. any ideas anyone???
evg1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35043
View this thread: http://www.excelforum.com/showthread.php?threadid=547887
Do you have errors in any of those fields in the raw data?
Do you have any numbers in the field that you're averaging?
> I am ...Add Sheet Cells into 1 sheet
People i have a excel spread sheet with many sheets inside it one for
each day dating back 3 months
sheets are named like 1st july05 till 1st oct05
1 for each day and blank sheets for weekends
i want to add the totals of field b25 on all sheets onto a new sheet
can this be done?
=SUM('First Sheet:Last Sheet'!B25)
"Mrbanner" <email@example.com> wrote in message
> People i have a excel spread sheet with many sheets inside it one for
...Merging data from 2 workbooks
Operating System: Mac OS X 10.6 (Snow Leopard)
How can I merge data into 1? <br><br>Some of the data Names are the same but I need to combine amounts in the other cells
Sorry, I do not understand: your question does not have enough detail.
See the excel help topic "Use names in formulas" for more.
You CAN use "Sheet-scoped data names" if you define them that way, but
"don't" because it can make your formulas very confusing. See
Hope this helps
On ...POP message #2
The cable company I use does not support Outlook. I keep
getting POP. messages to put in my name and password
every minute or so. Cable company says I have to use
Outlook Express. How do I turn off Outlook and make
Express dominant. Keep getting errors when I attempt to
switch over and mail keeps going to Outlook
What version of Outlook do you have? What is the exact text of the error
message you're getting? Outlook will work fine for receiving mail from your
cable company - it's just that the company doesn't want to go to the trouble
of telling you how to configure it p...IF help #2
i have to calulate a Excel Spread sheet on a weekly basis
so i know how to pay staff for product sales
the file is output from a weird old dos program into a excel document
I have 2 sheet inside a Excel document
lets call them Sheet 1 and sheet 2
has 3 columums
Date Product and $Due
$due Columum is not filled and i need this to auto fill
has a list of products in Columum 1 and 2 has the price on it
I need to do a if statement
that if sheet 1 PRODUCT = SHEET 2 PRODUCT THEN sh...Unicode Basic Latin and Latin-1 coverage of Western Europe
What gaps would there be in the coverage of Western European
languages that would not be included in Unicode Basic Latin
and Latin-1 ?
"Peter Olcott" <NoSpam@SeeScreen.com> wrote in message
> What gaps would there be in the coverage of Western European languages
> that would not be included in Unicode Basic Latin and Latin-1 ?
The Greek alphabet.
"Norman Diamond" <firstname.lastname@example.org> wrote in
> "Peter Olcott"...working with multiple worksheets #2
I would like to collect data from one specific cell (cell E3) in 90
worksheets and have this data placed in one column from 1-90 on one single
worksheet. Is there a way to do this without doing it one by one?
Are you using the default sheet names? (probably not, huh?)
If there is some common sequence in the sheet names then a formula could
probably be crafted to do this.
"Shaun" <Shaun@discussions.microsoft.com> wrote in message
>I would like to collect data from one specific cell (cell E3) in 90
Is there a (reg) setting to prevent delivery receipts in exc 5.5
Start exchange admin ---> connections --> internet mail service --->internet
mail -->advanced options..
here you should be able to disable auto replies to the internet (ie delivery
"Mike" <email@example.com> wrote in message
> Is there a (reg) setting to prevent delivery receipts in exc 5.5
...total cost on report
I have areport with a cost field that I would like to total that collum at
the end of the report. How do I do this ? do I need to create another field
>I have areport with a cost field that I would like to total that collum at
>the end of the report. How do I do this ? do I need to create another field
The usual way is to use a text box with an expression like:
MVP [MS Access]
I'm in design view of the report, where do I insert this expression?
I clicked on page footer to insert thi...StartDoc() returns -1
Below is a section of code that I am using, it always works the first time
but on the second call StartDoc always returns -1. I can't even find out the
What is going wrong?
// Doc info. //
memset(&doc, 0, sizeof(doc));
doc.cbSize = sizeof (doc);
doc.lpszDocName = "Doc";
"Chris Baker" <ChrisBaker@discussions.microsoft.com> wrote in messag...multiple data label formats #2
Thanks for your help Andy, I'll look into it
ob3ron02's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1545
View this thread: http://www.excelforum.com/showthread.php?threadid=27275
...CRM & Great Plains Hardware
ok, i posted this message yesterday, but it didn't show up. So here it is again
We recently purchased both CRM and Great Plains (approx 50 users). We have to new Compaq servers to use for these products
What is everyone's opinion on the best configuration
1. GP and SQL on one box, and CRM and SQL on another
2. SQL on one box and GP/CRM on the other
3. GP and SQL on one box and CRM on the other
I take it you plan on integrating the 2? If so, there are specific
requirements as to how you need to set it up using 2 servers depending on
what NOS you're running on t...Finding Cells that Total a Value
I need some assistance in solving a problem. I have a spreadsheet with
over five hundred lines of transactions. The sum of these transactions
are creating a balance on the account. Is there any formula/macro that
will help me find the transactions creating the balance? The sum of the
account should be zero. To clarify, if we owe client money, there
would be a transaction setting up that postive balance then a payment
on the account taking it back to zero. There could be multiple
transactions and then one net payment. Or we could be due to receive.
So at the end of the day, th...set up a table plan for a party of 200 people with 25 tables??
I need to set up a table plan for 200 people which will include 25 tables.
Can you suggest how to do this through publisher
I'd use Visio but.................Use drawing items. Circles for tables,
rectangles for chairs, various size dots for the people ;-)
MVP Microsoft [Publisher]
How to ask a question
"Debbie" <Debbie@discussions.microsoft.com> wrote in message
>I need to set up a table plan for 200 people which will include 25 tables.
>...Outlook Client on CRM 1.2 Server Box for Demos
Did a CRM 1.2 install on Windows 2003 Server and all is working well.
I have been seeing things on this newsgroup that say I should be able to
install the Outlook client as well on this machine although it is an
This is for demo's only. I am running it under Virtual PC. I would like
to not have to have 2 Virtual PC images running just to show the Outlook
integration to CRM.
When I try to install the Outlook client I get a message at the start saying
that the Outlook client is already installed. It is not.