Archive for category 10_资源信息
Set up your own Desktop Wiki
You must know Wiki, from it, you can know many things. Have you think of Set up a desktop wiki system to record your private things? Well, there are many desktop wiki system, while what I use is Moin.
The following are steps you can set up a desktop wiki. you can find Moin at http://moinmo.in/.
step1. install python-2.6.3.
step2. extract moin-1.8.5.tar
step3. run "wikiserver" in file moin-1.8.5.
step4. run http://127.0.0.1:8080 in IE.
窗体控件和控件工具箱控件
在Excel中有两种不同的控件。窗体控件和控件工具箱控件。
一种是窗体工具条控件（Forms toolbar controls），菜单“视图”→“工具栏”→“窗体”工具条控件窗口。
另外一种是控件工具箱控件（ActiveX控件），菜单“视图”→“工具栏”→“控件工具箱”（也可以选择“Visual Basic”，然后再在工具栏上选择“控件工具箱”），将出现“控件工具箱”窗口。
窗口工具条控件是Excel5和Excel95留下来的东西（在Excel 97后的版本中，添加一个Dialog Sheet后，将可以看到这个窗体工具条窗口），从Excel 97开始，Dialog Sheet被UserForm代替，并且开始使用ActiveX控件。
控件工具箱控件是用户窗体上的控件子集，这些控件只能用于Excel 97或更高版本的Excel中。
窗体控件比ActiveX控件简单，基本上只有一个Click事件。而ActiveX控件可以响应丰富的事件，ActiveX控件的事件只能放在控件所在的类模块（工作表模块）或窗体模块。过程名称由控件名和事件名称组成。如果你在控件不存在的时候就创建这个控件的事件过程，然后再在代码中引用这个控件，将会出现编译错误，所以必须使用代码创建事件过程。
Everything，你一定要用的软件
今天和Calvin碰面，看到他在用一个搜文件的小软件。要了过来，这东西实在是太好了，要和大家一起分享。
嗯，不调大家胃口了，说一下这软件干嘛的吧。
用来搜你的电脑上的文件，它支持搜文件名和文件夹名。它的搜索速度（即输即得）和占用空间（索引不到1M，如果超过，那你的文档也太。。。太。。）实在太令人惊讶了。
你还可以在这个软件中进行打开文件、删除文件的操作。
而且，它还是绿色的哟。
当然，如果你一定要那种支持搜文档里面内容的搜索工具，还是去下载一个google desktop search 或者百度硬盘搜霸吧。
这个软件叫啥？就叫Everything。
到哪下载？不麻烦了，我上传一个到这里吧。
关于Excel VBA的程序说明
Excel vba的程序又根据有无执行对象分为过程程序和事件程序。
过程程序简单的说就是通过代码完成一个任务。它和事件程序的主要区别就是它没有明确的服务对象，但可以被其他程序所调用。过程程序又根据是否有返回值分为以下两种。
1. 子过程程序：运行后不能返回值。
2. 函数过程程序：运行后能够返回值。
自定义函数一般存放在添加的模块中，但也可以存放在指定对象的（如工作表对象）的代码窗口中。不同的是，在模块中的函数可以在任何一个程序中调用，而存放在对象代码窗口中的函数只能被本代码窗口内的程序所调用。如果要变下在工作表公式中使用的函数，就必须在添加的模块中编写。
事件程序是指当某一特定事件发生时才执行的程序。例如，当选取单元格时触发某个程序的运行。选取单元格的动作就是一个事件。使用事件程序的好处是极大增强了操作者与程序的互动性。
事件程序的添加和过程程序有所不同。事件程序有指定的对象，所以添加前要先选取该对象并打开该对象的代码窗口，然后在代码窗口的对象列表中选取该对象或该对象的子对象。并在过程列表中选取需要的事件。在代码窗口内会自动添加该程序的开始和结束语句。
在使用电脑时保护好眼睛[转]
以下内容转自网络，最原始出处已失。我已经把我的电脑的背景颜色给修改了。你不妨试试。
眼科医生建议PC屏幕不要用白色，因为白色对眼睛的刺激是最大的，眼科医生推荐的颜色是淡绿色！只要稍微设置一下，就能让电脑的窗口从白花花的颜色变成淡淡的绿色。设置方法：
窗口的设置
打开控制面板中的 显示 – 外观 – 高级(D)，然后在 项目(I) 那栏选窗口，再点颜色－其它，然后把色调设为85，饱和度设为90，亮度设为205，点击确定。
网页背景的设置
打开IE，点击 工具 – Internet选项，点右下角的 辅助功能(E) ，勾选不使用网页中指定的颜色，然后点确定。
文献阅读器的设置
CAJViewer 7.0中：点击 工具 – 参数设置 – 颜色，点击 页面默认颜色 – 背景右边的小三角，选 更多颜色 – 自定义，输入相应数值，点击确定。
Adobe Reader 8.0中：点击 编辑 – 首选项(N)… ，点击 辅助工具，选中替换文档颜色，点击 自定义颜色 – 页面背景的颜色按钮，选中其它颜色，输入相应数值，点击确定。
How to find Academic paper you want?
When writing academic paper, you have to take time reading many articles. you will use some databases, such as EBSCOhost, ProQuest, Springer, and so on, to search relative paper and see what others have done.
However, you encount the situation aht you can’t find the full article of the paper, you only find the summary in the database, so, what to do?
Taking the following articles for example.
Title: Accounting for performance variation – how important are intangible resources
Author: Jeremy Galbreath, etc.
1. Try another database; EBSCOhost, not found; ProQuest, limited; Springer,not found;
2. http://scholar.google.com, limit the entire words, yes. see here : http://scholar.google.com/scholar?q=%22Accounting+for+performance+variation%22&hl=en&lr= click the URL and you can get the paper you want. Wola! I get it.
Well, it’s really a tough task for me to write graduate thesis.
Some useful websites for refer:
www.lib.shufe.edu.cn, school library is always the most important web for academic research.
http://en.wikipedia.org, I can know many new terms from it.
http://scholar.google.com/ , it’s easy to find some articles without login in any academic database.
https://portal.acm.org, with limited but free account, some articles can be download from it.
飞信聊天记录的导出
囧，中国挪动的飞信，居然不能直接导出聊天记录。
google了一下，发现了一个方法，网上有高人呀。请登陆下面的链接吧，具体方法见该页面。
Some software you may be interested in
1. MindManager. MindManager will help you generate ideas. you can write topic, sentence, word, freely on it, and drag it from one subtopic to another one. Want to know more about it, please visit http://bbs.21manager.com/index.asp?boardid=161.
2. EyeGuard. a smart but useful one, I use it to remind me that I should have a rest after a long time work.
3. Lingoes. I know that many people use iciba（金山词霸）, try Lingoes, you will love it. smart but smart. www.lingoes.cn
4. FOX PDF editor. Can PDF be edited? yes, fox PDF editor will help you do that.
5. HyperSnap. want to catch up some pictures? try it.
6. MyMoneyMaster. you want to write down how you spend you money? it will help you.
7. igoogle. don’t forget it. I really like it. how to use it? well, that completely depends on you. Whatever, you should have a gmail account before you use igoogle.
8. google desktop search. you have too many files and sometimes be lost in files? why not use it to help you?
9. FtpList. you want to tell your friends the list of ebook you have collected? how to tell him/her? use ftplist to generate the file name list.
10. depends on you. there are so many tools you can find, in my opinion, any problem you meet, you can find some software to help you. if you don’t know how to find, why not use google?
Import your MSN contacts to new account
You don’t like the old name of your present MSN account and want to apply a new account? But, there are so many contacts, it’s hard to image how to add so many contacts to your new account again. Thus, you abandon the idea.
Well, don’t worry. In fact, you can do it in a few seconds.
Step 1: in your old MSN, select "Show Menu"
Step 2: Contacts–>Save instant messenge Contacts
Step 3: In your new MSN, Import them.
Done.
If you have lots of contacts in your hand, and you want to add them to your MSN’s friend list. Well, that’s easy.
Use excel to help you, and, take time to read the following blue codes as txt.
<?xml version="1.0" ?>
<messenger>
<service name=".NET Messenger Service">
<contactlist>
<contact>example@hotmail.com</contact>
</contactlist>
</service>
</messenger>
save above blue codes as Contact.ctt.
then,in MSN, Contacts,Import Contacts From File
Excel help: Good but not Enough
The Excel help file is good, but not enough. Many operating functions and skills need to be learnt by other tutorial.
Excelhome.net is a wonderful website. Often, I will turn it for help when I have some difficulties.
Of course, I need to learn more about Excel VBA. In order to master it, I have to take time reading tutorial books about VBA and make practice.
Recent Comments