Coba : master2 sekalian
Public Sub Simpan()
Dim wbkTarget As Workbook
Dim shtAktif As Worksheet
Set shtAktif = ThisWorkbook.
Set wbkTarget = Workbooks.Add
shtAktif.Range("e5:e10").Copy wbkTarget.Sheets(
wbkTarget.SaveAs "c:\test.xls"
wbkTarget.Close False
shtAktif.Activate
End Sub
Regard
Kid.
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
| 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 |
+-------------------------------------------------------------------+
Nenhum comentário:
Postar um comentário