Assalamu'alaikum,
Rasyid, Kalau begitu coba kembangkan alternatif program excel tanpa makro. Wassalamu'alaikum Wid Sent from my iPhone > On Feb 4, 2016, at 14:15, "'Contract Mining Assistant, Asam-Asam' > [email protected] [belajar-excel]" <[email protected]> > wrote: > > Dear Mr Kid & all member, > > Sudah saya coba, akan tetapi hasilnya masih nihil, bahkan saya sudah > uninstall tetapi hasilnya masih sama. > > Ternyata file apapun yang menggunakan VBA yang di buat di PC Server > (file_A.xlsb) walaupun hanya sekedar menampilkan MessageBox, begitu file > (file_A.xlsb) di Copas > > di PC Client macronya tidak jalan. Setting security sudah betul saja. Begitu > saya alihkan ke mode design untuk membuka jendela VBA, begitu saya run > codingnya melalui VBA akan tampil message error yg berbunyi > > “compile error: Object library invalid or contains references to object > definitions that Could not be found”. > > > > Add note: > > - setiap kali saya bikin command button baru di PC server selalu > defaulnya dari commandbutton21 > > - saat file (file_A.xlsb) yg ada di PC client dibuka dan macronya > tidak bisa running, akan tetapi begitu saya menambahkan command button di > sheet yg baru tetapi masih di PC client macro berjalan normal, biru saya > pindah ke sheet sebelumnya macro tetap tidak bisa jalan. > > > > Mohon kiranya bantuan, kalau saja dari mr Kid dan semua member pernah > mengalami case seperti ini. > > > > Terima kasih sebelumnya. > > > > Salam Hormat, > > Rasyid > > > > > > From: [email protected] [mailto:[email protected]] > Sent: Wednesday, January 20, 2016 6:01 PM > To: BeExcel > Subject: Re: [belajar-excel] membuka file bermakro di PC lain tidak bisa. > > > > > > Hai Rasyid, > > Coba tutup semua Excel, lalu unduh yang ada disini : (fix dari MS -- lihat > agak ke bawah, ada tombol download --) > https://support.microsoft.com/en-us/kb/3025036 > > Unduh yang sesuai (khusus untuk user yang sedang login atau punya akses > sebagai admin agar bisa untuk seluruh user) dan jalankan > > > > Wassalam, > > Kid > > > > > > On Wed, Jan 20, 2016 at 1:45 PM, 'Contract Mining Assistant, Asam-Asam' > [email protected] [belajar-excel] <[email protected]> wrote: > > > > Dear Toby Kenzo and all members, > > Jawaban: > > 1- Ya masih dengan extention xlsm > > 2- Ya dengan nama file yg sama > > 3- Ya menjadi commandbutton21 dll. > > > > Salam, Rasyid > > > > From: [email protected] [mailto:[email protected]] > Sent: Wednesday, January 20, 2016 2:22 PM > To: [email protected] > Subject: Bls: [belajar-excel] membuka file bermakro di PC lain tidak bisa. > > > > > > Dear Rasyid, > > Ada beberapa pertanyaan dari saya tentang masalah yg anda alami saat ini. > > 1. Apakah pada saat copy Paste ke client filenya tetap berextentiom XLSM..? > 2. Apakah pada saat copy Paste ke client dengan nama file yang sama atau > tidak..? > 3. Apakah perubahan name dari commondbutton berubah menjadi commondbutton21 > atau yg lain..? > > TerimaKasih. > > -------------------------------------------- > Pada Rab, 20/1/16, 'Contract Mining Assistant, Asam-Asam' > [email protected] [belajar-excel] <[email protected]> > menulis: > > Judul: [belajar-excel] membuka file bermakro di PC lain tidak bisa. > Kepada: [email protected] > Tanggal: Rabu, 20 Januari, 2016, 10:27 AM > > > > > > > > > > > > > > > > > Dear Milis Belajar > Excel. > Mohon bantuannya. > Ilustrasi kasus: > Saya mempunya 2 buah > file excel, > 1.file_server.xlsb > 2.file_client.xlsm. > > Rencana nya > file_client.xlsm akan di running di tiap2 PC client, yang > mana isi dari file tsb ada makro, formula dan ada bahasa > basic nya. > Akan tetapi ketika di > paste di PC client dan dijalankan, ketika kita mengklik > salah satu button yang disisipkan bahasa basic, sama sekali > tidak merespon, setelah saya masuk ke jendela VBA ternya > name dari button tsb telah berubah > Dan tidak ada listing > programnya, setelah saya manual bikinkan listing programnya, > tetap tombol tsb tidak bereaksi. dan tampil kotak pesan “ > compile error: Object library invalid or contains references > to object definitions that Could not > be found”. > Saya sudah mencoba dengan > merubah setting di Trush Center dengan mengubah ActiveX > Setting dan Macro Setting ke option Enable. Akan tetapi > masih error. > > Mohon bantunnya dan terima > kasih sebelumnya. > > > Note: saya pakai > Excel 2010. > > 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. > > > > > > > > > > > > > > > > #yiv1861964602 #yiv1861964602 -- > #yiv1861964602ygrp-mkp { > border:1px solid #d8d8d8;font-family:Arial;margin:10px > 0;padding:0 10px;} > > #yiv1861964602 #yiv1861964602ygrp-mkp hr { > border:1px solid #d8d8d8;} > > #yiv1861964602 #yiv1861964602ygrp-mkp #yiv1861964602hd { > color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px > 0;} > > #yiv1861964602 #yiv1861964602ygrp-mkp #yiv1861964602ads { > margin-bottom:10px;} > > #yiv1861964602 #yiv1861964602ygrp-mkp .yiv1861964602ad { > padding:0 0;} > > #yiv1861964602 #yiv1861964602ygrp-mkp .yiv1861964602ad p { > margin:0;} > > #yiv1861964602 #yiv1861964602ygrp-mkp .yiv1861964602ad a { > color:#0000ff;text-decoration:none;} > #yiv1861964602 #yiv1861964602ygrp-sponsor > #yiv1861964602ygrp-lc { > font-family:Arial;} > > #yiv1861964602 #yiv1861964602ygrp-sponsor > #yiv1861964602ygrp-lc #yiv1861964602hd { > margin:10px > 0px;font-weight:700;font-size:78%;line-height:122%;} > > #yiv1861964602 #yiv1861964602ygrp-sponsor > #yiv1861964602ygrp-lc .yiv1861964602ad { > margin-bottom:10px;padding:0 0;} > > #yiv1861964602 #yiv1861964602actions { > font-family:Verdana;font-size:11px;padding:10px 0;} > > #yiv1861964602 #yiv1861964602activity { > background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} > > #yiv1861964602 #yiv1861964602activity span { > font-weight:700;} > > #yiv1861964602 #yiv1861964602activity span:first-child { > text-transform:uppercase;} > > #yiv1861964602 #yiv1861964602activity span a { > color:#5085b6;text-decoration:none;} > > #yiv1861964602 #yiv1861964602activity span span { > color:#ff7900;} > > #yiv1861964602 #yiv1861964602activity span > .yiv1861964602underline { > text-decoration:underline;} > > #yiv1861964602 .yiv1861964602attach { > clear:both;display:table;font-family:Arial;font-size:12px;padding:10px > 0;width:400px;} > > #yiv1861964602 .yiv1861964602attach div a { > text-decoration:none;} > > #yiv1861964602 .yiv1861964602attach img { > border:none;padding-right:5px;} > > #yiv1861964602 .yiv1861964602attach label { > display:block;margin-bottom:5px;} > > #yiv1861964602 .yiv1861964602attach label a { > text-decoration:none;} > > #yiv1861964602 blockquote { > margin:0 0 0 4px;} > > #yiv1861964602 .yiv1861964602bold { > font-family:Arial;font-size:13px;font-weight:700;} > > #yiv1861964602 .yiv1861964602bold a { > text-decoration:none;} > > #yiv1861964602 dd.yiv1861964602last p a { > font-family:Verdana;font-weight:700;} > > #yiv1861964602 dd.yiv1861964602last p span { > margin-right:10px;font-family:Verdana;font-weight:700;} > > #yiv1861964602 dd.yiv1861964602last p > span.yiv1861964602yshortcuts { > margin-right:0;} > > #yiv1861964602 div.yiv1861964602attach-table div div a { > text-decoration:none;} > > #yiv1861964602 div.yiv1861964602attach-table { > width:400px;} > > #yiv1861964602 div.yiv1861964602file-title a, #yiv1861964602 > div.yiv1861964602file-title a:active, #yiv1861964602 > div.yiv1861964602file-title a:hover, #yiv1861964602 > div.yiv1861964602file-title a:visited { > text-decoration:none;} > > #yiv1861964602 div.yiv1861964602photo-title a, > #yiv1861964602 div.yiv1861964602photo-title a:active, > #yiv1861964602 div.yiv1861964602photo-title a:hover, > #yiv1861964602 div.yiv1861964602photo-title a:visited { > text-decoration:none;} > > #yiv1861964602 div#yiv1861964602ygrp-mlmsg > #yiv1861964602ygrp-msg p a span.yiv1861964602yshortcuts { > font-family:Verdana;font-size:10px;font-weight:normal;} > > #yiv1861964602 .yiv1861964602green { > color:#628c2a;} > > #yiv1861964602 .yiv1861964602MsoNormal { > margin:0 0 0 0;} > > #yiv1861964602 o { > font-size:0;} > > #yiv1861964602 #yiv1861964602photos div { > float:left;width:72px;} > > #yiv1861964602 #yiv1861964602photos div div { > border:1px solid > #666666;height:62px;overflow:hidden;width:62px;} > > #yiv1861964602 #yiv1861964602photos div label { > color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} > > #yiv1861964602 #yiv1861964602reco-category { > font-size:77%;} > > #yiv1861964602 #yiv1861964602reco-desc { > font-size:77%;} > > #yiv1861964602 .yiv1861964602replbq { > margin:4px;} > > #yiv1861964602 #yiv1861964602ygrp-actbar div a:first-child { > margin-right:2px;padding-right:5px;} > > #yiv1861964602 #yiv1861964602ygrp-mlmsg { > font-size:13px;font-family:Arial, helvetica, clean, > sans-serif;} > > #yiv1861964602 #yiv1861964602ygrp-mlmsg table { > font-size:inherit;font:100%;} > > #yiv1861964602 #yiv1861964602ygrp-mlmsg select, > #yiv1861964602 input, #yiv1861964602 textarea { > font:99% Arial, Helvetica, clean, sans-serif;} > > #yiv1861964602 #yiv1861964602ygrp-mlmsg pre, #yiv1861964602 > code { > font:115% monospace;} > > #yiv1861964602 #yiv1861964602ygrp-mlmsg * { > line-height:1.22em;} > > #yiv1861964602 #yiv1861964602ygrp-mlmsg #yiv1861964602logo { > padding-bottom:10px;} > > > #yiv1861964602 #yiv1861964602ygrp-msg p a { > font-family:Verdana;} > > #yiv1861964602 #yiv1861964602ygrp-msg > p#yiv1861964602attach-count span { > color:#1E66AE;font-weight:700;} > > #yiv1861964602 #yiv1861964602ygrp-reco > #yiv1861964602reco-head { > color:#ff7900;font-weight:700;} > > #yiv1861964602 #yiv1861964602ygrp-reco { > margin-bottom:20px;padding:0px;} > > #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ov > li a { > font-size:130%;text-decoration:none;} > > #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ov > li { > font-size:77%;list-style-type:square;padding:6px 0;} > > #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ov > ul { > margin:0;padding:0 0 0 8px;} > > #yiv1861964602 #yiv1861964602ygrp-text { > font-family:Georgia;} > > #yiv1861964602 #yiv1861964602ygrp-text p { > margin:0 0 1em 0;} > > #yiv1861964602 #yiv1861964602ygrp-text tt { > font-size:120%;} > > #yiv1861964602 #yiv1861964602ygrp-vital ul li:last-child { > border-right:none !important; > } > #yiv1861964602 > > 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. > >
