looks helpful and interestingI bookmarked it.

<t>HelloI think you should give enough time to complete UpdateBloombergLinks before calling Application.Quit.'API declaration to suspend operation for a specified time (Milliseconds)Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)Sub OpenAndUpdate() Application.OnTime (Now + T...

<r>Application.Volatile is related to the calculation on UDFs. Plz <URL url="http://www.dailydoseofexcel.com/archives/2004/06/22/volatile-functions/and"><LINK_TEXT text="http://www.dailydoseofexcel.com/archive ... ctions/and">http://www.dailydoseofexcel.com/archives/2004/06/22/volatile-functions/and...

<t>HelloI contributed the orthogonal regression code to your website in 2005.For many years I've been interested in writing vba codes related to the financial solutions.I'm wondering what the partnership is in detail.Please let me know that more. My email address is sjoo.kwak at gmail.com.Best Regar...

Hi the short key as I know is Ctrl+1 that shows the dialogbox of the cell format. I'm wondering what your vba is. In addition, Ctrl+Tab enables you navigate opened workbooks.Bye

Hi EveryoneI happened to watch a video clip from YouTubeIt's another "Let it be"Write in CHave funSjoo

<t>Hi LateThe first:You're right! the Worksheet_Change event is triggered only when a user changes a value. You can solve the trouble with an event procedure of DropDown as following:'///////////////////////////////////////Sub DropDown1_Change() Dim rng As Range Set rng = Sheet1.Range("selectedtext"...

Hi RC266plz refer to http://homepage.hispeed.ch/FinCalc/Index.htmit's not an open source excel-addin but you can pick up the knack of how to build up the curve just by it HTH

<r>Hi nuclphyou have the same wish that i had several years ago.i wanted a powerful matrix addin for microsoft excel.and considered using a dll that is compiled with newmat lib.if you want a matrix addin for excel,plz refer to <URL url="http://digilander.libero.it/foxes/index.htm">http://digilander....

<t>Hi tquant,I don't understand why the code shoulde be in the sheet object.If modules allowed, you can write the code as follows:'// enable your procedure to run by pressing shift+F9 Sub StartIt() Application.OnKey "+{F9}", "Procedure1" End Sub'// restore the function of shift+F9Sub StopIt() Applic...

Hello Y0dai have a pdf file named 'Programming Option Pricing Financial Models with Ct'i think this would be helpfulhttp://pds8.egloos.com/pds/200807/08/36/Ct-appnote-option-pricing.pdf

hello everyoneon the way of studying some theories about pricing options,a stupid question came across to me,"why should i know or calculate the theoretical price of option?"thanks in advance

Hello I'm wondering how to utilize multi-core CPUs(Intel's core2duo, core2quad etc) at Excel VBA.Do I should write an addin for excel with c/c++?I found a video clip showing how fast the core2cpu is at Excel 2007. Intel Core2Duo Processors Running Microsoft Excel

wow, very interesting...i've used vba for 12 years, but it's not in the map.after seeing the map, i need to resume python programming or c/c++.thank you for the interesting map.----------sjoo