Re: ]] XL-mania [[ Copy nama file.JPEG dan paste ke worksheet

 

OM OM.... ini hasil FILE EXCELNYA menggunakan VBA MACRO dengan langkah... 1. Pilih Path Folder 2. Hasil akan keluar dalam bentuk HYPER LINK 3. Hyper LINK bisa langsung dibuka ... Puthut Wibowo --- On Thu, 9/17/09, yayat ruhimat <yayat61@yahoo.com> wrote: From: yayat ruhimat <yayat61@yahoo.com> Subject: ]] XL-mania [[ Copy nama file.JPEG dan paste ke worksheet To: XL-mania@yahoogroups.com Date: Thursday, September 17, 2009, 7:04 PM   Dalam satu folder (misalnya D:\Foto) terdapat ribuan file.JPEG Misalnya F5171012302650001. JPEG F5171024308750025. JPEG F5171030312700005. JPEG dst Jika dilakukan secara manual (copy nama file.JPEG kemudian paste di worksheet) selain membutuhkan waktu lama, juga sangat dimungkinkan ter-copy paste nama file sama lebih dari satu. Mohon bantuan agar proses copy paste nama file.JPEG tidak secara manual. Terimaksaih atas bantuannya Regards Best regards, Yayat ____________ _________ _________ _________ _________ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail. yahoo.com

__._,_.___

Messages in this topic (2) Reply (via web post) | Start a new topic

Messages

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Selamat Idul Fitri... Mohon maap dari momods...                   |
| 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              |
+-------------------------------------------------------------------+

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

Recent Activity

•  37
  New Members

Visit Your Group

Give Back

Yahoo! for Good

Get inspired

by a good cause.

Y! Toolbar

Get it Free!

easy 1-click access

to your groups.

Yahoo! Groups

Start a group

in 3 easy steps.

Connect with others.

.

__,_._,___