- 帖子
- 560
- 主題
- 159
- 精華
- 0
- 積分
- 723
- 點名
- 0
- 作業系統
- WINDOWS
- 軟體版本
- xp
- 閱讀權限
- 50
- 性別
- 男
- 來自
- 桃園
- 註冊時間
- 2014-9-10
- 最後登錄
- 2023-10-31
  
|
DEAR SIR
執行如下 出現 "堆疊空間不足" ???
煩不吝賜教 THANKS ROBERT 05/05
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
檔案名稱
AA
End Sub
Sub AA()
X = Sheet51.Range("AA1")
Y = Sheet51.Range("AA2")
If X <> Y Then
Application.CutCopyMode = False
ChDir "C:\"
ActiveWorkbook.SaveAs Filename:= _
"C:\ " & Sheet51.Range("AA1") & ".xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
End If
End Sub
Sub 檔案名稱()
Dim myWB As Workbook
Dim I As Long
Dim MYBASENAME As String
Set myWB = Workbooks(1)
MYBASENAME = myWB.Name
I = InStrRev(MYBASENAME, ".")
If I > 0 Then MYBASENAME = Left(MYBASENAME, I - 1)
M = MYBASENAME
Sheet51.Range("AA2") = M
Set myWB = Nothing
End Sub |
|
發表於 2015-5-5 16:04
| 
