Terima kasih sebelumnya Mr. Kid, saya lagi mempelajari panduan yang dari
microsoft.
Jadi muncul pertanyaan kembali, kalo macro untuk mendeteksi office 32bit atau
64bit gimana ya?Rencananya, biar aplikasi yang saya buat bisa dipakai dikedua
versi tersebut tanpa utak atik macro lagi.Terima kasih atas solusinya
SalamHaris
On Tuesday, October 27, 2015 5:34 AM, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
Hai Haris,
UDF yang ada di :
https://groups.yahoo.com/neo/groups/belajar-excel/conversations/topics/18550?soc_src=mail&soc_trk=ma
dibuat untuk Office 32 Bit.
Penggunaan di Office 64 Bit, diperlukan atribut PtrSafe pada deklarasinya.
Lihat di :
https://msdn.microsoft.com/en-us/library/office/ee691831%28v=office.14%29.aspx
Wassalam,
Kid
On Mon, Oct 26, 2015 at 9:37 PM, ris ha [email protected] [belajar-excel]
<[email protected]> wrote:
Terima kasih pak Hendrik, saya udah mencari, yang paling mendekati yaitu
di alamat ini
| |
| | | | | | | |
| Yahoo! GroupsHai Kurei, 1.Bagaimana mengecek apakah IP yang digunakan masih
di komputer yang sama ? |
| |
| View on groups.yahoo.com | Preview by Yahoo |
| |
| |
, tapi error. Ada perintah agar meng update menjadi 64bit, kebetulan excel saya
64 bit..., gimana ya? mohon pencerahannya
On Monday, October 26, 2015 9:02 PM, "Hendrik Karnadi
[email protected] [belajar-excel]" <[email protected]> wrote:
Hai Haris,Coba cari di arsip milis, seingat saya Mr.Kid pernah share di
milis ini.
Salam,HK
Sent from Samsung Mobile
-------- Original message --------From: "ris ha [email protected]
[belajar-excel]" Date:26/10/2015 8:34 PM (GMT+07:00) To: yahoogroups Subject:
[belajar-excel] Macro untuk mengambil IP Address Komputer
Assalamu'alaikum.Selamat malam para master semua, mohon bantuan dan
solusinya. Bagaimana cara mengambil IP Address Komputer, kemudian di letakkan
di sheet 1 Range A1 misalkan.
Terima kasih banyak, semoga menjadi ilmu yang sangat bermanfaat sepanjang hayat.
SalamHaris
#yiv6269508878 #yiv6269508878 -- #yiv6269508878ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6269508878
#yiv6269508878ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6269508878
#yiv6269508878ygrp-mkp #yiv6269508878hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6269508878 #yiv6269508878ygrp-mkp #yiv6269508878ads
{margin-bottom:10px;}#yiv6269508878 #yiv6269508878ygrp-mkp .yiv6269508878ad
{padding:0 0;}#yiv6269508878 #yiv6269508878ygrp-mkp .yiv6269508878ad p
{margin:0;}#yiv6269508878 #yiv6269508878ygrp-mkp .yiv6269508878ad a
{color:#0000ff;text-decoration:none;}#yiv6269508878 #yiv6269508878ygrp-sponsor
#yiv6269508878ygrp-lc {font-family:Arial;}#yiv6269508878
#yiv6269508878ygrp-sponsor #yiv6269508878ygrp-lc #yiv6269508878hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6269508878
#yiv6269508878ygrp-sponsor #yiv6269508878ygrp-lc .yiv6269508878ad
{margin-bottom:10px;padding:0 0;}#yiv6269508878 #yiv6269508878actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6269508878
#yiv6269508878activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6269508878
#yiv6269508878activity span {font-weight:700;}#yiv6269508878
#yiv6269508878activity span:first-child
{text-transform:uppercase;}#yiv6269508878 #yiv6269508878activity span a
{color:#5085b6;text-decoration:none;}#yiv6269508878 #yiv6269508878activity span
span {color:#ff7900;}#yiv6269508878 #yiv6269508878activity span
.yiv6269508878underline {text-decoration:underline;}#yiv6269508878
.yiv6269508878attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6269508878 .yiv6269508878attach div a
{text-decoration:none;}#yiv6269508878 .yiv6269508878attach img
{border:none;padding-right:5px;}#yiv6269508878 .yiv6269508878attach label
{display:block;margin-bottom:5px;}#yiv6269508878 .yiv6269508878attach label a
{text-decoration:none;}#yiv6269508878 blockquote {margin:0 0 0
4px;}#yiv6269508878 .yiv6269508878bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6269508878
.yiv6269508878bold a {text-decoration:none;}#yiv6269508878 dd.yiv6269508878last
p a {font-family:Verdana;font-weight:700;}#yiv6269508878 dd.yiv6269508878last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6269508878
dd.yiv6269508878last p span.yiv6269508878yshortcuts
{margin-right:0;}#yiv6269508878 div.yiv6269508878attach-table div div a
{text-decoration:none;}#yiv6269508878 div.yiv6269508878attach-table
{width:400px;}#yiv6269508878 div.yiv6269508878file-title a, #yiv6269508878
div.yiv6269508878file-title a:active, #yiv6269508878
div.yiv6269508878file-title a:hover, #yiv6269508878 div.yiv6269508878file-title
a:visited {text-decoration:none;}#yiv6269508878 div.yiv6269508878photo-title a,
#yiv6269508878 div.yiv6269508878photo-title a:active, #yiv6269508878
div.yiv6269508878photo-title a:hover, #yiv6269508878
div.yiv6269508878photo-title a:visited {text-decoration:none;}#yiv6269508878
div#yiv6269508878ygrp-mlmsg #yiv6269508878ygrp-msg p a
span.yiv6269508878yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6269508878
.yiv6269508878green {color:#628c2a;}#yiv6269508878 .yiv6269508878MsoNormal
{margin:0 0 0 0;}#yiv6269508878 o {font-size:0;}#yiv6269508878
#yiv6269508878photos div {float:left;width:72px;}#yiv6269508878
#yiv6269508878photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6269508878
#yiv6269508878photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6269508878
#yiv6269508878reco-category {font-size:77%;}#yiv6269508878
#yiv6269508878reco-desc {font-size:77%;}#yiv6269508878 .yiv6269508878replbq
{margin:4px;}#yiv6269508878 #yiv6269508878ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6269508878 #yiv6269508878ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6269508878
#yiv6269508878ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6269508878
#yiv6269508878ygrp-mlmsg select, #yiv6269508878 input, #yiv6269508878 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6269508878
#yiv6269508878ygrp-mlmsg pre, #yiv6269508878 code {font:115%
monospace;}#yiv6269508878 #yiv6269508878ygrp-mlmsg *
{line-height:1.22em;}#yiv6269508878 #yiv6269508878ygrp-mlmsg #yiv6269508878logo
{padding-bottom:10px;}#yiv6269508878 #yiv6269508878ygrp-msg p a
{font-family:Verdana;}#yiv6269508878 #yiv6269508878ygrp-msg
p#yiv6269508878attach-count span {color:#1E66AE;font-weight:700;}#yiv6269508878
#yiv6269508878ygrp-reco #yiv6269508878reco-head
{color:#ff7900;font-weight:700;}#yiv6269508878 #yiv6269508878ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6269508878 #yiv6269508878ygrp-sponsor
#yiv6269508878ov li a {font-size:130%;text-decoration:none;}#yiv6269508878
#yiv6269508878ygrp-sponsor #yiv6269508878ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6269508878
#yiv6269508878ygrp-sponsor #yiv6269508878ov ul {margin:0;padding:0 0 0
8px;}#yiv6269508878 #yiv6269508878ygrp-text
{font-family:Georgia;}#yiv6269508878 #yiv6269508878ygrp-text p {margin:0 0 1em
0;}#yiv6269508878 #yiv6269508878ygrp-text tt {font-size:120%;}#yiv6269508878
#yiv6269508878ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6269508878
