摘要： Issue: While requesting an application hosted in IIS 7.0 from the IE, sometime we may get an error message which is not so helpful for us to diagnostic the problem. see screenshot below: Solution: ... 阅读全文

摘要： 现象: OneNote 中无法输入中文. 解决: C:\Users\“你的用户名”\AppData\Local\Microsoft\Office下有个OneNote.officeUI的文件，删除 阅读全文

摘要： 现象：spell checking in office 2010 will not work if your office 2010 was upgraded from office 2003. 原因：This is caused by a register item of office 2003. you should delete it manually. the item is locat... 阅读全文

摘要：   出处：http://gaizai.cnblogs.com/ 阅读全文

摘要： Columns("A:A").Columns.AutoFit 阅读全文

摘要： 'Sort Group, SubGroup, Project Worksheets("Groups").Activate Range("B3:Z65536").Select Selection.Sort Key1:=Range("I3"), Order1:=xlAscending, Header:=xlNo, _   ... 阅读全文

摘要： Blank Subject Warning for Outlook 2007 – CodeProject   Introduction Nowadays, in the professional world, Outlook is most popularly used as the email client. The subject line is a very importan... 阅读全文

摘要： Sub SelectAllGroupsClick() Application.EnableEvents = False Application.ScreenUpdating = False Application.Calculation = xlCalculationManual ActiveSheet.Unprotect Dim i i = 0 For Each oCheck In Active... 阅读全文

摘要：   [DllImport("User32.dll", CharSet = CharSet.Auto)]   public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);   public static void shutExcel(Excel.Applicat... 阅读全文

摘要： 1.1.1. The initial default directory is the user's temp directory. After the first time any file is opened or saved, the default directory will be whichever directory was last used. this.openFileDial... 阅读全文

摘要： Sometime we can get ..\bin\Debug by using Environment.CurrentDirectory or System.Windows.Forms.Application.StartupPath. So what’s the difference? I suggest that you use System.Windows.Forms.App... 阅读全文

摘要： 如果我想在代码里频繁使用一段代码，比如说在调试的时候我经常会用到： System.Diagnostics.Debug.WriteLine("Method" + "Start" + DateTime.Now.ToString("yyyy-MM-dd:hh-mm-ss-fff")); 如果每次手动会很枯燥并且降低开发效率。考虑到VS有代码... 阅读全文

摘要： Function GetColumnLetterByColumnNumber(ColumnNumber As Integer) As String   If ColumnNumber > 26 Then     ' 1st character:  Subtract 1 to map the characters to 0-25,  ... 阅读全文

摘要： 处理大数据量时，为了更快的运行，VBA通常在开始加两句 Application.ScreenUpdating = False Application.Calculation = xlCalculationManual 结尾处再恢复 Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True c... 阅读全文

摘要： Function Tidy(ByRef sheets() As Worksheet)Dim value As ObjectDim rang As Excel.RangeDim isNum As BooleanDim sheet As WorksheetFor k = 0 To UBound(sheets) '获取数组长度Set sheet = sheets(k) 阅读全文

摘要： 在性能调优的过程中，经常要计算一个方法执行的时间，我们可以在方法前后加上如下一句：Debug.WriteLine("Method" + "Start" + DateTime.Now.ToString("yyyy-MM-dd:hh-mm-ss-fff"));Method();Debug.WriteLine("Method" + "End" + DateTime.Now.ToString("yyyy-... 阅读全文

摘要： 代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--1<!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.1//EN""http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">2... 阅读全文

摘要： 在vs中编辑代码过程中，可以通过快捷键 Ctrl+W+W快速切换到ie。 阅读全文

摘要： To create a performance session for an open projectOn the Tools menu, point to Performance Tools, and then click Performance Wizard.From the Which of the following available targets would you like to ... 阅读全文

摘要： Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--1.Try using arrays insteadArrays will generally be more efficient in terms of access speed and memory ... 阅读全文