Recent content by Sniipe

I'm using .net to process the XSLT into XML

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?

<tr> <td>Are you happy?</td> <td><input type="radio" name="2" value="4" can_run="true"/></td> <td>Yes</td> <td><input type="radio" name="2" value="5" can_run="true"/></td> <td>No</td> <td><input type="checkbox" name="2" checked/></td> </tr> I'm creating the above code...

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...

thanks Randy, that was it, but how come I didn't get the warning? How do I turn it on?

I'll give that a try joe when I get home, but any idea why it won't insert the row when I use the MS access SQL command?