Re: ]] XL-mania [[ makro cara copy ke file baru dengan format value

 

Salam kenal,

 

Solusinya adalah sbb:

1. Buat Sub Direktori dengan Nama Tes pada Direktori D
2. Copy kedua file terlampir pada Sub Direktori tsb (Tes)
3. Buka File Coba
4. tekan Ctrl z dan klik Yes(karena nama file "Coba_Coba sdh ada)

Ctrl z adalah tombol short cut yang hanya dapat dijalankan pada file tersebut (nama file dapat diubah).

Jika anda ingin mengubah Direktori dan Nama File maka anda harus mengubah sel E1 dengan penulisan sbb: Dir:\SubDir\Nama File.

 

Selamat mencoba.

 

Salam,

Hendrik Karnadi

 

 

 

---

From: "Yoesoef, Sofiani" <sofiani.yoesoef@anz.com>
To: XL-mania@yahoogroups.com
Sent: Tuesday, November 24, 2009 9:17:42
Subject: ]] XL-mania [[ makro cara copy ke file baru dengan format value

 

Dear para pakar,

 

Mohon bimbingan dan bantuannya untuk permasalahan saya,

 

Bagaimana yah caranya dengan makro untuk meng-copy satu file excel dengan banyak sheet ke file baru di directory dan nama file name tertentu, tapi hasilnya format datanya setelah dicopy jadi value semua tanpa merubah format yang aslinya.

 

terima kasih untuk bantuannya,

 

best regards,

sofiani yoesoef

 

 

 

 

 

 

 

 

"This e-mail and any attachments to it (the "Communication" ) is, unless otherwise stated, confidential,  may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication. "

---

Get your new Email address!
Grab the Email name you've always wanted before someone else does!

__._,_.___

Reply to sender | Reply to group

Messages in this topic (3)

Recent Activity:

• New Members 75

Visit Your Group Start a New Topic

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Momods lagi hanimuuunnn...                                        |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

MARKETPLACE

Going Green: Your Yahoo! Groups resource for green living

---

Going Green: Your Yahoo! Groups resource for green living

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___