Hai Farud,Disimpan sbg file baru kan ?Mis kita mau simpan dengan nama fileku.xlsb di Dir D:\....maka macronya (mis nama macronya Simpan) adalah sbb:Sub Simpan() ActiveWorkbook.SaveAs "D:\fileku.xlsb"End Sub Salam,HK
Sent from Yahoo Mail on Android On Tue, May 9, 2017 at 22:55, farud oke [email protected] [belajar-excel]<[email protected]> wrote: Assalamualaikum.. Sekali lagi saya bertanya lagi dalam forum ini,maklum pengetahuan ttg Excel masih dangkal dan kpd para master2 mohon jgn bosan ngejawabnya.adakah kode VBA yg bisa mengubah file yg semula Xlsm menjadi Xlsb atau binary dan disimpan di folder D.klo mmg bisa bagaimana kodenya Atas bantuan para master sekalian saya sampaikan terimakasih #yiv7589797499 #yiv7589797499 -- #yiv7589797499ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7589797499 #yiv7589797499ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7589797499 #yiv7589797499ygrp-mkp #yiv7589797499hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7589797499 #yiv7589797499ygrp-mkp #yiv7589797499ads {margin-bottom:10px;}#yiv7589797499 #yiv7589797499ygrp-mkp .yiv7589797499ad {padding:0 0;}#yiv7589797499 #yiv7589797499ygrp-mkp .yiv7589797499ad p {margin:0;}#yiv7589797499 #yiv7589797499ygrp-mkp .yiv7589797499ad a {color:#0000ff;text-decoration:none;}#yiv7589797499 #yiv7589797499ygrp-sponsor #yiv7589797499ygrp-lc {font-family:Arial;}#yiv7589797499 #yiv7589797499ygrp-sponsor #yiv7589797499ygrp-lc #yiv7589797499hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7589797499 #yiv7589797499ygrp-sponsor #yiv7589797499ygrp-lc .yiv7589797499ad {margin-bottom:10px;padding:0 0;}#yiv7589797499 #yiv7589797499actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7589797499 #yiv7589797499activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7589797499 #yiv7589797499activity span {font-weight:700;}#yiv7589797499 #yiv7589797499activity span:first-child {text-transform:uppercase;}#yiv7589797499 #yiv7589797499activity span a {color:#5085b6;text-decoration:none;}#yiv7589797499 #yiv7589797499activity span span {color:#ff7900;}#yiv7589797499 #yiv7589797499activity span .yiv7589797499underline {text-decoration:underline;}#yiv7589797499 .yiv7589797499attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7589797499 .yiv7589797499attach div a {text-decoration:none;}#yiv7589797499 .yiv7589797499attach img {border:none;padding-right:5px;}#yiv7589797499 .yiv7589797499attach label {display:block;margin-bottom:5px;}#yiv7589797499 .yiv7589797499attach label a {text-decoration:none;}#yiv7589797499 blockquote {margin:0 0 0 4px;}#yiv7589797499 .yiv7589797499bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7589797499 .yiv7589797499bold a {text-decoration:none;}#yiv7589797499 dd.yiv7589797499last p a {font-family:Verdana;font-weight:700;}#yiv7589797499 dd.yiv7589797499last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7589797499 dd.yiv7589797499last p span.yiv7589797499yshortcuts {margin-right:0;}#yiv7589797499 div.yiv7589797499attach-table div div a {text-decoration:none;}#yiv7589797499 div.yiv7589797499attach-table {width:400px;}#yiv7589797499 div.yiv7589797499file-title a, #yiv7589797499 div.yiv7589797499file-title a:active, #yiv7589797499 div.yiv7589797499file-title a:hover, #yiv7589797499 div.yiv7589797499file-title a:visited {text-decoration:none;}#yiv7589797499 div.yiv7589797499photo-title a, #yiv7589797499 div.yiv7589797499photo-title a:active, #yiv7589797499 div.yiv7589797499photo-title a:hover, #yiv7589797499 div.yiv7589797499photo-title a:visited {text-decoration:none;}#yiv7589797499 div#yiv7589797499ygrp-mlmsg #yiv7589797499ygrp-msg p a span.yiv7589797499yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7589797499 .yiv7589797499green {color:#628c2a;}#yiv7589797499 .yiv7589797499MsoNormal {margin:0 0 0 0;}#yiv7589797499 o {font-size:0;}#yiv7589797499 #yiv7589797499photos div {float:left;width:72px;}#yiv7589797499 #yiv7589797499photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7589797499 #yiv7589797499photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7589797499 #yiv7589797499reco-category {font-size:77%;}#yiv7589797499 #yiv7589797499reco-desc {font-size:77%;}#yiv7589797499 .yiv7589797499replbq {margin:4px;}#yiv7589797499 #yiv7589797499ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7589797499 #yiv7589797499ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7589797499 #yiv7589797499ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7589797499 #yiv7589797499ygrp-mlmsg select, #yiv7589797499 input, #yiv7589797499 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7589797499 #yiv7589797499ygrp-mlmsg pre, #yiv7589797499 code {font:115% monospace;}#yiv7589797499 #yiv7589797499ygrp-mlmsg * {line-height:1.22em;}#yiv7589797499 #yiv7589797499ygrp-mlmsg #yiv7589797499logo {padding-bottom:10px;}#yiv7589797499 #yiv7589797499ygrp-msg p a {font-family:Verdana;}#yiv7589797499 #yiv7589797499ygrp-msg p#yiv7589797499attach-count span {color:#1E66AE;font-weight:700;}#yiv7589797499 #yiv7589797499ygrp-reco #yiv7589797499reco-head {color:#ff7900;font-weight:700;}#yiv7589797499 #yiv7589797499ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7589797499 #yiv7589797499ygrp-sponsor #yiv7589797499ov li a {font-size:130%;text-decoration:none;}#yiv7589797499 #yiv7589797499ygrp-sponsor #yiv7589797499ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7589797499 #yiv7589797499ygrp-sponsor #yiv7589797499ov ul {margin:0;padding:0 0 0 8px;}#yiv7589797499 #yiv7589797499ygrp-text {font-family:Georgia;}#yiv7589797499 #yiv7589797499ygrp-text p {margin:0 0 1em 0;}#yiv7589797499 #yiv7589797499ygrp-text tt {font-size:120%;}#yiv7589797499 #yiv7589797499ygrp-vital ul li:last-child {border-right:none !important;}#yiv7589797499
