Wednesday, March 19, 2014
Thursday, March 13, 2014
I have developed some data entry tools in Excel. It has some VBA code and uses a TreeView component to select things like crops, countries, etc.
The underlying component is from MSComCtl i.e. Common Controls. Works like a charm as this is included in “all” Office installs. Well, not in the 64 bit versions. Some users have that version installed so this will not work for them. A work-around is to use the TreeView code from Jan Karel Pieterse.
In most cases there is no good reason to use the 64 bit version of Excel. It has similar limits on the numbers of rows and columns in a sheet. It can deal with spreadsheets with many more populated cells before running out of memory.
- 64-Bit Visual Basic for Applications Overview http://msdn.microsoft.com/en-us/library/office/gg264421.aspx
- Compatibility Between the 32-bit and 64-bit Versions of Office 2010 http://msdn.microsoft.com/en-us/library/ee691831(v=office.14).aspx
- An MSForms (All VBA) TreeView: http://www.jkp-ads.com/articles/treeview.asp
- Feedback from developers: http://social.technet.microsoft.com/Forums/office/en-US/f3a71d69-580b-4cdb-ae0b-d8189e6cfd40/offce-2010-x64-edition-ships-with-x86-mscomctlocx