Terima kasih atas penjelasannya. Memang beberapa hari yg lalu ada beberapa penjelasan yg Mr.Kid utarakan terjadi pada file saya.
Salam, Rasyid From: [email protected] [mailto:[email protected]] Sent: Thursday, March 12, 2015 11:25 AM To: BeExcel Subject: Re: [belajar-excel] pesan error cannot insert object Alhamdulillah Setiap kali Excel membuka sebuah workbook, maka akan dibuatkan temporary file dan beberapa file .exd yang berisi definisi control object yang digunakan (termasuk userforms nya). Excel bisa saja dibuka oleh MS Word atau aplikasi buatan user lainnya alias tidak mesti dijalankan seperti layaknya user ingin membuka Excel melalui start program. imo, Pada kondisi workbook berisi suatu controls object, ketika bekerja dengan mode compatibility atau ada lebih dari 1 versi excel dalam komputer, bisa terjadi Excel gagal memperbarui file exd dengan yang sesuai versi Excel yang digunakan. Akhirnya, definisi dalam exd yang ada tidak sesuai dengan versi Excel yang sedang aktif dan muncullah permasalahan tersebut. terkadang, script yang tidak melakukan unload userform (alias hanya menggunakan methods hide saja) sering membuat file .exd juga tidak dapat diperbarui. Akhirnya, file excel yang lain menggunakan definisi yang tidak sesuai. lebih sering terjadi, ketika sebuah workbook memicu Excel crash juga bisa menyebabkan kegagakan pembaruan files exd tersebut. Akhirnya, workbook lain yang dibuka kemudian bisa dalam kondisi tidak cocok definisi object nya. tapi saya pikir, perlu dilihat lebih jauh tentang potensi kegagalan pembaruan exd files tersebut akibat penggunaan workbook yang dibuat dengan office yang berbeda bit-nya. Wassalam, Kid. On Thu, Mar 12, 2015 at 2:23 PM, 'Contract Mining Assistant, Asam-Asam' [email protected]<mailto:[email protected]> [belajar-excel] <[email protected]<mailto:[email protected]>> wrote: Alhamdulillah, Terima kasih atas solusinya, running well. Solusi yang saya terapkan langsung ke no 3. Mau nanya, kenapa hal tsb bisa terjadi. Padahal aktivitas sehari-hari saya hanya sekedar input data,formula dan create/edit vba. Terima kasih sebelumnya. Salam, Rasyid From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] Sent: Thursday, March 12, 2015 9:55 AM To: BeExcel Subject: Re: [belajar-excel] pesan error cannot insert object Hai Rasyid, Yang dilakukan berurutan adalah hal-hal berikut : (berhenti jika sudah bisa atau sudah semuanya dicoba dan tetap tidak bisa) 1. cari tahu nama library (dll) si control yang akan di-insert dan cek di drive system melalui windows explorer (search file itu) 2. cek apakah file nomor 1 itu telah di-register ke OS setempat [nomor 1 dan 2 diutamakan untuk activex control yang bukan bawaan saat install MS Office, karena kadang kala ada activex control yang tidak bisa digunakan dalam worksheet] 3. tutup semua Excel, cari (search file di windows explorer) file dengan ekstensi .exd, jika menemukannya, hapus saja file itu dan coba insert lagi 4. cari file fm20.dll, dan cek apakah sudah teregister dengan baik dalam OS. 5. install ulang ms office dan pastikan item VBA dalam ms shered feature atau semacamnya sudah dicentang Wassalam, Kid On Thu, Mar 12, 2015 at 10:54 AM, 'Contract Mining Assistant, Asam-Asam' [email protected]<mailto:[email protected]> [belajar-excel] <[email protected]<mailto:[email protected]>> wrote: Dear all Member, Mohon untuk solusinya. Kenapa setiap kali ingin insert control / modifikasi VBA selalu tampil message box terlampir. Terima kasih sebelumnya Salam, Rasyid Disclaimer - This message including any attachments and information contained herein ("Message" ) may contain privileged information or otherwise is protected from disclosure. Any unauthorized use of this Message by any person may lead to legal consequences. If you receive this Message in error, or if the recipient of this Message is not the intended recipient or the employee or agent authorized for delivering this Message to the intended recipient you are hereby notified that any disclosure, dissemination, distribution or copying of this Message or let or cause this Message to be disclosed,disseminated, distributed, or copied is strictly prohibited, and please notify the sender by return message and immediately delete this Message from your system. Incoming and outgoing communications using this electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable law and regulations. Unless it is made by the authorized person,any views expressed in this Message are those of the individual sender and may not necessarily reflect the views of PT Arutmin Indonesia. You should check attachments for viruses and defects before opening or using them. We are not liable to recover any injuries caused by virused or defected attachments. Disclaimer - This message including any attachments and information contained herein ("Message" ) may contain privileged information or otherwise is protected from disclosure. Any unauthorized use of this Message by any person may lead to legal consequences. If you receive this Message in error, or if the recipient of this Message is not the intended recipient or the employee or agent authorized for delivering this Message to the intended recipient you are hereby notified that any disclosure, dissemination, distribution or copying of this Message or let or cause this Message to be disclosed,disseminated, distributed, or copied is strictly prohibited, and please notify the sender by return message and immediately delete this Message from your system. Incoming and outgoing communications using this electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable law and regulations. Unless it is made by the authorized person,any views expressed in this Message are those of the individual sender and may not necessarily reflect the views of PT Arutmin Indonesia. You should check attachments for viruses and defects before opening or using them. We are not liable to recover any injuries caused by virused or defected attachments. Disclaimer - This message including any attachments and information contained herein ("Message" ) may contain privileged information or otherwise is protected from disclosure. Any unauthorized use of this Message by any person may lead to legal consequences. If you receive this Message in error, or if the recipient of this Message is not the intended recipient or the employee or agent authorized for delivering this Message to the intended recipient you are hereby notified that any disclosure, dissemination, distribution or copying of this Message or let or cause this Message to be disclosed,disseminated, distributed, or copied is strictly prohibited, and please notify the sender by return message and immediately delete this Message from your system. Incoming and outgoing communications using this electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable law and regulations. Unless it is made by the authorized person,any views expressed in this Message are those of the individual sender and may not necessarily reflect the views of PT Arutmin Indonesia. You should check attachments for viruses and defects before opening or using them. We are not liable to recover any injuries caused by virused or defected attachments.
