I've done parsing where you have one delimiter such as a comma or
What if you have more than one?
sStr(0) = "3/9"
sStr(1) = "3/11 3/15-"
sStr(2) = "3/8+ 3/12"
sStr(3) = "3/9 3/15"
sStr(4) = "3/8- 3/10+ 3/15"
The strings above are Month/Day with some having an additional - or +
character next to it.
These dates are extracted from Excel cells as strings.
I need to break those strings down into individual dates.
So for sStr(4), I need to parse out "3/8", "3/10" and "3/15&...Text box in chart disappears but reappears when in spreadsheet
Has anyone any idea how to prevent a text box that's in a graph from
disappearing when the graph is selected, but reappearing when cursor is back
in the spreadsheet? This never used to happen before, but only recently has
begun occuring with our graphs. Thanks!
That behavior would suggest the textbox is not embedded in the chart but
just placed over it. Can you move the textbox away from the chart?
If yes then delete the textbox and then select the chart and paste.
> Has anyone any idea how to prevent a text box that's in a graph from
> di...returning a text value
I think this is simple but I am confused with it. I am creating a softball
roster. Column a is the positions, Column b is player for inning 1. C is
inning 2 and so on. So with my current grid I can see who is in which
position by inning. My second grid will show players name followed by
position being played. Column F lists all the players. I need a function that
will search column b for matches to column F and insert the position (column
a) in column G.
Check Help for Vlookup.
"Tim" <Tim@discussions.microsoft.com> wrote in message
news:133...Ordering xml using xsl in c#
I have a xml dataset I'd like to order, and save in that
order. I've written an xsl to do the transformation, but
because the xml file has a xsd namespace, it doesn't work.
A cutdown version of the xml file looks like this:
<?xml version="1.0" standalone="yes"?>
<comment>Herbert Smith London Offices</comment>
</ci...How to total three separate reports into one report:
I have three separate reports that are working great! Management would like
to see the total lines of each report on one page without the detail that
feeds to the summary of each column. How do I compile the totals of these
three separate reports into one page w/just a title and total of the
categories that they would like to see from each report? Thank you.
Report Name # # #
Category 1 4 5 6
Category 2 2 8 1
Category 3 9 7 4
Evelyn Williams wrote:
>I have three separate reports that are working great! Management would like
>to see the tota...Text size #4
I'm sure this is probably very easy! but I can't find any way to increase
the size of an email in the viewing panel of Outlook, is there a way to do
this and possibly to add a button to the toolbar to enable easy resizing of
"Harry Limey" <harrylimey(at)Lycos.co.uk> wrote in message
> I'm sure this is probably very easy! but I can't find any way to increase
> the size of an email in the viewing panel of Outlook, is there a way to do
> this and possibly to add a button to the toolbar...i have microsoft works spreadsheet not excell, can i upgrade to ex
Can I upgarde or do i need to buy the full version?
There's upgrade eligibility information on the Microsoft site:
> Can I upgarde or do i need to buy the full version?
Excel FAQ, Tips & Book List
...Text list to graph
I have a column listing car makes in random order with duplicates:
QUESTION: How can I create a chart from this list?
I've tried sorting, then sub-totaling. Am I on the right track?
Thanks, Mark Flynn
You can summarize the data with a Pivot Table, and create a chart from that.
Add a heading to the list, e.g. Cars
Select a cell in the table.
Choose Data>PivotTable and PivotChart Report
Select PivotChart report (with PivotTable report), click Next
Select the Data range, click Next
Drag the Cars button to the Row area
Dr...Generating a table of figures and table of tables using 'insert caption'
Operating System: Mac OS X 10.4 (Tiger)
Hi, <br><br>I have set up a template in Word 2008 for some scientists to use. They want to insert captions using the 'Insert', 'Caption...' option for tables and figures, rather than using the style sheet 'figure caption' and 'table caption' that I set up so that the captions can be picked up by the cross-reference function. <br><br>Is there a way for my figure caption and table caption styles to be picked up by the cross-reference function? <br><br>Al...Could not open one or more attachments #4
User has Outlook 2000 on a WinXP Pro PC and gets this error when opening
attachments on some emails (not all). Tried reloading Outlook, but that
made no difference.
AnytimeAnywhere <firstname.lastname@example.org> wrote:
> User has Outlook 2000 on a WinXP Pro PC and gets this error when
> opening attachments on some emails (not all).
Post the complete and exact text of the error.
Could not open one or more attachments.
"Brian Tillman" <email@example.com> wrote in message
&g...how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it possible?
how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it
"Daniel" <firstname.lastname@example.org> wrote in message
> how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it
No -- the xml declaration is not represented in the XML Infoset.
...From CRM call, an SSRS report that uses a stored Procedure.
All of my SSRS reports use store procedures. We recently started using MSCRM
and I read that we can use tokens (CRMAF_) to pass paramters from CRm to SSRS.
I have seen canned reports that use a stored procedure instead of a text
query, but I can't create a new report that works. How do I set up the
report so the results will be only for the Account the user is currently
Thanks in advance,
The SDK has a reporting section with some info on this:
Matt Wittemann, CRM MVP
"...Converting capitalized text to lower case
Is it possible (if so, how?) to convert capitalized text
to lowercase within cells - - when they were typed in ALL
CAPS mode at the onset?
If you've got a solution to this one, I'll really be
For Each cell In Selection
cell.Value = LCase(cell.Value)
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Evie" <email@example.com> wrote in message
> Is it possible (if so, how?...Use Outlook 2000 to retrieve Hotmail email?
Can someone tell me how to Use Outlook 2000 to retrieve
Hotmail email? It keeps asking for a POP3 account info,
when hotmail uses HTTP instead, very frustating. Thanks
I don't think you can do this - you need to use either Outlook Express or
Outlook XP (2002).
"John Luton" <JL112055@yahoo.com> wrote in message
> Can someone tell me how to Use Outlook 2000 to retrieve
> Hotmail email? It keeps asking for a POP3 account info,
> when hotmail uses HTTP instead, very frustating. Thanks
...Compare one year to another, but just YTD
Let's see if I can explain this. I have two sheets, the first sheet is
labeled 2005 and the second one is 2006. In A1 thru A12 on both sheets is
Jan, Feb, Mar, etc. On 2005 B1 thru B12 we have monthly values. On 2006 B1
thru B7 (as we are just now going into Aug.) we have monthly values. In B13
on both sheets are totals. The problem is I can't compare on year to the
next as the total on the 2005 sheet is for the full year. I'd like to add
Label in A14 that says 2005 YTD and have a formula in B14 that looks at how
many cells in the range B1 thru B12 on 2006 have values then...Basic Search
Why do you have to close the search box before you can edit the cell
that was found? That is a pain, because to continue searching you
need to open the serch box again. Why does it not work like Word?
depends on the Excel version. Excel 2003 allows this (don't know if
this feature was available before this version)
> Why do you have to close the search box before you can edit the cell
> that was found? That is a pain, because to continue searching you
> need to open the serch box again. Why does it no...Text #2
I'm just trying to enter some text, maybe an equal sign "=", but it keeps
taking it as a formula. What do I do?
"greekgodsurfer" <firstname.lastname@example.org> schrieb im
> I'm just trying to enter some text, maybe an equal sign "=", but it
> taking it as a formula. What do I do?
Thanks, I looked all over for it in help and couldn't find anything!
"Frank Kabel"...How I can specify the length of a text or binary column to larger value?
When the using Microsoft Excel How I can specify the
length of a text or binary column to a larger value?
otherwise, if the length of a text or binary column not
specified (or is specified as 0), the column length will
be set to 255.
not really sure what you're trying to achieve?
"Yue Wu" <email@example.com> schrieb im Newsbeitrag
> When the using Microsoft Excel How I can specify the
> length of a text or binary column to a larger value?
> otherwise, if the lengt...Selecting multiple criteria in a report in Acc 2007 using a form
How can I select multiple criteria using a form to generate a report in
On Wed, 10 Mar 2010 17:38:04 -0800, Lady_Dee
>How can I select multiple criteria using a form to generate a report in
By putting multiple instances of
or other appropriate expressions on the Criteria line of a query, and use that
query as the Recordsource for the report.
For a more detailed answer please post a more detailed question.
John W. Vins...Maintain PO Line item number sequence when one is deleted.
Once a PO is printed (released), if a line item is deleted, all subsequent
line item numbers are resequenced. I would prefer they are not resequenced to
maintain accurate history and to all me to tell the vendor that line item 13
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree"...Parsing cells
I have data in cells which is OCR`d from my phone bill, and
some of the info is corrupt. Where I should be getting eg. 17 Nov 14:49 for
date/time I am getting O17 Nov 14:49 or
C17Nov 14:49. The reason is that there are unreadable icon characters to
signify day or night.
1)How do I remove the faulty characters......they are always the first digit
in the date if they are there.
2)How can I seperate the date and time into two adjasent colums of cells
rather than their current format in one cell.
Any and all help greatly appreciated. John
You ca...text display in MDI
Iam niranjan Developing MDI Application in vc++6.0
when iam displaying text in windows iam using OnDraw and OnChar
in OnChar function iam incrementing the x,y positions accoording to
Key strokes. and making the string buffer to empty in "Enter" Key
in OnDraw function
by using pDC->TextOut(x,y,str) iam displaying the text
here iam not getting the proper data....
my problems are....
1. after giving ther enter key curson going to next line but previous
lines data in erasing , after ever enter key..
if any one knows solution plz help me to get th...Text to Columns #2
Having used the "Text to Columns" tool once on a worksheet (to separate by
spaces), I find I can't switch it off. Every subsequent time I try to copy
and paste some other text from a single cell, for some completely different
reason, the pasted data gets spread over many columns if there are any
spaces in the text. How can I switch off "Text to Columns" after using it?
This surely must be a bug, it's so unreasonable!
Excel likes to help by remembering your last settings. This can be really handy
if you're pasting similar stuff lots of times.
You ...Parse Nested Elements to Single DataGrid
I have been losing my mind trying to parse an XML document (with nested child
elements, not all of which appear in each parent node) into a DataGrid
object. What I want to do is "flatten" the XML document into a text
document with a single row for each parent node (that has all of the values
from all of the child nodes for that row)
The DataView within VS 2005 IDE displays my 15 or so child tables - and
knows that some parent rows don't have child rows in every relation - but
trying to get all the child tables to go with the correct parent row
programmatically is killin...search filter cannot be recognized
Can you tell me where I would make the change to the DN as described below?
I don't see an open parenthesis anywhere, how do I find this?
The problem is that in the distinguished name of the database there is a
parenthesis without its match. Examples of this would include:
cn=Mailbox Store 1 (SG1,cn=First Storage Group,....
cn=Mailbox Store 1 (SG2),cn=Second Storage Group (TestServer,cn=...
If you add the closing parenthesis and force replication of the Active
the "Add Databases to Recover" dialog should work properly.
The problem ...