Serving the Quantitative Finance Community

Search found 49 matches

by FastExcel
June 13th, 2018, 4:54 pm
Forum: Programming and Software Forum
Topic: Excel Extensibility Conference Interest?
Replies: 4
Views: 5533

Re: Excel Extensibility Conference Interest?

@Cuchulainn - mid-level to expert: should have Excel development experience with one or more languages and an interest in UDFs: beginners would drown, mid-level to experts either learn about technologies they are not currently using and/or get a chance to discuss with the heavy-duty guys who wrote X...
by FastExcel
June 12th, 2018, 2:06 pm
Forum: Programming and Software Forum
Topic: Excel Extensibility Conference Interest?
Replies: 4
Views: 5533

Excel Extensibility Conference Interest?

I am thinking of running a low-priced one-day conference in London mid October on Excel programmability/extensibility with a strong focus on Excel UDFs. Speakers would hopefully include Govert van Drimmelen (Excel DNA), Tony Roberts (PY XLL and Jinx), someone from the Microsoft Excel Extensibility D...
by FastExcel
November 23rd, 2014, 10:24 am
Forum: Programming and Software Forum
Topic: Microsoft takes .NET open source and cross-platform + VS Pro now free for individuals
Replies: 35
Views: 7550

Microsoft takes .NET open source and cross-platform + VS Pro now free for individuals

<t>From an Excel perspective there is no cross-platform API, and none of the existing APIs look promising given that I don't see MSoft porting COM anywhereCOM dependent:.NET InteropVBA is Windows client (+Mac client sort of) & not going anywhere elseCOM and Automation addinsNot COM dependent:XLL...
by FastExcel
March 4th, 2013, 8:21 pm
Forum: Programming and Software Forum
Topic: EXCEL VBA declare functions packed inside DLL
Replies: 4
Views: 22204

EXCEL VBA declare functions packed inside DLL

Why not make your VB6 DLL an automation addin so that the functions can be called directly from worksheet formulas?Seehttp://www.cpearson.com/excel/automationaddins.aspx
by FastExcel
March 10th, 2012, 5:15 pm
Forum: Programming and Software Forum
Topic: Excel Binary Names
Replies: 8
Views: 15932

Excel Binary Names

<t>Hmmm... Can you append to an XLS file whilst its open? I thought it was locked.Currently investigating xmlCustomParts, works OK except that its not available directly from the XLL api and also only XL 2007 onwards.Interestingly you can write to xmlCustomParts from within an automation UDF which o...
by FastExcel
February 22nd, 2012, 7:24 pm
Forum: Programming and Software Forum
Topic: Excel Binary Names
Replies: 8
Views: 15932

Excel Binary Names

<t>The unordered map works well with Boost locking so that multithreading works. I am just trying to work out how to persist the Map at Save and Open Time. I could use a hidden sheet, but that won't work if the structure is protected, or store externally to the workbook, but that has problems if the...
by FastExcel
February 17th, 2012, 3:12 pm
Forum: Programming and Software Forum
Topic: Excel Binary Names
Replies: 8
Views: 15932

Excel Binary Names

<t>I need to persist an unordered map in a saved Excel workbook. One possibility is to use Excel's binary names (xltypeBigData) but there seem to be a lot of limitations (active sheet only, bugs in Excel 2007 and 2010, ...).Before I invest the time in trying to work through the problems, has anyone ...
by FastExcel
January 7th, 2012, 7:09 pm
Forum: Programming and Software Forum
Topic: VBA Wrapper/UDF/Excel Dependency Tree Problem
Replies: 4
Views: 18729

VBA Wrapper/UDF/Excel Dependency Tree Problem

<r>One reason your VBA UDF is very slow is probably because you have not bypassed the VBE refresh buf: this will slow down your VBA UDFs by a factor of 10 or more.See writing-efficient-vba-udfs-part-3-avoiding-the-vbe-refresh-bug <URL url="http://fastexcel.wordpress.com/2011/06/13/writing-efficient-...
by FastExcel
July 25th, 2011, 9:28 am
Forum: Programming and Software Forum
Topic: How to disable Excel function wizard evaluating function?
Replies: 4
Views: 25599

How to disable Excel function wizard evaluating function?

In VBA you can use this method to exit the function:If (Not Application.CommandBars("Standard").Controls(1).Enabled) Then Exit Function
by FastExcel
January 28th, 2011, 3:02 pm
Forum: Programming and Software Forum
Topic: Excel 2007: Slow VBA
Replies: 13
Views: 26317

Excel 2007: Slow VBA

And make sure you have disabled the Google Office Com addin and toolbar.
by FastExcel
January 27th, 2011, 1:43 pm
Forum: Programming and Software Forum
Topic: Excel 2007: Slow VBA
Replies: 13
Views: 26317

Excel 2007: Slow VBA

<r>Excel 2007 VBA has a higher overhead per VBA/Excel data transfer call than previous versions, so the advantage of transferring data in large blocks using arrays is even greater with XL 2007.Make sure you are using Excel 2007 SP2 (SP2 contains a VBA speedup fix).My timings for your benchmark (scre...
by FastExcel
May 6th, 2010, 10:26 am
Forum: Programming and Software Forum
Topic: Distributing Excel Add-ins
Replies: 7
Views: 31117

Distributing Excel Add-ins

<r>I use an automatically reversioning add-in loader.You install the small addin loader on the users PCs and it then loads the latest version of the real addin from a shared location.There is a fully working customisable demonstration version of this on my downloads page:<URL url="http://www.decisio...
by FastExcel
January 11th, 2010, 10:48 am
Forum: Programming and Software Forum
Topic: Future of VBA for Finance World
Replies: 10
Views: 41046

Future of VBA for Finance World

<r>Here is an article discussing some of the compatibility issues between 32-bit office and 64-bit office.<URL url="http://msdn.microsoft.com/en-us/library/ee691831%28office.14%29.aspxYou"><LINK_TEXT text="http://msdn.microsoft.com/en-us/library ... 4).aspxYou">http://msdn.microsoft.com/en-us/librar...
by FastExcel
January 6th, 2010, 2:27 pm
Forum: Programming and Software Forum
Topic: Future of VBA for Finance World
Replies: 10
Views: 41046

Future of VBA for Finance World

There is even a new 64-bit version of VBA in the Excel 2010 64-bit version ...
by FastExcel
December 10th, 2009, 8:58 pm
Forum: Programming and Software Forum
Topic: FIVE hundred years from now: can you predict the Software Landscape in anno 2525?
Replies: 858
Views: 386927

Three years from now: can you predict the Software Landscape in anno 2018?

<t>64 bit Excel does support VBA - but not VB6> The brain damaged decision not to support VBA in 64 bit Excel means that very few people will have migrated into it, and those> few firms the have put it on the trading desk will be getting DefCon 2 grade grief from users.I can't see too much traction ...