ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð±Ð¦³ÃöWORDªí®æ¤º¸ê®Æ³sµ²¦ÜEXCEL

½Ð±Ð¦³ÃöWORDªí®æ¤º¸ê®Æ³sµ²¦ÜEXCEL

¥»©«³Ì«á¥Ñ mgame168 ©ó 2010-10-1 08:05 ½s¿è

½Ð±Ð¦U¦ì¥ý¶i:
     ¥ý«e¦b½×¾Â¤Wª¦¤å¡A§ä¨ì¤F¤@½g¥Ñianlcc¤j©Ò´£¥Xªº°ÝÃD"¦³ÃöEXCELÀx¦s®æ¤º¸ê®Æ³sµ²¦ÜWORD"
  ­Y¤Ï¤§¡A§Ú·Q±qWORDªí®æ¤º¸ê®Æ³sµ²¦ÜEXCEL¡A¸Ó¦p¦ó°µ©O?

½Ð±Ð¦U¦ì¥ý¶i:
     ¥ý«e¦b½×¾Â¤Wª¦¤å¡A§ä¨ì¤F¤@½g¥Ñianlcc¤j©Ò´£¥Xªº°ÝÃD
  ­Y¤Ï¤§¡A§Ú·Q±qWORDªí®æ¤º¸ê ...
mgame168 µoªí©ó 2010-9-29 14:33



    http://gb.twbts.com/index.php?topic=5783.msg32244
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

³á~ ·PÁ§iª¾

TOP

¦^´_ 2# PD961A


ÁöµM§Q¥Î¶W³sµ²ªºÆ[©À±NWORDÀɸ̪º¸ê®Æ½Æ»s¨ìEXCEL¸Ì¸ê®Æ·|¦Û°ÊÀH®É§ó·s«D±`¤è«K¡A¦ý¬O¦³¤@­Ó°ÝÃD¡ã­Y¬OWORDÀɸ̦³´¡¤J¤@¦C·s¸ê®Æ¡A®Ú¾Ú§Úªº´ú¸ÕEXCELÀɤ£·|¦Û°Ê¸òµÛ¦h¼W¥[¤@¦C¸ê®Æ¡A¥¦¥u·|©¹¤U»¼©µ¦Ó¤w¡A³Ì«áªºµ²ªG´N¬O­ì¦³ªº³Ì«á¤@µ§¸ê®Æ·|³Q¿òº|¡ãµLªk¦Û°Ê³sµ²½Æ»s¨ìEXCELÀɸ̡I
¬O§_¦³·s¼W¸ê®Æ®É¡A´N±o­«·s¥Î¤H¤u¤è¦¡¦A³sµ²½Æ»s¦ÜEXCELÀÉ©O¡H

TOP

¦^´_ 4# onegirl0204


    http://gb.twbts.com/index.php?topic=5783.0

« ¦^ÂФ峹 #1 ©ó: 2007-02-20, 00:53:33 »  

--------------------------------------------------------------------------------
§A¥i¹Á¸Õ¥ý§âWord¤ºªºªí®æ¤½¦¡ªº­È¡A¦p§Aªº¨Ò¤l¬O¡u1000¡v¡A¿ï¨ú«á½Æ»s¡AµM«á¨ìExcel¤ºA2Àx¦s®æ¤º¡AÂI¿ï¤U©Ô¦¡¡u¤u¯àªí¦C¡v¤ºªº¡u½s¿è¡v¡u¿ï¾Ü©Ê¶K¤W¡v¡A¡u¦b¶K¤W¦¨¬°(A)¡v¤U¿ï¨ú¡u¶W³sµ²¡v¡AÁÙ­nÂI¿ï¥ªÃ䪺¡u¶K¤W³sµ²(L)¡v¡AµM«á«ö¡u½T©w¡v¶K¤W¡A¨º¥H«á§A¦bWord¤ºªº¤½¦¡­È¦p¦³§ó·s¡A§A¶}±Ò¦¹ExcelªºFile¤ºA2ªº­È¤]·|¦Û°Ê§ó·s¡C§Æ±æ³o¯àÀ°¨ì§A¸Ñ¨M§Aªº°ÝÃD¡C

  ¤w°O¿ý   
jumky
°ª¤¤¥Í
Â÷½u
¤å³¹: 200


  Re: ½Ð°Ý¦p¦óÅýWORDªí®æ»PEXCELªí®æ°µ³sµ²?
« ¦^ÂФ峹 #2 ©ó: 2007-02-21, 10:33:58 »  
--------------------------------------------------------------------------------
bb_total ¤j¤j¡G
ÁÂÁÂÅo...¦³¶W³sµ²¯u¬O¤è«K§r...  
   ¤w°O¿ý  
jumky
°ª¤¤¥Í
Â÷½u
¤å³¹: 200
  Re: ½Ð°Ý¦p¦óÅýWORDªí®æ»PEXCELªí®æ°µ³sµ²?
« ¦^ÂФ峹 #3 ©ó: 2007-02-21, 10:47:47 »  
--------------------------------------------------------------------------------
bb_total ¤j¤j¡G
¥i¬O§A¨º­Ó¬O¥ÎwordÀɬ°°ò·Ç..¤]´N¬OwordÀɦ³Åܧó..excelÀH§YÅܧó
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¦^´_ 5# PD961A


ªþ¤WÀÉ®×»¡©ú·|¸û¬°²M·¡¡ã wordÂà¶Kexcel.rar (7.86 KB)

TOP

·PÁ¦U¦ì¥ý¶iªº¦^À³

§Ú·Q³o­Ó°ÝÃDÀ³¸Ó¬O¤@¶}©l©w¸q¨Ó·½¸ê®Æªº°ÝÃD§a!
¤@¶}©l§Ú­Ì´N©w¸qOLE_LINK1¬°5x6ªº¸ê®Æªí
«á¨Ó·s¼Wªº¦ÛµM¤]´N¤£¦bªÌ­Ó½d³ò¤º, ¦P²z, ­Y§Ú¦b
Word´¡¤J¤@Äæ, Åܦ¨6x6ªº¸ê®Æªí, «hExcelÅã¥Ü
ÁÙ¬O°±¯d¦b5x6ªº¸ê®Æªí!

§Ú­ì©lªº·Qªk¬OWordªí®æ¤º¸ê®Æ³sµ²¦ÜEXCEL
¬O§_¯à¹³VLookUp¤@¼Ë¦n¥Î, ¯àÅý§Ú­Ì¨Ï¥Îªº¦Û¥Ñ
«×¡B»P¼u©Ê°ª¤@ÂI~

TOP

RE: EXCEL ªº¶×¤J¥~³¡¸ê®Æ

¦^´_ 7# mgame168
¦bwordµ{¦¡¸ÌÅܧódoc «á½Ð±NÀÉ®× [¥t¦s¬°ºô­¶]   ¨Ò:¤å¥ó1.mht
½Ð¦bxls Àɮפ¤ ±N¤U¦Cµ{¦¡½Æ»s©ó ThisWorkbookª«¥ó¸Ì
¦sÀÉ«á ¨C·í xls ¶}±Ò®É ¦Û°Ê§ó·s¬° docªº³Ì·s¸ê®Æ
  1. Private Sub Workbook_Open()
  2. With Sheet1
  3. If .QueryTables.Count = 0 Then
  4. .QueryTables.Add "URL;file:///D:/TEST/¤å¥ó1.mht", .[A1]
  5. Else
  6. .QueryTables(1).Connection = "URL;file:///D:/TEST/¤å¥ó1.mht"
  7. End If
  8. .QueryTables(1).Refresh
  9. End With
  10. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD