Programming

bond convexity
Is their a simple addin function for bond convexity available or a reduce form equation I can add to excel? ... 23 Dec 2005 17:01

How do I get the current Excel CustomView in VB
... 22 Dec 2005 09:25

Possible to sort part of a cell?
I have a column with email addresses in the format: firstname.lastname(a)whatever.com. Is it possible to sort these in order based on the last name? -- helios02 ------------------------------------------------------------------------ helios02's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=297... 20 Dec 2005 19:55

Visual Basic
I've never got to grips with Visual Basic, although I used to be fairly happy with macros. Are there any good web-sites, or can anyone point me in the right direction, to learn about this subject? Many thanks, Will ... 15 Dec 2005 10:06

Macro with Essbase Add-in
Hello All, I have a query setup in Excel that retrieves data from Hyperion using the Essbase Add-In. Can anyone please show me how to write code that will initiate the Retreive Data function automatically. I have a macro with input boxes that will prompt the user to change the dimensions, but I do not know ... 15 Dec 2005 11:08

ADODB Timeout
I'm trying to use the following ADODB connection string to retrieve a dozen records from a MS SQL Server database. Everytime I run the routine, I get a Timeout Expired error even though I'm using the ConnectionTimeout = 0 in my connection string. Any thoughts as to why this is happening? TIA Mark P... 8 Dec 2005 12:56

Sql Query
Hello, I record a New Database Query inside excel, and record macro that runs the query as below. How can I run the Sql Command text without running Open File *.dbq ? Workbooks.OpenDatabase Filename:= _ "G:\Help.dqy", CommandText:=Array( _ "SELECT `ADC_Parts$`.Mfg, `ADC_Parts$`.`Part Number` FROM `G:\A... 28 Nov 2005 21:50

Lunar or Chinese Calendar
Dear all, I am from Vietnam where lunar calendar is also popular. For example 23 Nov 2005 is equal to lunar date of 22 Oct 2005. Could any one help me to create lunar calendar or how to convert to lunar date. Thanks a lot! Nam -- lehainam -------------------------------------------------------------... 24 Nov 2005 03:25

Product Key
Wil anyone help me with the product key for Microsift Office 2003 Standard Edition -- Zakes ------------------------------------------------------------------------ Zakes's Profile: http://www.hightechtalks.com/m296 View this thread: http://www.hightechtalks.com/t2288893 ... 18 Nov 2005 04:49

Checkbox locked and will not unlock
Hello I have a checkbox that i only want to become unlocked when a number is put in this is my code Private Sub CheckBox1_Click() If ("N22") = "1" Or "2" Or "3" Then CheckBox1.Value = False CheckBox1.Enabled = False Else CheckBox1.Value = False CheckBox1.Enabled = True End If End Sub But it on... 13 Nov 2005 16:28