May 1, 2011

Error loading C:\Windows\system32\sshnas21.dll

How to remove sshnas.dll or sshnas21.dll trojan (Remove trojan FakeAlert)
sshnas.dll or sshnas21.dll is a component of trojan FakeAlert. The trojan come from malicious websites that ask users to download an Adobe Flash Player update or player needed to view a movie online. The filename of the trojan is flash-HQ-plugin. Once started, the trojan will download and install core components: c.exe, msa.exe and sshnas.dll (sshnas21.dll). When downloaded, it will be configured to start automatically when Windows starts. Trojan FakeAlert may display many popups and fake security alerts, hijack Internet Explorer, disable Windows Task Manager and Registry editor.Also it is usually installed in conjunction with a rogue antispyware programs.


renz97 at 無名小站 at 01:12 AM post | Reply(0) | Trackback(0) | prosecute
April 29, 2011

Office 2010一键激活工具Office 2010 Toolkit

说到Office 2010激活工具,大部分首先想到的肯定是miniKMS,最早出现的Office破解激活方法也就是使用miniKMS,也是目前最多人使用的方法(软矿博客在“Office 2010 RTM中文版破解激活方法”详细地介绍miniKMS的使用方法,也是目前点击率最高的一篇文章)。其次想到的应该是“神key”(即MAK密钥),“Microsoft Office Professional Plus 2010免序列号版”就是集成了有效的MAK密钥(目前该KEY激活次数已经用完)。但现在出现了更加方便的Office 2010激活工具,可以一键激活Microsoft Office Pro 2010。

为了证明Office 2010 Toolkit的有效性,我在虚拟机重新安装了Microsoft Office Professional Plus 2010免序列号版(集成的MAK密钥已经失效),未激活前Microsoft Office Professional Plus 2010的激活状态如下图示:


renz97 at 無名小站 at 09:46 PM post | Reply(0) | Trackback(0) | prosecute
September 17, 2010

Excel中鲜为人知的“照相机”功能

Excel中,有一个“照相机”的功能,但是几乎80%使用Excel的人,并不知道这个很有效的“摄影”工具,更别提使用了。我接触Excel多年,但也只是在最近由于工作需要,才刚刚接触了这个“照相机”,现在把使用方法记下来,一是怕时间一长自己忘了——好记性不如烂笔头(噢,现在该改说:好记性不如烂键盘啦!);二是可能别人需要,可以作为参考。

  在Excel中,如果需要在一个页面中同步反映另外一个页面的更改,我们一般用粘贴连接等方式来实现。但是,如果需要反映的内容比较多,特别是目标位置的格式编排也必须反映出来的时候,再使用连接数据的方式就行不通了。好在天无绝人之路,Excel早为我们准备了“照相机”,你只要把希望反映出来的那部分内容“照”下来,然后把“照片”粘贴到其他的页面即可。而且注意:插入的的确是一幅同步自动更新的图像文件,数据和格式会同步更新,同时可以使用“图片”工具栏对这个照片进行编辑。而且这个既然是图片,除了Excel,当然也可以贴在word、PPT、或者Windows附件中自带的画图工具中,当然也可以在Photoshop之类的软件中进行编辑。

  这个照相机的使用方法如下:

  1、 准备“照相机”


renz97 at 無名小站 at 12:12 PM post | Reply(0) | Trackback(0) | prosecute
August 24, 2010

not showing price when value is 0.

=IF(A7=0;"";A7*B7)

A3=IF(SUM(A1:A2)=0,"",SUM(A1:A2))


renz97 at 無名小站 at 10:51 AM post | Reply(0) | Trackback(0) | prosecute
August 22, 2010

not showing #N/A

product code key in
=IF(ISNA(OFFSET(DescriptionStart;MATCH(B23;ProdutColumn;0)-1;1;COUNTIF(ProductColumn;B23);1));"";OFFSET(DescriptionStart;MATCH(B23;ProductColumn;0)-1;1;COUNTIF(ProductColumn;B23);1))


renz97 at 無名小站 at 10:57 AM post | Reply(0) | Trackback(0) | prosecute
August 21, 2010

excel如何自动生成查询?

比方:
sheet1:
A1 B1   C1
孙 1000  @
李 2000  #
蒋 3000  $
问题:
如何在sheet2A1单元格中输入:"孙"时如何在B1和C1位置自动调用生成动在sheet1中对应的1000 @?
在sheet2B1单元格中输入:"李"时如何在B1和C1位置自动调用生成动在sheet1中对应的2000 #?
依次类推?!!


在sheet2表中:
B1输入: =IF($A$1<>"",INDEX(Sheet1!$A$1:$C$3,MATCH($A$1,Sheet1!$A$1:$A$3,0),2),"")
C1输入: =IF($A$1<>"",INDEX(Sheet1!$A$1:$C$3,MATCH($A$1,Sheet1!$A$1:$A$3,0),3),"")
如果出现错误 #N/A,则表示查无此人。 


renz97 at 無名小站 at 09:26 PM post | Reply(0) | Trackback(0) | prosecute
August 21, 2010

show information with link

Sample 1,Select the row want to be validaion.(Name is CourseColumn)
Data -> Validity -> Cell Range
key in =CourseColumn(the whole row A name)


renz97 at 無名小站 at 08:11 PM post | Reply(0) | Trackback(0) | prosecute
August 20, 2010

list box

use openoffice spreedsheet,
copy the name u wan to be list,
then go Data -> Validity -> click List and paste the name on the value and then ok.


renz97 at 無名小站 at 04:37 PM post | Reply(0) | Trackback(0) | prosecute
August 6, 2010

天空郁闷。。

今天的心情和天空一样,无法晴朗起来。
并不是因为心情不好。
而是不知道为什么开心。。


renz97 at 無名小站 at 09:46 AM post | Reply(0) | Trackback(0) | prosecute
August 6, 2010

size of desktop icons in Vista or Win7

Do you find the size of desktop icons in Vista too large?  For some strange reason, all of the icons are huge! I like things small, so I quickly found a way to make the icons much smaller.

There are actually two ways you can go about reducing the size of the desktop icons, either via the desktop or by using your mouse, if it has a scroll wheel. I found the second method to be the fastest and easiest.

change vista icon size


renz97 at 無名小站 at 09:39 AM post | Reply(0) | Trackback(0) | prosecute
July 27, 2010

检查硬盘是否有异状

打开cmd ,输入

chkdsk/f x:


renz97 at 無名小站 at 04:21 PM post | Reply(0) | Trackback(0) | prosecute
July 27, 2010

清除无法正常删除的文件

使用win7者,如遇到无法删除的文件并出现 you need permission to perform this action时,
以administrator的身份打开cmd,
输入 net user administrator \active:yes


renz97 at 無名小站 at 04:14 PM post | Reply(0) | Trackback(0) | prosecute

unlog_NVPO 0