Using XPath I am querying parts of XML document, " get quoted by \ - is it
possible to specify not to quote " with \?
<Element Attribute="SomeValue" />
XmlDocument xmlDoc = new XmlDocument();
XmlNode xmlNode = xmlDoc.SelectSingleNode("//RootElement/Element")
where I was expecting to get
> Using XPath I am querying parts of XML document,...Change case for all text in cell range
I'm trying to change all the names in existing cells (in a contiguous range)
from standard case to all upper case (e.g: A1 = Joe Smith, A2 = Jane Doe,
etc. to: A1 = JOE SMITH, A2 = JANE DOE, etc.). I need the new upper case
values to be in the original cells.
Using "=UPPER(A1:BB82) forces the values in that range to change but the new
upper case values are in a different cell range.
Thanks in advance.
RLL ~ 1/27/2004
Borrowing code from Dave Peterson on truncating Left, this will make
everything in A1:BB86 uppercase.
Application.ScreenUpdating = False
D...Getting a specific parent of any node via xpath navigation
I am storing my site structure as such:
...intergration of newsgroups and outlook express
how is this achieved???
Outlook versions 2000, XP and 2003 - you can't - you have to use Outlook
THere are plugins but I have not found a good free one yet ... I belive with
the new version of Outlook (Outlook Live) that this will be included.
"ema" <email@example.com> wrote in message
> how is this achieved???
"ema" <firstname.lastname@example.org> wrote in message
> how is this achieved???
No integrat...outlook express 6 my email
My fonts keep reverting back to 12, when I saved them
under tools options fonts I set it to 18. when I creat a
new email its shows 18 as soon as I typ it changes to 12,
if I go back and highlight it and change it to a larger
size it will not change. I can change color bold and
underline but not font.
big john <email@example.com> wrote:
> My fonts keep reverting back to 12, when I saved them
> under tools options fonts I set it to 18. when I creat a
> new email its shows 18 as soon as I typ it changes to 12,
> if I go back and highlight it and change i...CRM attribute field
I have a Custom Attribute nvarchar type and format URL, but Microsoft CRM
automatically adds http:// to whatever the user enters. I want to make this
field to accept paths like "C:\notes\data\test.doc" or
How can i do this? Tanks
just don´t format it as URL cause in this case CRM defines URL not as a
button to get access to the UNC path right if you´re clicking this custom
"CRM Data Import" wrote:
> ...XPath pb
In infopath, I use a XPath expression to get some nodes :
var oEMailNodeList = XDocument.DOM.selectNodes("//Message/EMail");
My problem is that this method returns 0 items. Here is the DOM.xml property
<?xml version="1.0" ?>
<?mso-infoPathSolution productVersion=\"11.0.5329\" PIVersion=\"184.108.40.206\"
solutionVersion=\"220.127.116.11\" initialView=\"messagesList\" ?>
<?...How to use a shared printer (win xp 32bit) on windows 7 (64 bit) without 64bit driver?
I've connected my Epson EPL-5900L to my desktop-pc (Windows XP 32bit) and
share it in the network.
Now I want to use this shared printer on a Windows 7 (64bit) notebook but
unfortunately there are no 64bit drivers for this printer (not for windows 7
and not for vista).
Is there a way I can use this printer on the notebook?
--> Maybe a "proxy-printer" on the XP-machine where exists 64bit driver f�r
Hopefully someone can help me.
To print from 64-bit Win 7 you will need 64-bit Win 7 drivers. If the
printer has a emu,lation of...music in Outlook Express
I can't seem to embed music in my Outlook Express 6
email. I had no problems with my older computer, I just
went to format, background and music. But on my new
laptop I can't get the music to go into the email. Not
only that but when I hit send it says it can't send
because it the picture can't be found. I'm not even
sending a picture. gees.. whats up with this?
Reply to Pur2softly@mwic.net because I'm not sure I will
be able to find this newsgroup back again.
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Expre...Outlook express is deleting .pdf attachments
When ever I recieive an email in Outlook Express, Pdf
files are automatically deleted. Do I have a virus or is
there a patch to fix this?
d <firstname.lastname@example.org> wrote:
> When ever I recieive an email in Outlook Express, Pdf
> files are automatically deleted. Do I have a virus or is
> there a patch to fix this?
Ask in an Outlook Express newsgroup. Hint: Tools>Options>Security
...how do I lookup multiple values
Trying to lookup a value based on both Horizon and Vertical columns….
A B C
1 JAN FEB MAR
2 Ice-cream .5 .6 .7
3 Hot Cocoa 1.0 1.1 1.25
4 Coffee 1.5 1.3 1.0
5 Soda .8 .6 .9
How do I look up the price of ice - cream in the month of Jan. or lookup the
price of coffee in Mar based on an input from user on both product and month?
I can’t figure out which function to use. Please advice.
(remove nothere from email address if mailing direct)
"Lisa" <Lisa@disc...Return Value in Cell Diagonally opposite
Can anyone give me a formula that will return the value in a cell that
is diagonally opposite. If the value I search for is found in say B2 I
want to return the Value in C3.
See if this does what you want...
A1 = lookup value
Result = Y
Microsoft Excel MVP
"Pete" <email@example.com> wrote in message
news:f9ee881e-6658-4599...How to pass a Nodeset to an XPath extension function?
I am using the .NET framework v2.0.40607 with Visual C# Express and I would
like to create some custom XPath functions to use directly in a XSLT
I called System.Xml.Query.XmlArgumentList.AddExtensionObject(string, object)
to register the functions I've written.
The functions that take a String, Boolean or Number parameter work
perfectly. However, I do not know how to create a function that will accept a
Nodeset as a parameter.
I tried writting a function taking a XPathNavigator object, but it does not
work for all XPath queries that return a Nodeset: I get an error &qu...XPath Validation
I'm looking for a way to Validate an XPath prior to executing the
expression, without using a try catch clause. For example: I'm looking
for something that would tell me that "\some/Xpath\to\Node" is
As far as I know, the .NET framework could not validate XPath directly with
class library. The only thing we can do is to use try/catch block. Or you
can try to find some 3rd-party tool such as XML spy to validate it. HTH.
"This posting is provided "AS IS" with no warranties, and confers no
Thanks K...Help with If or Case
I have a report that list all orders for the year. The orders report
includes a Status column and an order could have one of six possible status.
The users have asked to get a form with six option buttons they can toggle
to choose which status conditions they want to include or exclude on the
report. I have created the form with the six option buttons with “Default
Value” property set to 1 and a Next button to run the report. I’m blanking
out tryiing to build the nested If statement. Any examples ...Plot X and Y values
I need to create a chart in Excel in which each point has
an X and Y value, reading the info from a table of data.
When using the "scatter" chart type, it doesn't do that,
instead it draws two series' of points, one series for the
X values and one for the Y.
There may be some data in adjacent columns that is confusing the Chart
Wizard. Select only the series data and labels, and run the chart
wizard, and it should set up the chart correctly.
> I need to create a chart in Excel in which each point has
>...HELP! Retrieving the application path?!
Hi, I need to retrieve the startup path (location) of=20
both an executable and dll file. I can=B4t find a function=20
for this, only _getcurcwd which retrieves the current=20
working directory, but this wont hold for long.
In .NET there is Application.StartupPath, what=B4s the=20
equivalent in Visual C++?
Thanx in advance...
"Joel" <firstname.lastname@example.org> skrev i en meddelelse
Hi, I need to retrieve the startup path (location) of
both an executable and dll file. I can�t...Tricky XPath query
Hi all, I've just changed the structure of my XML file and now I need
to construct an XPathNavigator object that uses tags from two
different levels in the XML file.
Some Data That Belongs Here
Some Data that Belongs More Specifically Here
This Data should real...Updating value of asets in Money
Ive been useing Money for some time now,upgrading each
year and learning as I go.
Id like to update the value of several assets (cars ,
home , ect) in money totrack their worth. My question is
how do I do this? The program asks for a catagory? Which
do you suggest?
I'm new to Money but I've been suing a category I call
Depreciation for this task for years in Quicken. I just
write all changes in value (up or down) to this category,
and then do not include it in my cash flow or budget
reports (since it's not really money I'm spending or
making until it's "re...Integer maximum value
I have define a field type as integer.
I tried to put a value 120,000 but it seems exceeds the value.
An integer field stores numbers from -32,768 to 32,767. A long integer
field stores numbers from -2,147,483,648 to 2,147,483,647. So, just change
the field size from integer to long integer, and you should be OK.
Help on Field Size gives the specifications for all the data types
"Alan T" <alanpltseNOSPAM@yahoo.com.au> wrote in message
>I have define a field type as integer.
> I tried...Xpath with namespaces
I am having an issue with xml and namespaces, at least I think it is
namespaces. When I use namespaces, I cannot use SelectSingleNode /
SelectNodes as they always return 0/Nothing respectively. Anyone have any
Thanks in advance
Dim objXML As System.Xml.XmlDocument
'Test XML 1 ==> Always returns 0
objXML = New System.Xml.XmlDocument
objXML.Load(Application.StartupPath & "\xmlfile1.xml")
'Test XML 2 ==> Always re...Conditional Formatting A Cell Based on Another Cell's Value
I have a report where I want to use conditional formatting on the two
far right-hand columns.
Applying conditional formatting to right-hand column 1 (RHC1) which
consists of percentages is easy. If the value in any cell in this
column is less than .85 the cell is shaded green, if greater than or
equal to .85 and less than or equal to 1 the cell is cell is shaded
yellow, if it's greater than 1 it is shaded red.
Right-hand column 2 (RHC2) consists of whole numbers. I want the
shading of the cells in RHC2 to match the shading of the cells next to
them in RHC1. I have tried to create formu...replacing values in cells from a pre-designed table
I am working with an Excel Spreadsheet. I have, in column C, a different value on each row: 1.2 or 0.7 or 2.5, etc. In column D I want to have Excel automatically place, in each row, a new value based on a reference table I would create.
If column C value is Then column D value on same row will b
...Outlook Express like address book window
Is there a way to get a window frame in Outlook with a listing of
addresses in one's default address book, much like that in Outlook Express?
Thanks for any input
Outlook is not Express so probably not. Why do you not use your contacts
folder in Outlook? List it in phone list view.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Curtis Vaughan asked:
| Is there a way to get a window frame in Outlook with a listing of
| add...Formating text of x-axix value
I make a chart with x-axix values from let's say 1E-9 to 1E-3, using
logaritmic scale. So far so good.
But my need is not to display the values in the chart like 1E-9, 1E-8, etc.
but like 10-9, where the -9 text will be formated as upper index.
Thx for any help or suggestion.
Bernard V Liengme
remove caps from email
"Karel" <Karel@discussions.microsoft.com> wrote in message