]] XL-mania [[ macro create log di excel file

 

master2 sekalian
saya baru di dunia per macroan .
lagi coba bikin program timer simple
ntar usernya, start time dan end time dimasukin ke excel file lain

kira2 macro gw kaya gini
Dim iFileNumber As Long
Dim strData As String
Dim strFileName As String

iFileNumber = FreeFile()
strData = Range("E5").Value
strFileName = "C:\test.xls" ' the text file
Open strFileName For Append Shared As #iFileNumber
Print #iFileNumber, strData
Close #iFileNumber

nah kalo gw mau datanya itu dari beberapa cell, mislanya E5, E6, E7
tapi masukin datanya juga per cell di test.xls
misalnya E5 ke A1, E6 ke A2, E7 ke A3
next nya ke E5 ke B1, E6 ke B2, E7 ke B3
dst

kira2 bentuk string datanya gmn ya bos?

mohon masukannya
masih newbie nih

thanks a lot ya

Regards,
Riyadi

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 83

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| yak.... tembus 15,000. member ke 15,000 angkat tangannnnn... mau  |
| momods kirimin coklat.... hehehe...                               |
| 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              |
+-------------------------------------------------------------------+

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

.

__,_._,___