VBÅŰæexcel´íÎó
Set xl = New Excel.Application
xl.Visible = True 'ÉèÖÃEXCEL¿É¼û
xl.Workbooks.Add
xl.Workbooks.Open ("C:\Documents and Settings\Administrator\×ÀÃæ\exportExcel.xls") '´ò¿ªÍøÒ³±£´æµÄEXCLEÎĵµ
Rows("1:1").Select 'Ñ¡Ôñ²¢É¾³ýµÚÒ»ÁÐ
Selection.Delete Shift:=xlUp
Dim rng As Range '¸³Óèrng±äÁ¿Range(µ¥Ôª¸ñ)ÊôÐÔ
Dim i As Integer, j As Integer '¼ÆËãexportExcelÎļþÖеÄÐС¢ÁÐÊý
Set rng = xl.ActiveSheet.UsedRange
i = rng.Rows.Count
j = rng.Columns.Count
Debug.Print i
Debug.Print j
EXCELAPP.ActiveSheet.Range("A1:P99").Sort Key1:=Range("H1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _
:=xlPinYin
Ö´ÐкóÄÜÍê³ÉÅÅÐò£¬µ«Êǵ¯³ö´°¿ÚÌáʾ¡°ÊµÊ±´íÎó424£¬ÒªÇó¶ÔÏó¡±£¬ÇëÎÊÕâ¸öÔõô¸Ä
Private Sub Cdload_Click()
Set xl = New excel.Application
xl.Visible = True 'ÉèÖÃEXCEL¿É¼û
 
Ïà¹ØÎÊ´ð£º
ÔÚvbÕâ±à³ÌÀïËÆºõÓкܶàµÄ¶«Î÷ÊÇÏàÁªÏµµÄ£¬ÎªÊ²Ã´ÓÐЩÈ˶ÔvbµÄ±à³ÌÃþ²»µ½Í·ÄÔ°¡£¡²¢ÇÒÓÐЩʺÜÈÝÒ׵쬵«ÊÇÈ´°ÑËüÃǵĴúÂë±ä³É¸´ÔÓ£¬Ò²È¥ÏëһЩ²»ÄÜʵÏֵĶ«Î÷°¡£¡
û·ÖÁË£¬Â¥Ö÷¶àÀ´µã·Ö£¡
À´½Óµã·Ö
......
³õѧ£¬´óµ¨ÌáÎÊ£¬Çë¸ßÊÖ²»ÁߴͽÌ
1¡¢¹ö¶¯Ìõµã»÷Óë»æÍ¼°å£¨ÆÁÄ»,Piceure1£©µÄÒÆ¶¯ÎÊÌâÒѾ½â¾ö¡£
Picture1.Top = -VScroll1.Value + bcW '´¹Ö±Òƶ¯
Picture1.Left = -HScroll1.Value + bcW ' ......
VBÔõÑù»ñµÃÊó±ê´¦µÄ³¬¼¶Á¬½ÓÄØ£¿
ÔÚWebBrowser¿Ø¼þÖÐÓÐÕâÑùÒ»¸öʼþ:StatusTextChange(index As Integer, ByVal Text As String)
ËüµÄText²ÎÊýÕýÊÇÊó±ê´¦µÄ³¬¼¶Á¬½Ó,µ«ÎÊÌâÊÇÈç¹ûÎÒµÄä¯ÀÀÆ÷Õýà ......
ÓÃvc±àдµÄdllÔÚdebugģʽºÍreleaseģʽÏÂÆô¶¯vbµÄexe³ÌÐòµ÷ÓÃvcµÄdll¿ÉÒԵõ½ÕýÈ·½á¹û£¬µ«ÊÇÈç¹ûÖ±½ÓË«»÷vbµÄexe³ÌÐòµ÷ÓÃdll±¨´í£¬ÔÚdllÄÚ²¿Ìí¼Ómessageboxºó·¢ÏÖÖ»ÒªÔÚº¯ÊýÄÚ²¿ÉùÃ÷std::stringÀàÐ͵ıäÁ¿¾Í»á³öÏÖÄ ......