Crontab 設定

使用 crontab -e command 編輯時需熟悉 ed 語法，但這個語法我想沒幾個人會吧，而且更換 Editor 還要改系統參數，不同版本的語法也不太一樣:

export EDITOR=vi

在網路上找到一個簡單的方法:

crontab -l > crontab.dat
vi crontab.dat
crontab crontab.dat

將 目前 crontab 的內容轉出，在修改完後在加入即可。

在巨集中呼叫外部巨集文字檔的方法

1.需將巨集安全性設定中的 [ 信任存取 Visual Basic 專案 ] 的項目打開, 如無開啟會出現 [ 執行期錯誤: 1004 ]的錯訊息。


2.建立一個巨集輸入下面代碼

'匯入 VBA 巨集的文字檔
Me.VBProject.VBComponents.Import Filename:="X:\XXXX\test.vbs"

'執行匯入巨集程式
Result = Application.Run("巨集名稱", "Arg#1","Arg#2")

'將匯入之巨集移除，不然下次執行時會出現錯誤
Me.VBProject.VBComponents.Remove Me.VBProject.VBComponents.Item(Me.VBProject.VBComponents.Count)

'顯示傳回結果
MsgBox Result

如何恢复 Linux 上删除的文件，第 1 部分

如何恢复 Linux 上删除的文件，第 1 部分

Excel VBA 在儲存前捉取別 Excel 檔 sheet 作更新動作

'存檔前執行

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Dim ofile, ff, readfile

Dim theShell As Object

'指定路徑和檔名

DataPath = "C:\XXXX\YYYYY\"

DataFile = "ZZZZZ.xls"

'確認是否有此檔案

With Application.FileSearch

.NewSearch

.LookIn = DataPath

.Filename = DataFile

If .Execute() > 0 Then ff = .FoundFiles.Count

End With

'如果有檔案則開啟此檔案，如果無則跳出 File 對話窗，選取檔案

If ff > 0 Then

' Open( 檔名 , 不做 Update link , 唯讀 )

Set ofile = Workbooks.Open( DataPath & DataFile , 0, True)

Else

'如果找不到檔案，開啟 File 對話窗選取檔案

MsgBox DataPath & DataFile & "檔案不存在，請重新選取路徑。"

Set readfile = Application.FileDialog(msoFileDialogFilePicker)

Dim v As Variant

With readfile

.Filters.Clear

.InitialFileName = DataPath

.InitialView = msoFileDialogViewDetails

.Filters.Add "All Excel Files", "*.xls"

.AllowMultiSelect = False

If .Show Then

v = .SelectedItems.Item(1)

End If

End With

'如果沒有選擇檔案直接結束。

If v Is Nothing Then

Set ofile = Workbooks.Open(v, 0, True)

Else

MsgBox "檔案不存在，請確認。"

End

End If

End If

Cells.Select

Selection.Copy

Dim ck, ckr As Boolean

ck = False

'確認本地檔案中是否有 Index sheet ，如果有需 Delete Index sheet

For Each element In Me.Worksheets

If element.Name = "Index" Then

' Disable 詢問

Application.DisplayAlerts = False

Me.Worksheets("Index").Delete

Application.DisplayAlerts = True

ck = True

Exit For

End If

Next

ck = False

'由來源檔插入 Index Fig sheet 於 Content sheet 之後，並將 Index Fig sheet 改名為 Index sheet

For Each element In ofile.Worksheets

If element.Name = "Index Fig" Then

ofile.Worksheets("Index Fig").Copy after:=Me.Worksheets("Content")

Me.Worksheets("Index Fig").Name = "Index"

ck = True

Exit For

End If

Next

'如果 ck = False 表 來源檔無 Index Fig sheet

If ck = False Then

MsgBox "ZZZZZ.xls 中的 [ Index Fig ] sheet 不存在請確認"

ofile.Close (False)

End

End If

ofile.Close (False)

End Sub

第一隻 Rebol 程式

[ Code ]

i: 0
loop 10 [ starstr: ""
for count 0 i 1 [ starstr: join starstr "*" ]
print starstr
i: i+1 ]

[ Result ]

*
**
***
****
*****
******
*******
********
*********
**********

System.getProperty 中 os.name 、os.version、and os.arch傳回值

os.name	os.version	os.arch	說明
Linux	2.0.31	x86	IBM Java 1.3
Linux	(*)	i386	Sun Java 1.3.1, 1.4 or Blackdown Java; (*) os.version depends on Linux Kernel version
Linux	(*)	x86_64	Blackdown Java; note x86_64 might change to amd64; (*) os.version depends on Linux Kernel version
Linux	(*)	sparc	Blackdown Java; (*) os.version depends on Linux Kernel version
Linux	(*)	ppc	Blackdown Java; (*) os.version depends on Linux Kernel version
Linux	(*)	armv41	Blackdown Java; (*) os.version depends on Linux Kernel version
Linux	(*)	i686	GNU Java Compiler (GCJ); (*) os.version depends on Linux Kernel version
Linux	(*)	ppc64	IBM Java 1.3; (*) os.version depends on Linux Kernel version
Mac OS	7.5.1	PowerPC
Mac OS	8.1	PowerPC
Mac OS	9.0, 9.2.2	PowerPC	MacOS 9.0: java.version=1.1.8, mrj.version=2.2.5; MacOS 9.2.2: java.version=1.1.8 mrj.version=2.2.5
Mac OS X	10.1.3	ppc
Mac OS X	10.2.6	ppc	Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_01-39) Java HotSpot(TM) Client VM (build 1.4.1_01-14, mixed mode)
Mac OS X	10.2.8	ppc	using 1.3 JVM: java.vm.version=1.3.1_03-74, mrj.version=3.3.2; using 1.4 JVM: java.vm.version=1.4.1_01-24, mrj.version=69.1
Mac OS X	10.3.1, 10.3.2, 10.3.3, 10.3.4	ppc	JDK 1.4.x
Mac OS X	10.3.8	ppc	Mac OS X 10.3.8 Server; using 1.3 JVM: java.vm.version=1.3.1_03-76, mrj.version=3.3.3; using 1.4 JVM: java.vm.version=1.4.2-38; mrj.version=141.3
Windows 95	4.0	x86
Windows 98	4.10	x86	Note, that if you run Sun JDK 1.2.1 or 1.2.2 Windows 98 identifies itself as Windows 95.
Windows Me	4.90	x86
Windows NT	4.0	x86
Windows 2000	5.0	x86
Windows XP	5.1	x86	Note, that if you run older Java runtimes Windows XP identifies itself as Windows 2000.
Windows 2003	5.2	x86	java.vm.version=1.4.2_06-b03; Note, that Windows Server 2003 identifies itself only as Windows 2003.
Windows CE	3.0 build 11171	arm	Compaq iPAQ 3950 (PocketPC 2002)
OS/2	20.40	x86
Solaris	2.x	sparc
SunOS	5.7	sparc	Sun Ultra 5 running Solaris 2.7
SunOS	5.8	sparc	Sun Ultra 2 running Solaris 8
SunOS	5.9	sparc	Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.0_01-b03) Java HotSpot(TM) Client VM (build 1.4.0_01-b03, mixed mode)
MPE/iX	C.55.00	PA-RISC
HP-UX	B.10.20	PA-RISC	JDK 1.1.x
HP-UX	B.11.00	PA-RISC	JDK 1.1.x
HP-UX	B.11.11	PA-RISC	JDK 1.1.x
HP-UX	B.11.11	PA_RISC	JDK 1.2.x/1.3.x; note Java 2 returns PA_RISC and Java 1 returns PA-RISC
HP-UX	B.11.00	PA_RISC	JDK 1.2.x/1.3.x
HP-UX	B.11.23	IA64N	JDK 1.4.x
HP-UX	B.11.11	PA_RISC2.0	JDK 1.3.x or JDK 1.4.x, when run on a PA-RISC 2.0 system
HP-UX	B.11.11	PA_RISC	JDK 1.2.x, even when run on a PA-RISC 2.0 system
HP-UX	B.11.11	PA-RISC	JDK 1.1.x, even when run on a PA-RISC 2.0 system
AIX	5.2	ppc64	sun.arch.data.model=64
AIX	4.3	Power
AIX	4.1	POWER_RS
OS/390	390	02.10.00	J2RE 1.3.1 IBM OS/390 Persistent Reusable VM
FreeBSD	2.2.2-RELEASE	x86
Irix	6.3	mips
Digital Unix	4.0	alpha
NetWare 4.11	4.11	x86
OSF1	V5.1	alpha	Java 1.3.1 on Compaq (now HP) Tru64 Unix V5.1
OpenVMS	V7.2-1	alpha	Java 1.3.1_1 on OpenVMS 7.2

System.getProperty用法

System.getProperty()参数大全

java.version Java Runtime Environment version
java.vendor Java Runtime Environment vendor
java.vendor.url Java vendor URL
java.home Java installation directory
java.vm.specification.version Java Virtual Machine specification version
java.vm.specification.vendor Java Virtual Machine specification vendor
java.vm.specification.name Java Virtual Machine specification name
java.vm.version Java Virtual Machine implementation version
java.vm.vendor Java Virtual Machine implementation vendor
java.vm.name Java Virtual Machine implementation name
java.specification.version Java Runtime Environment specification version
java.specification.vendor Java Runtime Environment specification vendor
java.specification.name Java Runtime Environment specification name
java.class.version Java class format version number
java.class.path Java class path
java.library.path List of paths to search when loading libraries
java.io.tmpdir Default temp file path
java.compiler Name of JIT compiler to use
java.ext.dirs Path of extension directory or directories
os.name Operating system name
os.arch Operating system architecture
os.version Operating system version
file.separator File separator ("/" on UNIX)
path.separator Path separator (":" on UNIX)
line.separator Line separator ("\n" on UNIX)
user.name User's account name
user.home User's home directory
user.dir User's current working directory