Hi Tom,
I see an issue now with the inputs in excel. they are coming up as:
the 10.01 answer is coming up as:
<Cell id="DiscountPerc1 div 100"><Data ss:Type="Number">0.10009999999999999</Data></Cell>
the 0.01 answer is coming up as:
<Cell><Data ss:Type="Number">1E-4</Data></Cell>
So...
I have the following xslt code
<xsl:attribute name="DiscountPerc1"> <xsl:value-of select=". * 100"/> </xsl:attribute>
It is trying to translate from an XML file (origionally an excel sheet where the cell would be formatted for percent) values like this:
10.01
It then...
cool, thanks Phil,
Its good but I think I need it to only work for radio buttons. Can I get getElementsByName and then dig down into that and get them by type?
this is what I have so far:
Private Sub Application_Startup()
Dim olApp As Outlook.Application
Dim olNS As Outlook.NameSpace
Dim olFld As Outlook.MAPIFolder
Dim oMail As Outlook.MailItem
Set olApp = Outlook.Application
Set olNS = olApp.GetNamespace("MAPI")
Set olFld =...
I got round my problem and created the code I needed which fires off when I receive a new mail. The problem is now that the function Application_NewMail() does not catch all new mail.
eg if I open outlook I might have 3 emails waiting. I want to alter the subject in these as I do in...
sorry SkipVought, I don't get you. when I go to my outlook 2010 and I click alt+f11 and then I click help I get the bing search, which has nothing... absolutely nothing at all in it.
I'm using outlook and alf + F11 brings up the VBA
In their I have access to ThisOutlookSession. I wanted to popup a msgbox("hello world") when I recieved a new mail.
I assumed this went into:
Private Sub Application_NewMail()
MsgBox ("hello world")
End Sub
What do I need to do to get...
I have a .net dll and it has a readonly peropery quotelist() as arraylist
The problem is that when I'm in VB6 I try the following:
objSolution.QuoteList.Add (objQuote)
And it fails with an "Object does not support this Property or Method"
Any ideas?
The value is exactly 7. I type in 7.
Here is how you get the same results as I did. I tried this on excel 2007. I have also tried it on earlier versions of excel, but don't get the same results.
Open excel.
Format a cell to be percentage with 2 decimal places.
Enter in 7
Save as excel xml...
I have a column in excel that is a percentage. When I save 6% it saves to the XML as
<Cell><Data ss:Type="Number">0.06</Data></Cell>
BUT when I save 7% it saves to the XML as
<Cell><Data ss:Type="Number">7.0000000000000007E-2</Data></Cell>
I understand why Excel does this, but how do I go...
I have a combo box, that unfortunately has 8000 + items in it. Retarded, I know, but what can I do.
Anyway there is a check box that selects all. But when I select it and go thru the for loop that selects every value it takes a good few seconds.
Is there a quicker way to select all?
A...
Hey Guys, I was looking for the most recent result which will always be the one with the higest templateid. I do only require 1 value.
The quoteid's will always remain the same. There could be 100+ questionID's involved in the results.
this is what I came up with... but it looks horrible...
select tbl1.templateid, tbl1.answercell, tbl1.questionid, tbl1.answer, tbl1.quoteid, tbl2.screen, tbl2.guilabel from
(
SELECT A.templateid, a.answercell, A.questionid, A.ANSWER, A.quoteid
FROM PPT_Answer A
INNER JOIN
(
Select...
almost there. with your query PHV;
SELECT A.templateid, a.answercell, A.questionid, A.ANSWER, A.quoteid
FROM PPT_Answer A
INNER JOIN
(
Select max(B.templateid) AS templateid, B.questionid, B.quoteid
from PPT_Answer B inner join PPT_Question Q
on B.QUESTIONID = Q.questionID
and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.