SERVING THE QUANTITATIVE FINANCE COMMUNITY

Search found 49 matches

by FastExcel
June 10th, 2008, 5:59 pm
Forum: Programming and Software Forum
Topic: Excel: Automatic expansion of array functions
Replies: 2
Views: 57085

Excel: Automatic expansion of array functions

Application.Evaluate treats all unqualified references as belonging to the active sheet, try using Worksheet.Evaluate instead:ThisValue = Thisrange.Parent.Evaluate(ThisFormula)
by FastExcel
May 21st, 2008, 7:06 am
Forum: Programming and Software Forum
Topic: Migrate from VBA to VSTO
Replies: 5
Views: 55394

Migrate from VBA to VSTO

<t>I see no evidence to suggest much use of VSTO at present, or of any trend to move from VBA to VSTO. The target market for VSTO at the moment seems to be .net developers who need to make incidental use of Office within a .net application.Perhaps the next version of Excel (14) and the next version ...
by FastExcel
May 19th, 2008, 12:23 pm
Forum: Programming and Software Forum
Topic: Migrate from VBA to VSTO
Replies: 5
Views: 55394

Migrate from VBA to VSTO

And according to Kaspersky there have not been any new/changed Excel Macro viruses found since 2002.
by FastExcel
May 19th, 2008, 9:26 am
Forum: Programming and Software Forum
Topic: Migrate from VBA to VSTO
Replies: 5
Views: 55394

Migrate from VBA to VSTO

<t>Pity the article does not mention the appalling performance of the marshalling layer, the installation/distribution problems, and does not seem to know how to use XLAs.If I wanted to use .net with Office I would use something like ManagedXLL, but I suppose if I was a .net developer who did not kn...
by FastExcel
April 23rd, 2008, 7:14 am
Forum: Programming and Software Forum
Topic: On Excel Shift-F9, F9 and friends
Replies: 3
Views: 60046

On Excel Shift-F9, F9 and friends

<t>What you are observing is that Shift-F9 and Sheet.Calculate do not clean dirtied cells but F9 and Application.Calculate (also CalculateFull and CalculateFullDependencyRebuild) do.So if all you use is Shift-F9 then the number of cells calculated on that sheet will never decrease in subsequent Shif...
by FastExcel
February 29th, 2008, 7:37 am
Forum: Programming and Software Forum
Topic: How can I use multi-core CPUs with Excel VBA?
Replies: 1
Views: 60992

How can I use multi-core CPUs with Excel VBA?

VBA is only single-threaded so wont use more than 1 core.You can write multithreaded functions for Excel 2007 using c/c++
by FastExcel
February 28th, 2008, 8:36 pm
Forum: Programming and Software Forum
Topic: Help on VBA public function!!!
Replies: 4
Views: 58939

Help on VBA public function!!!

<t>If you want to return a range object useset ABC=Sbut I think you want to return an array soDim vArrS as variantdim varrP as variantVarrs=S '' coerce S to a variant arry containing the values from SAbc=varrsthen you would need to enter the function as an array unction, or feed it to an array-aggre...
by FastExcel
February 15th, 2006, 9:11 am
Forum: Programming and Software Forum
Topic: XL CheckAbort
Replies: 1
Views: 118617

XL CheckAbort

Application.Checkabort was introduced in Excel 2002, but I have not been able to work out what it does.help says 'stops recalculation except for specified cell'It does not seem to do this, in fact I cannot detect any effect of this method at all, but it must do something.Any ideas?
by FastExcel
September 21st, 2005, 1:31 pm
Forum: Programming and Software Forum
Topic: Why use XLL?
Replies: 10
Views: 136284

Why use XLL?

<t> >The two big areas where .XLLs provide features that COM cannot are with calculation dependencies and optional arguments.<Actually you can handle both of these with VBA User defined Functions (UDFs)to detect from within a UDF if an input cell has not yet been calculated use:if ISEMPTY(Cell.Value...
by FastExcel
March 8th, 2005, 7:58 am
Forum: Programming and Software Forum
Topic: High-Res timer for Mac Excel
Replies: 0
Views: 156554

High-Res timer for Mac Excel

Anyone know how to get high-resolution (microseconds preferably) timing info in Mac Excel VBA (for Windows I use API call)?
by FastExcel
February 7th, 2005, 3:41 pm
Forum: Programming and Software Forum
Topic: Slow excel from lots of data!
Replies: 18
Views: 167530

Slow excel from lots of data!

Not sure what you mean by space (disk space, memory used, calculation time or something else)but the answer (sorted worst to best) is 3,2,1
by FastExcel
January 31st, 2005, 10:33 am
Forum: Programming and Software Forum
Topic: Slow excel from lots of data!
Replies: 18
Views: 167530

Slow excel from lots of data!

<r>The best thing to do is to find out which parts of your sheet are consuming the most Excel calculation time, and then work on optimising the calculation methods and formulae.Usually it is possible to speed up slow excel sheets by significant factors.check out my website for some suggestions.<URL ...
by FastExcel
November 5th, 2004, 3:44 pm
Forum: Programming and Software Forum
Topic: MS Access tutorials for finance
Replies: 18
Views: 170404

MS Access tutorials for finance

<t>Access (or its Jet engine (OK preferably MSDE)) is OK for storing and retrieving time series, its just crap at doing any processing on them. You can build a decent system that uses Excel or VB or whatever to do the time series analysis/forecasting/etc and uses the DB via DAO/ADO as a time series ...
by FastExcel
October 22nd, 2004, 6:02 am
Forum: Programming and Software Forum
Topic: VBA Programming Question
Replies: 6
Views: 171579

VBA Programming Question

You can do it using variants:Sub RaggedVar()Dim vArr(4) As VariantDim vArr2(6) As VariantvArr2(2) = "Fred"vArr(1) = Array(1, 2, 3, 4)vArr(2) = vArr2MsgBox vArr(1)(1)MsgBox vArr(2)(2)End SubRun the above in debug mode and look at Varr in the locals window to see whats happening.
by FastExcel
September 23rd, 2004, 9:22 am
Forum: Programming and Software Forum
Topic: XLA question
Replies: 2
Views: 173817

XLA question

<r>Another approach is to use a stub xla which opens the latest version of the real xla. That way you can create and test a new version whilst others are using the previous, and the next time they open Excel they will automatically get the latest one.there is a working example of this with customisa...
GZIP: On