> saya khan kepengen semua data2 yang muncul di MSFlexGrid itu bisa
saya copy
> ke Excel dengan cara select All tapi pake Click Kanan di pojok
paling kiri
> MSFlexGrid..??
>
> Saya belum tahu coding untuk click kanan dan copy clipboard ke
Excel atau
> semua MS Office.
>
> Thanks
>
coba make event MouseUp. disitu ada parameter Button & posisi mouse.
tes jk button = tombol_mouse_kanan, & posisi di pojok kiri.
untuk select all nya bisa make properti ColPos, RowPos, ColSel,
RowSel. coba cari petunjuk di helpnya.
untuk copy ke excel, pake aja reference Microsoft Excell (dr IDE menu
Project > Reference).
object yg mungkin bakal sampeyan pake a.l :
Application, Workbook, WorkSheet, Cell. coba cari contoh help-nya.
buka object browser (dari IDE tekan tombol F2), click object ybs,
tekan F1.
kalo ke clipboard, sampean bisa iterasi (looping) ke setiap cell di
flexgrid, per baris. tiap cell sampean pisah dng tab (vbTab), tiap
gantibaris di pisah dgn vbCrLf, disimpan di buffer. trus, set
clipboardnya
sBuffer = ""
for i = 1 to fg.Rows - 1
for j = 1 to fg.Cols - 1
sBuffer = sBuffer & fg.TextMatrix(j, i) & vbTab
next
sBuffer = sBuffer & fg.TextMatrix(j, i) & vbCrLf
next
Clipboard.Clear
Clipboard.SetText sBuffer
kurang lebih spt itu lah...,
coba dicek lg. barangkali parameter textmatrix kebalik
semoga membantu, dan selamat mencoba
salam,
huda
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hlvb9vt/M=362335.6886445.7839731.1510227/D=groups/S=1705115364:TM/Y=YAHOO/EXP=1123085164/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In
low income neighborhoods, 84% do not own computers. At Network for Good, help
bridge the Digital Divide!</a>.</font>
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> 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/
