1 Message

Digest #3602

Re: Macro simpan/copy otomatis [1 Attachment] by "hendrik karnadi" hendrikkarnadi

Message

1a

Re: Macro simpan/copy otomatis [1 Attachment]

Fri Oct 16, 2015 2:45 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Modby.M,
Untuk pertanyaan pertama saya lampirkan File berisi macro karya mbak Siti sebagai rujukan.
File berisi Macro agar Compatible dengan MS Office 2007 ke bawah harus disave dengan extension .xls (Excel 97-2003 workbook).
Sedangkan jika anda menggunakan Excel 2007 ke atas maka file berisi Macro bisa disimpan dengan,extension .xls (Excel 97-2003 Workbook)extension . xlsb (Excel Binary Workbook)extension . xlsm (Excel Macro-Enabled Workbook).

Salam,HK

From: "Modby Matsnawabi modbym@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel <belajar-excel@yahoogroups.com>
Sent: Friday, 16 October 2015, 16:04
Subject: [belajar-excel] Macro simpan/copy otomatis [1 Attachment]

Dear rekan-rekan bexcel,,
mohon bantuan yang sudah pernah buat macro untuk simpan data otomatis/copy data ke sheet lain. tolong di share macro nya yah..saya punya case terlampir..
tanya juga untuk excel dengan macro harus disave dengan file XLSM? apa nanti akan compatible dengan ms office 2007 ke bawah..
terima kasih
Modby.M #yiv1976862942 -- #yiv1976862942ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1976862942 #yiv1976862942ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1976862942 #yiv1976862942ygrp-mkp #yiv1976862942hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1976862942 #yiv1976862942ygrp-mkp #yiv1976862942ads {margin-bottom:10px;}#yiv1976862942 #yiv1976862942ygrp-mkp .yiv1976862942ad {padding:0 0;}#yiv1976862942 #yiv1976862942ygrp-mkp .yiv1976862942ad p {margin:0;}#yiv1976862942 #yiv1976862942ygrp-mkp .yiv1976862942ad a {color:#0000ff;text-decoration:none;}#yiv1976862942 #yiv1976862942ygrp-sponsor #yiv1976862942ygrp-lc {font-family:Arial;}#yiv1976862942 #yiv1976862942ygrp-sponsor #yiv1976862942ygrp-lc #yiv1976862942hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1976862942 #yiv1976862942ygrp-sponsor #yiv1976862942ygrp-lc .yiv1976862942ad {margin-bottom:10px;padding:0 0;}#yiv1976862942 #yiv1976862942actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1976862942 #yiv1976862942activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1976862942 #yiv1976862942activity span {font-weight:700;}#yiv1976862942 #yiv1976862942activity span:first-child {text-transform:uppercase;}#yiv1976862942 #yiv1976862942activity span a {color:#5085b6;text-decoration:none;}#yiv1976862942 #yiv1976862942activity span span {color:#ff7900;}#yiv1976862942 #yiv1976862942activity span .yiv1976862942underline {text-decoration:underline;}#yiv1976862942 .yiv1976862942attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1976862942 .yiv1976862942attach div a {text-decoration:none;}#yiv1976862942 .yiv1976862942attach img {border:none;padding-right:5px;}#yiv1976862942 .yiv1976862942attach label {display:block;margin-bottom:5px;}#yiv1976862942 .yiv1976862942attach label a {text-decoration:none;}#yiv1976862942 blockquote {margin:0 0 0 4px;}#yiv1976862942 .yiv1976862942bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1976862942 .yiv1976862942bold a {text-decoration:none;}#yiv1976862942 dd.yiv1976862942last p a {font-family:Verdana;font-weight:700;}#yiv1976862942 dd.yiv1976862942last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1976862942 dd.yiv1976862942last p span.yiv1976862942yshortcuts {margin-right:0;}#yiv1976862942 div.yiv1976862942attach-table div div a {text-decoration:none;}#yiv1976862942 div.yiv1976862942attach-table {width:400px;}#yiv1976862942 div.yiv1976862942file-title a, #yiv1976862942 div.yiv1976862942file-title a:active, #yiv1976862942 div.yiv1976862942file-title a:hover, #yiv1976862942 div.yiv1976862942file-title a:visited {text-decoration:none;}#yiv1976862942 div.yiv1976862942photo-title a, #yiv1976862942 div.yiv1976862942photo-title a:active, #yiv1976862942 div.yiv1976862942photo-title a:hover, #yiv1976862942 div.yiv1976862942photo-title a:visited {text-decoration:none;}#yiv1976862942 div#yiv1976862942ygrp-mlmsg #yiv1976862942ygrp-msg p a span.yiv1976862942yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1976862942 .yiv1976862942green {color:#628c2a;}#yiv1976862942 .yiv1976862942MsoNormal {margin:0 0 0 0;}#yiv1976862942 o {font-size:0;}#yiv1976862942 #yiv1976862942photos div {float:left;width:72px;}#yiv1976862942 #yiv1976862942photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1976862942 #yiv1976862942photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1976862942 #yiv1976862942reco-category {font-size:77%;}#yiv1976862942 #yiv1976862942reco-desc {font-size:77%;}#yiv1976862942 .yiv1976862942replbq {margin:4px;}#yiv1976862942 #yiv1976862942ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1976862942 #yiv1976862942ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1976862942 #yiv1976862942ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1976862942 #yiv1976862942ygrp-mlmsg select, #yiv1976862942 input, #yiv1976862942 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1976862942 #yiv1976862942ygrp-mlmsg pre, #yiv1976862942 code {font:115% monospace;}#yiv1976862942 #yiv1976862942ygrp-mlmsg * {line-height:1.22em;}#yiv1976862942 #yiv1976862942ygrp-mlmsg #yiv1976862942logo {padding-bottom:10px;}#yiv1976862942 #yiv1976862942ygrp-msg p a {font-family:Verdana;}#yiv1976862942 #yiv1976862942ygrp-msg p#yiv1976862942attach-count span {color:#1E66AE;font-weight:700;}#yiv1976862942 #yiv1976862942ygrp-reco #yiv1976862942reco-head {color:#ff7900;font-weight:700;}#yiv1976862942 #yiv1976862942ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1976862942 #yiv1976862942ygrp-sponsor #yiv1976862942ov li a {font-size:130%;text-decoration:none;}#yiv1976862942 #yiv1976862942ygrp-sponsor #yiv1976862942ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1976862942 #yiv1976862942ygrp-sponsor #yiv1976862942ov ul {margin:0;padding:0 0 0 8px;}#yiv1976862942 #yiv1976862942ygrp-text {font-family:Georgia;}#yiv1976862942 #yiv1976862942ygrp-text p {margin:0 0 1em 0;}#yiv1976862942 #yiv1976862942ygrp-text tt {font-size:120%;}#yiv1976862942 #yiv1976862942ygrp-vital ul li:last-child {border-right:none !important;}#yiv1976862942

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group