(时间太久无法回复)
執行階段錯誤 '9' : 陣列索引超出範圍
貓咪~
2005-09-21 07:29:01 UTC
有一個從excel中的vb寫出來的程式
本來執行都正常可點按鈕跳頁~
但後來使用一段時間後
點選按鈕要跳頁都會出現
"執行階段錯誤 '9' : 陣列索引超出範圍"
但將程式改別用台電腦執行~
都很正常~想請問我這台電腦出了那些問題??
璉璉
2005-09-21 14:13:22 UTC
RXhjZWwgVkJBIOeZvOeUn+mMr+iqpOW+jO+8jOacg+WBnOeVmeWcqOmMr+iqpOihjO+8jOW7uuit
sOS9oOaKiumMr+iqpOihjCAo6buD6ImyKSDpgqPooYzosrzlh7rkvoYNCuatpOWklu+8jOS9oOWP
r+S7peWcqOmZo+WIl+e0ouW8leWAvOS4iua7kem8oOWBnOWFqeenku+8jOacg+S7pSBUb29sdGlw
cyDmlrnlvI/ot7Plh7rlgLzvvIzmiJbmiorpmaPliJfntKLlvJXlgLzlj43nmb3lvozmjInkuIsg
U2hpZnQrRjkg77yM5pyD5Lul5bCN6Kmx55uS5pa55byP6Lez5Ye65YC877yM6KuL5qqi5p+l5q2k
5YC844CCDQoNCiLospPlkqp+IiA8Pz9+QGRpc2N1c3Npb25zLm1pY3Jvc29mdC5jb20+IOaSsOWv
q+aWvOmDteS7tuaWsOiBnjo0QUQxNEVGMS02NUQ1LTQ4QTMtQkUyQS1EMkVFRkQzRDFEODBAbWlj
cm9zb2Z0LmNvbS4uLg0KPiDmnInkuIDlgIvlvp5leGNlbOS4reeahHZi5a+r5Ye65L6G55qE56iL
5byPDQo+IOacrOS+huWft+ihjOmDveato+W4uOWPr+m7nuaMiemIlei3s+mggX4NCj4g5L2G5b6M
5L6G5L2/55So5LiA5q615pmC6ZaT5b6MDQo+IOm7numBuOaMiemIleimgei3s+mggemDveacg+WH
uuePvg0KPiAi5Z+36KGM6ZqO5q616Yyv6KqkICc5JyA6IOmZo+WIl+e0ouW8lei2heWHuuevhOWc
jSINCj4g5L2G5bCH56iL5byP5pS55Yil55So5Y+w6Zu76IWm5Z+36KGMfg0KPiDpg73lvojmraPl
uLh+5oOz6KuL5ZWP5oiR6YCZ5Y+w6Zu76IWm5Ye65LqG6YKj5Lqb5ZWP6aGMPz8=
"貓咪~" <@discussions.microsoft.com>
2005-09-22 02:03:01 UTC
這是錯誤的那一行:
Workbooks("公文管理").Worksheets("開始畫面").Select

Watch : : Workbooks("公文管理").Worksheets("開始畫面").Select : <陣列索引超出範圍> :
Variant/Integer : Sheet1.主畫面回開始畫面_Click

不過這個程式整個移動到另一台電腦
就可以順利執行~
沒有顯示任何錯誤~
只在目前使用這一台有發生錯誤~好奇怪呀~"~
璉璉
2005-09-22 13:28:53 UTC
5qqi5p+l5LiA5LiL77yaDQrpgJrluLggV29ya2Jvb2tzIOeahOe0ouW8leWAvOaHieipsuaYryA/
Pz8ueGxzDQrmiYDku6Xmh4noqbLmmK8NCldvcmtib29rcygi5YWs5paH566h55CGLnhscyIpDQrm
iYDku6XkvaDmuKzoqabmmYLvvIzmiorvvJoNCldvcmtib29rcygi5YWs5paH566h55CGIikgDQrl
j43nmb3vvIzmjInkuIsgU2hpZnQgKyBGOQ0KDQoi6LKT5ZKqfiIgPEBkaXNjdXNzaW9ucy5taWNy
b3NvZnQuY29tPiDmkrDlr6vmlrzpg7Xku7bmlrDogZ46QjA5NTNCOEYtRTM2MC00NkIwLTlEM0Et
NzBFQzkzNzdBQ0FDQG1pY3Jvc29mdC5jb20uLi4NCj4g6YCZ5piv6Yyv6Kqk55qE6YKj5LiA6KGM
77yaDQo+IFdvcmtib29rcygi5YWs5paH566h55CGIikuV29ya3NoZWV0cygi6ZaL5aeL55Wr6Z2i
IikuU2VsZWN0DQo+IA0KPiBXYXRjaCA6ICAgOiBXb3JrYm9va3MoIuWFrOaWh+euoeeQhiIpLldv
cmtzaGVldHMoIumWi+Wni+eVq+mdoiIpLlNlbGVjdCA6IDzpmaPliJfntKLlvJXotoXlh7rnr4Tl
nI0+IDogDQo+IFZhcmlhbnQvSW50ZWdlciA6IFNoZWV0MS7kuLvnlavpnaLlm57plovlp4vnlavp
naJfQ2xpY2sNCj4gDQo+IOS4jemBjumAmeWAi+eoi+W8j+aVtOWAi+enu+WLleWIsOWPpuS4gOWP
sOmbu+iFpg0KPiDlsLHlj6/ku6XpoIbliKnln7fooYx+DQo+IOaykuaciemhr+ekuuS7u+S9lemM
r+iqpH4NCj4g5Y+q5Zyo55uu5YmN5L2/55So6YCZ5LiA5Y+w5pyJ55m855Sf6Yyv6KqkfuWlveWl
h+aAquWRgH4ifg==
"貓咪~" <@discussions.microsoft.com>
2005-09-23 01:05:01 UTC
加入".xls"就可以順利執行了~
真的是非常的感謝您~~~~~>"<