Remove All VBA Code Programmatically

Thu, 08 Apr 2010 20:53:01 +0800

Option Explicit Sub DeleteAllCode() 'Trust Access To Visual Basics Project must be enabled. 'From Excel: Tools | Macro | Security | Trusted Sources Dim x As Integer Dim Proceed As VbMsgBoxResult Dim Prompt As

Excel 2007 (Excel.Application) Workbooks.Add 出现内存不够的解决办法

Wed, 31 Mar 2010 12:54:20 +0800

[问题 Issue]
Workbooks.Add时,会出现以下错误:

Microsoft Office Excel 错误 '800a03ec'

内存或磁盘空间不足，Microsoft Office Excel 无法再次打开或保存任何文档。
? 要想获得更多的可用内存，请关闭不再使用的工作簿或程序。
? 要想释放磁盘空间，请删除相应磁盘上不需要的文件。

Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space.
? To make more memory available, close workbooks or programs you no longer need.

Can not access Excel file using OpenRowset

Thu, 11 Feb 2010 12:34:32 +0800

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Providers\Microsoft.Jet.OLEDB.4.0

NOTE: With the DisallowAdHocAccess property set to 1, SQL Server does not allow ad hoc access through the OPENROWSET and the OPENDATASOURCE functions against the specified OLE DB provider. If you try to call these functions in ad hoc queries, you will receive an error message similar to:

用VS2005开发COM 组件

Thu, 11 Feb 2010 12:34:04 +0800

1, 添加引用
using System.Runtime.InteropServices;

2, 在类名前加上
[ProgId("Shanger.Sunrise")] //Com调用的名字
[Guid("CAF9E079-7A4F-46ac-9516-9A5CCAB41ABD")] //设置GUID
Guid 可以在工具-> 创建 Guid里得到

3, 设置Com可见
双击 "解决方案管理器>项目名>Properties", "应用程序">"程序集信息">"使程序集Com可见"
.或者.
AssemblyInfo.cs里修改: [assembly: ComVisible(true)]
效果一样的.

4. 本机调试(可选)
"解决方案管理器>项目名>Properties", "生成"标签里选"为 COM Interop 注册"

5. 部署
还没做,以后再讲.

Simplified and Extended Data Binding Syntax in ASP.NET 2.0

Thu, 11 Feb 2010 12:33:16 +0800

Introduction

The server-side data binding techniques that were introduced in ASP.NET version 1.0 revolutionized the way developers build pages that access data. No longer was there a requirement for complex and lengthy code sections that build up HTML tables or lists of values. However, using ASP.NET 1.x, you still have to write code to perform the data access and expose the data to the

Select data from an Excel sheet in MSSQL

Thu, 11 Feb 2010 12:32:20 +0800

select *
from openrowset('Microsoft.Jet.OLEDB.4.0'
,'Excel 8.0;HDR=YES;IMEX=1;DATABASE=d:\folder\excel.xls',Sheet1$)

-------NOTE------

Setting IMEX=1 tells the driver to use Import mode. In this state, the registry setting ImportMixedTypes=Text will be noticed. This forces mixed data to be converted to text. For this to work reliably, you may also have to modify the registry setting,

FTP via ASP without using 3rd-party components

Thu, 11 Feb 2010 12:31:22 +0800

<%@ Language=VBScript %>
<%
' FTP via ASP without using 3rd-party components
' Ben Meghreblian 15th Jan 2002
' benmeg at benmeg dot com / http://benmeg.com/code/asp/ftp.asp.html
'
' This script assumes the file to be FTP'ed is in the same directory as this script.
' It should be obvious how to change this (*hint* change the lcd line).
' You may specify a wildcard in ftp_files_to_put (e.g. *.txt).

'

网页制作之在线视频播放代码

Thu, 11 Feb 2010 12:27:05 +0800

站长说明：

1.avi格式

How to load HTML into mshtml.HTMLDocumentClass with UCOMIPersistFile and my ignorance

Thu, 11 Feb 2010 12:26:26 +0800

What a weird one. I'm looking at the source for NDoc.Document.HtmlHelp2.Compiler.HtmlHelpFile. It uses the Microsoft.mshtml interop Assembly to load an HTML file into the HTMLDocumentClass for easy parsing.

It's code looks like this (DOESN'T WORK):

private HTMLDocumentClass GetHtmlDocument( FileInfo f )

JPivot易用性修改

Thu, 11 Feb 2010 12:26:07 +0800

mondrianQuery TAG 修改

scriplet 输出MDX查询支持
修改 TLD文件中 mondrianQuery TAG 的 body-content 为JSP
修改 MondrianOlapModelTag 的父类 com.tonbeller.jpivot.tags.OlapModelTag
为其加入 doStartTag 方法,返回EVAL_BODY_BUFFERED，
使之在 getBodyContent 之前先对 scriplet 进行处理。
ex：public int doStartTag(){return EVAL_BODY_BUFFERED;}