Office&VBA - 随笔分类 - 刘宁Toby

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

posted @ 2012-01-11 21:51 刘宁Toby 阅读(2910) 评论(0) 推荐(0)

Office:Spell Checking will not work when upgraded from 2003 to 2010

摘要：现象：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... 阅读全文

posted @ 2012-01-11 16:49 刘宁Toby 阅读(168) 评论(0) 推荐(0)

Auto fit one columns

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

posted @ 2010-06-28 17:34 刘宁Toby 阅读(190) 评论(0) 推荐(0)

Sort by one column

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

posted @ 2010-06-28 17:33 刘宁Toby 阅读(293) 评论(0) 推荐(0)

Blank Subject Warning for Outlook 2007 - CodeProject

摘要：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... 阅读全文

posted @ 2010-06-01 14:14 刘宁Toby 阅读(360) 评论(0) 推荐(0)

Excel中选中含有特定标志的checkbox

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

posted @ 2010-05-26 20:03 刘宁Toby 阅读(373) 评论(0) 推荐(0)

Close Excel process in C#

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

posted @ 2010-05-24 17:33 刘宁Toby 阅读(277) 评论(0) 推荐(0)

Get ColumnLetter by ColumnNumber in Excel with VBA

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

posted @ 2010-05-12 17:55 刘宁Toby 阅读(230) 评论(0) 推荐(0)

Application.ScreenUpdating&Application.Calculation

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

posted @ 2010-05-12 16:25 刘宁Toby 阅读(868) 评论(0) 推荐(0)

VBA-数组作参数

摘要：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) 阅读全文

posted @ 2010-05-07 17:19 刘宁Toby 阅读(2206) 评论(0) 推荐(0)

Excel2003Training(1)-浅谈Excel的５个小技巧

摘要：１．冻结窗格：锁定标题标题栏，以使标题在滚动的时候始终可见．窗口－＞冻结窗格．２．并排比较：非常方便地比较两个不同工作簿中的内容．窗口－＞并排比较．３．自动求和及其他：状态栏上右击．４．一次键入，自动填充：不用重复键入相同的列表．５．突出显示符合条件的单元格：条件格式可以让您更容易分辨出正在查找的内容．格式－＞条件格式．http://office.microsoft.com/training/Tr... 阅读全文

posted @ 2009-08-12 21:38 刘宁Toby 阅读(161) 评论(0) 推荐(0)

随笔分类 - Office&VBA