February 2006 - Posts

Saturday, February 25, 2006 10:19 AM

ASP.NET Web Matrix doesn't work after installation of VWD or .NET Fx 2.0

Seems our fellow Web Matrix users face various designer and compilation issues after the installation of VWD and .NET Framework 2.0, so it's good to recall a technique that how we can target the .NET Framework version in Web Matrix.

Colt Kwong
Posted by Colt | 1 comment(s)
Filed under:
Friday, February 24, 2006 10:55 AM

(Un)Reg VBE6.DLL or restore the default VBA Editor

As per my previous frustration about the installation of Office 2007 Beta, I'm pretty sure now that the Office 2007 crash my Excel and VB editor, because I was able to edit VBA code in editor without problem as in Office 2003 Professional, but I can't do the same after installation of Office 2007. I now even un-install Office 2007 and re-install Office 2003 (I repeated the installation of Office 2003 Pro several times) but the exception is still here and I can't edit any VBA code in Excel even I run "/safe" or "/regserver" command.



Moreover, I found one funny but contradict phenomenon about the "Detect and Repair" function in Excel (2000 or above):



Hey Mr. Excel, I start the "Detect & Repair" function from the "Help" menu in Excel, but you need me to turn off Excel before scanning of error? Then you should live outside of Excel as an independent doctor/menu.

Anyway, I'm appreciate if any of you know how I can (un)reg the VBE6.DLL or restore my original VBA Editor?

Colt Kwong
Posted by Colt | 2 comment(s)
Filed under:
Friday, February 17, 2006 6:30 PM

Programability in Excel 2007 Beta 1 is Poor

I'm quite disappointed about the programability of Excel 12 from a developer point of view, but I gave it a try again and installed the latest Office System 2007 Beta 1 today.

The security control of ActiveX and Marco are pretty strong (In short, it disable everything and we have to adjust the settings in the new "Trust Center" panel):




HOWEVER, I can't even launch the VBA editor by pressing Alt+F11 nor View Code button:




Is it a feature come with Excel 12 by default so that no one can view or execute the VBA?

Colt Kwong
Posted by Colt | 2 comment(s)
Filed under:
Monday, February 06, 2006 7:18 PM

Can I trust Visual Source Safe 2005?

Whenever I open my solution and projects in VS2005, lots of error messages come out and one of it is asking me to "analyze the Vss Db" in Vss Administration console, I did and my Vss Db is healthy:


I'm really frustrated about this message because it's not useful at all. BTW, I made 10 changes in my codes and change the "Start Up project" in Solution Explorer. However, the previous start up project still set as default when I open the solution next time. Also, only 4-5 changes were checked in to the Vss tree. The most horrible thing is the number of checked-in changes are variable. I even don't know how many changes that Vss do REALLY store and I have to double check and amend the same change again and again!

I searched the forum and noticed someone face similar problem but no resolution, and I found nothing on the support site about this topic as well. Anyone face this problem or know how to solve it?

(The solution for me right now is that I remind myself DON'T click "Save All" button and NEVER close VS2005 as these 2 actions will make my VS2005 "hang" and "lost" few of my changes.. WTH)

Colt Kwong
Posted by Colt | 4 comment(s)
Filed under:
More Posts