tolongin dong,
saya upload satu file excell di web, didalamnya ada tabel-tabel yang
akan diisi banyak orang, dengan add, submit dan exit button.
Sementara ini yang jadi hanya fungsi submit & exit, itupun gak
sempurna. add = kalau mau tambah data, submit untuk save as ke folder
tertentu. Jadi kepinginnya:
kalau orang klik link di web, file excel akan muncul tapi read-only.
Kalau 'Add' diklik, baru deh orang bisa nambah-nambah. exit untuk
menutup excell.
code nya cuman gini, di vb editor:
Private Sub CommandButton1_Click()
Application.Quit
End Sub
Private Sub CommandButton2_Click()
ChDir "\\lyta\office\dept"
ActiveWorkbook.SaveAs Filename:= _
"\\lyta\office\dept\Monthly report.xls"
End Sub
--------------------------------------------
CommandButton2 = submit, CommandButton1 = exit.
masalahnya koq kadang bisa kadang enggak ya? di XP malah kalau di
submit gak terjadi apa-apa (saya bikin di w2000).
help dong tolongin,..
makasii banyak yaaaa
-lyta-
------------------------ Yahoo! Groups Sponsor --------------------~-->
Something is new at Yahoo! Groups. Check out the enhanced email design.
http://us.click.yahoo.com/R0DZdC/gOaOAA/E2hLAA/BRUplB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/mailplus/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
