计算机相关

vba 2007 ActiveWorkbook.SaveAs problem

vba 2007 ActiveWorkbook.SaveAs problem

在使用vba保存生成的excel文件后，然后在打开总是提示格式不对，不管提示，进入后格式时对的，数据也可以显示。

最后google之，原来在2003之后使用ActiveWorkbook.SaveAs时必须指定文件类型。

51 = xlOpenXMLWorkbook (without macro’s in 2007, .xlsx)
52 = xlOpenXMLWorkbookMacroEnabled (with or without macro’s in 2007,
.xlsm)
50 = xlExcel12 (Excel Binary Workbook in 2007 with or without macro’s,
.xlsb)
56 = xlExcel8 (97-2003 format in Excel 2007, .xls)

http://blogs.office.com/b/microsoft-excel/archive/2009/07/07/use-the-vba-
saveas-method-in-excel-2007.aspx

计算机相关

how to using jira in eclipse

1. enable rpc plugin in server
https://developer.atlassian.com/display/JIRADEV/Enabling+the+RPC+plugin

https://confluence.atlassian.com/display/IDEPLUGIN/Installing+the+Eclipse+Connector

2. install Atlassian Connector for Eclipse from update site:

http://update.atlassian.com/atlassian-eclipse-plugin/rest/e3.7

3. add jira repo with mylyn to “Task Repositories” view.

https://example.com/jira

4. add your query and filter to you Task List view.

enjoy it.

JS

在firefox的extension(chrome)中获取当前页面的属性或方法 

window.content.document.defaultView.wrappedJSObject.yourProperty

window.content.document.defaultView.wrappedJSObject.yourFunction

但是这样有安全性的问题，如果只是read access的话，没有问题。

http://stackoverflow.com/questions/151555/how-do-i-execute-a-page-defined-
javascript-function-from-a-firefox-extension/2525816#2525816
https://developer.mozilla.org/en-
US/docs/Safely_accessing_content_DOM_from_chrome

Android

Android系统的改进（三） -- 只从一些特定的目录来搜索本地歌曲

每次把手机插到电脑上，传一些歌曲，然后拔下来，

这是打开歌曲播放器，里面什么都没有，必须重新扫描，而且每次扫描都很慢。

为什么不是只扫描一个特定的目录，比方说\storage\SDcard{X}\music，这样的话可以很快完成搜索。

如果用户将歌曲放到了别的目录，只要在播放器中添加一个添加目录的功能就可以了。

计算机相关

Emacs在RHEL 5上的安装和使用

1. install latest emacs
xz -d emacs-24.3.tar.xz
tar xvf emacs-24.3.tar
./configure
make
make install #need root
2. install Steve Purcell’s emacs config
git clone https://github.com/purcell/emacs.d.git
rm -rf .emacs.d/ emacs
mv emacs.d/ .emacs.d/
emacs # first time will download related module
3. increase/decrease font size
C-x C–
C-x C-+

4. hotkey

C-v Move forward one screenful
M-v Move backward one screenful
C-l Clear screen and redisplay all the text,
moving the text around the cursor
to the center of the screen.
C-f Move forward a character
C-b Move backward a character

M-f Move forward a word
M-b Move backward a word

C-n Move to next line
C-p Move to previous line

C-a Move to beginning of line
C-e Move to end of line

M-a Move back to beginning of sentence
M-e Move forward to end of sentence

C-x C-b List buffers
C-x b TUTORIAL Swith buffer
M-x kill-some-buffers
C-x Character eXtend. Followed by one character.
M-x Named command eXtend. Followed by a long name.

C-x C-f Find file
C-x C-s Save file
C-x s Save some buffers
C-x C-b List buffers
C-x b Switch buffer
C-x C-c Quit Emacs
C-x 1 Delete all but one window
C-x u Undo

http://blog.csdn.net/redguardtoo/article/details/7222501

Android

Android系统的改进（一）-- Lock屏幕功能

如下图，屏幕上的图标被不小心弄的很乱，其实大多数的时候，当我们办图标的位置调整好后，

就不需要再动了，所以可以提供一个Lock功能，在调整完成后将其Lock住，避免误操作，小孩乱动或者

没有锁屏，放到裤兜里将图标弄乱。

Lock屏幕功能。