From other forums, I have learned that it is due to the MS Update and that a good fix is to simply delete the file MSForms.exd from any Temp subfolder in the user’s profile. For instance: C:\Users\[user.name]\AppData\Local\Temp\Excel8.0\MSForms.exd C:\Users\[user.name]\AppData\Local\Temp\VBE\MSForms.exd C:\Users\[user.name]\AppData\Local\Temp\Word8.0\MSForms.exd Of course the application (Excel, Word…) must be closed in order to delete this file.
There is [eternal] confusion surrounding the two types of controls available to Excel — exacerbated by the contrasting terminology used by different online sources. This is only a general overview of the differences between Form Controls and ActiveX Controls (based on my old notes that helped me finally figure out the differences!) Visit the included … Read more
You can definitely do this, the code looks like: var objO = new ActiveXObject(‘Outlook.Application’); var objNS = objO.GetNameSpace(‘MAPI’); var mItm = objO.CreateItem(0); mItm.Display(); mItm.To = p_recipient; mItm.Subject = p_subject; mItm.Body = p_body; mItm.GetInspector.WindowState = 2; p_recipient, p_subject & p_body being variables, passed in. You need to ensure this is running on a webpage which users … Read more
The problem might be that you try to run msiexec.exe and this exe is not in the cab file. See this question (be sure to scroll down to the incredibly helpful sample code posted by Roey 5 Aug 2009). Try to either create a setup.exe that will run process msiexec.exe and install your msi or … Read more
IE displays a active x warning and ask for permission if you allow it to run or not. To overcome this the only solution is to; Open Internet Explorer. Click the Tools menu, and then click Internet Options. On the Security tab, click the Custom level button. Scroll down the Security Settings list until you … Read more
First you have to install the wonderful pywin32 module. It provides COM support. You need to run the makepy utility. It is located at C:\…\Python26\Lib\site-packages\win32com\client. On Vista, it must be ran with admin rights. This utility will show all available COM objects. You can find yours and it will generate a python wrapper for this … Read more
I was able to get this working using the following script block format, but I’m still curious if this is the best way: <script for=”MyControl” event=”ReceiveMessage(msg)”> alert(msg); </script>
And for an easy way to inject that magic line of javascript, read how to inject javascript into webbrowser control. Or just use this complete code: private void InjectAlertBlocker() { HtmlElement head = webBrowser1.Document.GetElementsByTagName(“head”)[0]; HtmlElement scriptEl = webBrowser1.Document.CreateElement(“script”); string alertBlocker = “window.alert = function () { }”; scriptEl.SetAttribute(“text”, alertBlocker); head.AppendChild(scriptEl); }
I couldn’t find solution for other browsers. When I posted this question, IE was on the higher priority and gladly I found one for it. If you have a solution for other browsers (firefox, safari, opera) please do share here. Thanks. VBSCRIPT is much more convenient than creating an ActiveX on VB6 or C#/VB.NET: <script … Read more
Google is full of information on this. As Hans Passant said, Form controls are built in to Excel whereas ActiveX controls are loaded separately. Generally you’ll use Forms controls, they’re simpler. ActiveX controls allow for more flexible design and should be used when the job just can’t be done with a basic Forms control. Many … Read more