Hai Farud,Anda pakai Excel versi/th berapa ?
Salam,HK
From: "farud oke [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Wednesday, 10 May 2017, 16:41
Subject: Re: [belajar-excel] Mengubah Xlsm ke Xlsb dengan macro
Saya sudah coba apa yg mas hendrik berikan,tapi ketika dicoba tidak bisa
mas dan muncul peringatan seperti gambar dibawah.tapi ketika format
penyimpanannya diubah ke Xlsm bisa berjalan dg lancar,mohon saran dan
bimbingannya mas hendrik master2 excel yg lain
Pada tanggal 10 Mei 2017 10.58 AM, "hendrik karnadi [email protected]
[belajar-excel]" <[email protected]> menulis:
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
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
#yiv1308506269 #yiv1308506269 -- #yiv1308506269ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1308506269
#yiv1308506269ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1308506269
#yiv1308506269ygrp-mkp #yiv1308506269hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1308506269 #yiv1308506269ygrp-mkp #yiv1308506269ads
{margin-bottom:10px;}#yiv1308506269 #yiv1308506269ygrp-mkp .yiv1308506269ad
{padding:0 0;}#yiv1308506269 #yiv1308506269ygrp-mkp .yiv1308506269ad p
{margin:0;}#yiv1308506269 #yiv1308506269ygrp-mkp .yiv1308506269ad a
{color:#0000ff;text-decoration:none;}#yiv1308506269 #yiv1308506269ygrp-sponsor
#yiv1308506269ygrp-lc {font-family:Arial;}#yiv1308506269
#yiv1308506269ygrp-sponsor #yiv1308506269ygrp-lc #yiv1308506269hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1308506269
#yiv1308506269ygrp-sponsor #yiv1308506269ygrp-lc .yiv1308506269ad
{margin-bottom:10px;padding:0 0;}#yiv1308506269 #yiv1308506269actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1308506269
#yiv1308506269activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1308506269
#yiv1308506269activity span {font-weight:700;}#yiv1308506269
#yiv1308506269activity span:first-child
{text-transform:uppercase;}#yiv1308506269 #yiv1308506269activity span a
{color:#5085b6;text-decoration:none;}#yiv1308506269 #yiv1308506269activity span
span {color:#ff7900;}#yiv1308506269 #yiv1308506269activity span
.yiv1308506269underline {text-decoration:underline;}#yiv1308506269
.yiv1308506269attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1308506269 .yiv1308506269attach div a
{text-decoration:none;}#yiv1308506269 .yiv1308506269attach img
{border:none;padding-right:5px;}#yiv1308506269 .yiv1308506269attach label
{display:block;margin-bottom:5px;}#yiv1308506269 .yiv1308506269attach label a
{text-decoration:none;}#yiv1308506269 blockquote {margin:0 0 0
4px;}#yiv1308506269 .yiv1308506269bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1308506269
.yiv1308506269bold a {text-decoration:none;}#yiv1308506269 dd.yiv1308506269last
p a {font-family:Verdana;font-weight:700;}#yiv1308506269 dd.yiv1308506269last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1308506269
dd.yiv1308506269last p span.yiv1308506269yshortcuts
{margin-right:0;}#yiv1308506269 div.yiv1308506269attach-table div div a
{text-decoration:none;}#yiv1308506269 div.yiv1308506269attach-table
{width:400px;}#yiv1308506269 div.yiv1308506269file-title a, #yiv1308506269
div.yiv1308506269file-title a:active, #yiv1308506269
div.yiv1308506269file-title a:hover, #yiv1308506269 div.yiv1308506269file-title
a:visited {text-decoration:none;}#yiv1308506269 div.yiv1308506269photo-title a,
#yiv1308506269 div.yiv1308506269photo-title a:active, #yiv1308506269
div.yiv1308506269photo-title a:hover, #yiv1308506269
div.yiv1308506269photo-title a:visited {text-decoration:none;}#yiv1308506269
div#yiv1308506269ygrp-mlmsg #yiv1308506269ygrp-msg p a
span.yiv1308506269yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1308506269
.yiv1308506269green {color:#628c2a;}#yiv1308506269 .yiv1308506269MsoNormal
{margin:0 0 0 0;}#yiv1308506269 o {font-size:0;}#yiv1308506269
#yiv1308506269photos div {float:left;width:72px;}#yiv1308506269
#yiv1308506269photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1308506269
#yiv1308506269photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1308506269
#yiv1308506269reco-category {font-size:77%;}#yiv1308506269
#yiv1308506269reco-desc {font-size:77%;}#yiv1308506269 .yiv1308506269replbq
{margin:4px;}#yiv1308506269 #yiv1308506269ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1308506269 #yiv1308506269ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1308506269
#yiv1308506269ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1308506269
#yiv1308506269ygrp-mlmsg select, #yiv1308506269 input, #yiv1308506269 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1308506269
#yiv1308506269ygrp-mlmsg pre, #yiv1308506269 code {font:115%
monospace;}#yiv1308506269 #yiv1308506269ygrp-mlmsg *
{line-height:1.22em;}#yiv1308506269 #yiv1308506269ygrp-mlmsg #yiv1308506269logo
{padding-bottom:10px;}#yiv1308506269 #yiv1308506269ygrp-msg p a
{font-family:Verdana;}#yiv1308506269 #yiv1308506269ygrp-msg
p#yiv1308506269attach-count span {color:#1E66AE;font-weight:700;}#yiv1308506269
#yiv1308506269ygrp-reco #yiv1308506269reco-head
{color:#ff7900;font-weight:700;}#yiv1308506269 #yiv1308506269ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1308506269 #yiv1308506269ygrp-sponsor
#yiv1308506269ov li a {font-size:130%;text-decoration:none;}#yiv1308506269
#yiv1308506269ygrp-sponsor #yiv1308506269ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1308506269
#yiv1308506269ygrp-sponsor #yiv1308506269ov ul {margin:0;padding:0 0 0
8px;}#yiv1308506269 #yiv1308506269ygrp-text
{font-family:Georgia;}#yiv1308506269 #yiv1308506269ygrp-text p {margin:0 0 1em
0;}#yiv1308506269 #yiv1308506269ygrp-text tt {font-size:120%;}#yiv1308506269
#yiv1308506269ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1308506269
