]] XL-mania [[ save as dgn nama worksheet sesuai tanggal

 

dear pakar xl...

mohon bantuannya dong.. bagaimana caranya agar setelah saya copy suatu file kemudian sy paste ke worksheet lainnya
otomatis nama file awal berubah sesuai nama yg saya berikan dgn tanggal hari ini.. misalnya 20101221_Mkr_Daily_Position&Summary

mohon pencerahan pakar excel sekalian.. berikut saya lampirkan makro saya :

Private Sub CommandButton1_Click()
If Range("G69").Value = "NO MATCH" Then
MsgBox "Jumlah Petikemas Tidak Cocok !!", vbCritical, "DATA ERROR"
End
Else
Range("daily").Copy
Workbooks.Open Filename:="\\JPLMKR-01\D\Opd Ecs Interinsuler\Program New\YYYYMMDD_Mkr_Daily_Position&Summary.xlt", ReadOnly:=True
Worksheets("Sheet1").Range("a1").Select
ActiveSheet.Paste
End If
End Sub

------

tks n rgds

__._,_.___

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

Messages in this topic (1)

Recent Activity:

• New Members 99

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| sOrRy dOrRy j3K... m0m0dS LaGi HeC-tiC... waQaQaQa...             |
| 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

.

__,_._,___