I just finished setting up the latest mv.NET v3.5.1.2 and used the Data Manager to create simultaneous connections to multiple MV environments. I dunno if other people get as much of a kick out of this as I do but just the ability to do this tickles me.
On another blog I read which focuses on Excel, the author is wondering whether he should keep the Archives sidebar (to the right) with the list of links by Month/Year. I’m wondering about that too.
The first note I wrote on this topic was back in May of 2006. A recent forum inquiry asked about the merits of VMware to host MV DBMS software. I thought I’d take the opportunity to post a follow-up to the original posting with an update of how I’m using virtualization today.
In Part 5 of this unintended series I provided complete details on how to create an Excel Automation Add-in using the COM Shim Wizard from Microsoft. It works for development, not for deployment. I’ve found that in the deployment system some registry keys are missing.
I seem to have drummed up a little passion from people still suffering over at my former web host PowWeb. Check here for referrals to my current hosts.
I’ll tell you when I do stuff that’s cool, and when I do stuff that doesn’t quite work at all. Looks like I’m stuck on another issue with .NET. I’ll have to do something cool just to make up for all the bad news lately.
This is a good question posed in an MV forum. I think this question and answer are good for a more general audience so I’m responding here.
It’s time to call it quits for now. Yup, I give up. I’ve killed an entire week on this, well over 100 hours. I have clients that need attention and this project isn’t earning its keep. The code is working great on development systems but I can’t get it to work properly on a non-development workstation. I’m am closing this […]
Andrew Whitechapel’s generous bloggings on Automation Add-ins and shims are chock full of helpful information. Unfortunately the blog entries are also over two years old and I’ve just found out the code details are no longer valid.
The task is to create an Excel User Defined Function with managed .NET code. It seems so far that the way to go is with shims which proxy COM requests from Excel and separate the managed code into its own application domain for security and stability. This short article summarizes how I’ve come to that conclusion.
I’m continuing my notes here for anyone else who needs to tread through this minefield. At the moment my code is working great on systems that have Visual Studio installed, but not on another test system without VS. Sigh. That means I can’t deploy this code yet. See the Summary in this article for the current status, and see the […]
If you’ve been reading my other blog entries, you know I’ve been working a lot with Excel lately. I worked intensely with this environment several years ago. I’ve found all of the Microsoft Office applications to be fun to work with at the object model level – OK, call me a geek. Unfortunately MS Office apps have always been far […]
A long time ago there was a product called CrowFlight that retrieved data into Excel from MV. Some companies still have it and I occassionally get a call from someone looking to replace it. Well… I now have two ways of using Excel formulas to call into MV, and this functionality can be combined with NebulaXLite.
I’m highly amused at attempts I’ve seen in public forums to munge email addresses.
We released a new product today, though it’s been on the website for about a month to start drumming up interest – and that it did. NebulaXLite allows MV BASIC to create "real" Excel workbooks – and it seems to work with OpenOffice and Google Doc Spreadsheets too! We also have a new forum to discuss our product and service […]
I’m updating my map with bits I get from here and there. Unless someone thinks it’s important for me to continue this effort, I’m only going to update once or twice a day now. I’ll leave this topic with some (uncommonly?) direct comments on how people view events like this.
There are power fluctuations so the network and phones keep going down. Seems like it’s only happening in one part of the building – weird. We’re a couple miles from the action but the air is rich with the smell of burning wood and some people are having issues with it irritating their eyes and minor throat irritation. I’m having […]
As of this moment it doesn’t look like the Santiago Canyon fire will be contained anytime soon.
There is only one fire in this area at the moment. I’m posting a map showing the location of the fire and local MV businesses.
This is a response to an inquiry in the U2 tech forum about the need to use [Worksheet$] syntax in a SQL query, and the idea that an Excel worksheet is treated like a System Table. This isn’t really a U2 topic so I thought I’d tackle it here.