Question about signing XML and RSA
I am trying to sign my XML files with private/public keys but I have noticed
that initiating the RSA key with either RSA.Create() or FromXMLString()
takes a lot of time. I wonder why? On my machine (which is pretty fast) it
takes seconds to call RSA.Create() Is it possible to skip this part and read
in the keys directly? What is the fastest way to get a RSA key to pass
SignedXML.SigningKey ? I have generated keys already.
"David Lindgren" <email@example.com.REMOVE!> wrote
> I am trying to sign my XML files with private/public keys but I ...Today Conditional Format
I have a column which calculated a date based on 3 working days from a date
input into a diff column. What I want to do I have the calculated date
appear bold if that date has passed based on the current date.
For example if I input 01/08/11 the next column calculates 04/08/11 (3
working days). I want the caluclated date to appear bold when I open the
spreadsheet on the 05/08/11 ro show the calculated date has passed.
I can use conditional formatting but can't get the syntax right
Win XP Pro
Andy Roberts presented the following explanation :
> I ha...Two Condition Vlookup?
I am currently trying to create a function that searches through an
array for two exact column values which allows me to retrieve a third
column value. For example:
Type of Fruit Date Packaged Amount of Fruit
Apples June 100
Oranges June 50
Apples July 75
Grapes July 50
In this example, I would be looking to retrieve the Amount of Fruit
(Apples) that was packaged in July. I would be putt...Sending XML data to asp server... Is there any problem?
Hi, I transform client XML data to IIS server by WinInet API.
In IIS server, asp parse request XML data and result save in MS-SQL.
I can read XML data by this function,
but I can send XML data...
The function that I use is that...
BOOL CXMLUtil::RequestHttpServer(LPCTSTR lpszMethod, LPCTSTR lpszURL,
LPCTSTR lpszRequest, LPCTSTR lpszHeader,
CString &strResponse, CString &strStatus)
BOOL fResult = TRUE;
CHttpConnection *pHttpConnection = NULL;
CHttpFile *pHttpFile = NULL;
DWORD dwErrorCode = 0;
CString strUrl = lpszURL;
...Query condition by date range
I'm trying to create a query to base a report from. I need it to return
records within a date range that needs to be specified, as in specifying the
beginning date and having the current date as the end date. A field is
included in the query that has listed dates in the format mm/dd/yyyy. How
would I write the criteria? I have part of it ready - [Please enter starting
date:] . I know that's how you get the little question window.
On Tue, 4 Dec 2007 14:51:00 -0800, silva wrote:
> I'm trying to create a query to base a report from. I need it to return
> records within a...Need help with conditional formula (Excel 97)
Can anyone give me the correct syntax for the following formula:
if A1 is blank, and B1 is more than zero, then display B1, otherwise
display nothing (blank cell)
met vriendelijke groetjes
"Jake D" <JakeD@djhtend.com> schreef in bericht
> Can anyone give me the correct syntax for the following formula:
> if A1 is blank, and B1 is more than zero, then display B1, otherwise
> display nothing (blank cell)
> Thank you
> ...Conditional formatting if condition of an if statement is true and a string value is displayed
I got a nested 'IF'-Formula in an excel cell that returns nothing if
the condition is false.
I would like to conditionally format this cell with grey shading if
the condition is true and a string value is displayed.
How can this be achieved using excel conditional formating
Help is much appreciated. Thank you very much in advance.
Let's say your doing this conditional formatting in cell K17. In
conditional formatting (xl2003) choose the FormulaIs: option and enter:
choose your formatt...Schemas referred in XML
I have an xml.
It was generated from different schemas.
I want to know the namespaces and the schemas that are
reffered in that XML.
So that i can add the Namespaces and Schemas to the
Namespace Manager and Validate them.
How do i dothat.
One more time in simple words.
I had an xml. i want to know how do i know what
namespaces and xsds are refered?
...Conditional Field in Queries
Is there a way to make a field in a query conditional so that it only
displays the value if the value is equal to something specifically
> Is there a way to make a field in a query conditional so that it only
> displays the value if the value is equal to something specifically
> set? Thanks.
Explain "the value is equal to something specifically set".
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
...XML validation error. Help required
XML validation error. Help required
If anyone can help me, thankyou, thankyou...
When I run this code code I get this error:
The data at the root level is invalid. Line 1, position 39.
I can't work out what the error is. Can you???
Dim oRead As XmlTextReader
Dim oValid As XmlValidatingReader
oRead = New XmlTextReader("C:\custdoc.xml")
oValid = New XmlValidatingReader(oRead)
AddHandler oValid.ValidationEventHandler, New Schema.ValidationEventHandler(AddressOf ValidationError)
oValid....How do i use Conditional formatting for 3+ conditions ?
I have a text box in a report which highlights in colour current members in
a list of past and present member names. I have six types of current members
that I want to highlight, but with conditional formatting I can only use 3
conditions in the members [Type] field. I have tried [Type]="Full member" Or
"Life member" but the "Or" doesn't work ! Is there a way to do this ?
thanks .. Roger
CF is limited to 3 contitions, but you can use OR in those expressions.
If you set Condition1 to Expression, you can use:
([Type] = "Full member") Or (...How do I write a response to a request from an xml data island?
I need to know the code I must write to respond xml to a data island as a
result from a src request from the data island.
Thanks so much
Assuming the data island has a src attribute like: "getXML.asp", this ASP
page would do it:
var xmlDoc = new ActiveXObject("MSXML2.DomDocument");
"Nicole Schenk" wrote:
> I need to know the code I must write to respond x...Help with Conditional formatting with Dates
I have a spreadsheet in which I have to monitor various dates which are in
different columns (i.e. (1) Date Tender Released, (2) Date Company Selected,
(3) Date Draft Contract Forwarded, (4) Date Contract Signed etc...).
Would if be possible to Conditional Format and have diffirent ROWs
highlighted for each individual Contracts (I have 300 running contracts
running) every time a date is filled in these different columns:
Initial Step (1) = Yellow (Call for Tender released)
Step (2) = Blue (Company Selected)
Step (3) = Brown (Contract under Process)
Step (4) = Green (Contract Si...Conditional null value
Wondering if anyone can suggest a way to simplify the following code, which
I’m using in the OnFormat event of a report.
If Not IsNull(DLookup("[ICD2]", "EntryICDs", "[EntryNum] = " & Me!
Me![Field192] = Replace(DLookup("[ICD2]", "EntryICDs", "[EntryNum] =
" & Me![PtAcct#]), ".", " ")
If Not IsNull(DLookup("[ICD3]", "EntryICDs", "[EntryNum] = " & Me!
Me![Field194] = Replace(DLookup("[ICD...Save and load crypted XML
I need to save / load XML data in crypted format.
I'm using .net 1.1.
"nano2k" <firstname.lastname@example.org> wrote in message
> I need to save / load XML data in crypted format.
> I'm using .net 1.1.
What you really need is a specification.
Decide how you are going to encrypt, and equalising both sides of the
equation on transposition; how you are going to decrypt. These steps
pre-empt input and output, and no, generic methods are not secure because
Forgive me if "Conditional Sums" is not the accurate word for what I am
trying to accomplish... I'm at a loss for what to call this situation.
What I have is a spreadsheet totaling attendance figures for classes taught
by two people (Dave and Cary). Column A lists their name, and next to it in
Column B is the number of people who attended that class. What I need is a
formula that will look at the sheet and report in a given cell the total for
attendance for each person. I can work basic formulas like SUM, but that
will give the total for the entire column, when what I n...XML Receipt and Conditions
I wanted to make a small adjustment to the receipt when a certain
condition is met.
If a particular word (eg. family) is typed into the comment on an item
I wanted something slightly different to happen to the receipt
I've just about got it, just stuck on the condition tag
I can get it using len but this makes it happen for any word, is there
anyway I can make it so that it is more specific ie Entry.Comment
<CONDITION>Entry.Comment like '%family%'&...conditionally restricting values in excel
I want to restrict values in a particular column based on the value in other
column. For eg.
if column A has value int then column B should be restricted to values
if column A has value bool then column B should be restricted to values true
if column A has value string I dont want any validation to
be done and the list box should not appear.
Is this possible.....
How do I achieve this ? Can I use macros to do this? How?
as a starting point:
>I want to restrict ...Conditional formating condition..?
I have 2 CF conditions associated with a cell (C14), one of which is:
Formula is =OR($C$4="Fred SOMEBODY",C14<>"10:30:00")
What happens when this is true isn't important/relevant.
The value in the cell appears as 10:30 (formatted as custom/hh:mm) but the
value in the 'formula window' is actually 10:30:00.
This type of condition works fine when the cell contains a simple number (or
text) but I can't get it to work for either times or dates.
I have tried it with and without the inverted commas (around the time value)
and have tried using 10:30 ...Condition Formatting!
How do I make a row of cell (shading) that change to red color when the word
"trial" or "limit" is entered?
i.e cell 3f contain the word "trial". From the column of trial to the 1st
column, the entire row 3a to 3f will be red?
a b c d e f
Here's some VBA you could paste into the codebehind page for that sheet:
Private Sub Worksheet_Change(ByVal Target As Range)
If UCase(Target.Value) = "TRIAL" Or UCase(Target.Value) = "LIMIT" T...chart conditional formatting
I have a line chart with 3 lines, red, blue and green. Is there any way
I can conditionally format some, but not all, points on the red line to
colour white - ie make them invisible. I have looked at Jon Peltier's
site - he addresses conditional formatting - but cannot see a solution
there. Thanks in advance to all who try to help.
bob777's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28504
View this thread: http://www.excelforum.com/showthread.php?threadid=488635
Does anybody knows how to insert one picture that changes without use
intervention everytime the result of another cell changes?
eg.: If the cell A1="Alex" the cell A2=Picture of Alex. Then if
change the cell A1 to "Mike" the cell A2 displays the picture of Mike
Message posted from http://www.ExcelForum.com
This macro example from this group a long time ago you can use.
The jpg files must have the same names as the number you type in cell "a1"
Change the path to the files in the code.
Place the code in the Sheet module
Right click on a sheet tab ...Xml and Serialization.
I would like to display some properties of an object of mine as XmlElement
"Content", not as an nested Element
That is :
currently it display as :
How do I do ?
I fumbled with [XmlAttribute], [XmlElement] declarations ... to no avail.
Any idea, anyone ?
Microsoft Developer Division
d i n o...Serialization of ArrayList as root element
Can anyone tell me how to setup serialization attributes for an ArrayList as
a root element ?
...Conditional Formatting for 4 conditions
How can I set up conditional formatting for the following:
>3.5 = red
2.5 - 3.49 = yellow
2 - 2.49 = green
<2 = blue
Set all the cells to one of the colours that apply the 3 conditions to them
via CF, effectively 4 colours.
"Steve" <Steve@discussions.microsoft.com> wrote in message
> How can I set up conditional formatting for the following:
>>3.5 = red
> 2.5 - 3.49 = yellow
> 2 - 2.49 = green
> <2 = blue