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

[µo°Ý] ¦p¦ó§Q¥Îvba°µ¬d¸ß

[µo°Ý] ¦p¦ó§Q¥Îvba°µ¬d¸ß

½Ð°Ý§Ú·Q§Q¥Îvba°µ¬d¸ß
¦ý¬°¦óµLªk¬d¸ß¨ìY:\¼Ú´ð-®w¦s\¶i¥X³f\«È¤H\34CO«È¤H.xls("²Î­p")¤ºªº­È©O?
¬O­þ¤@­Ó³¡¥÷¼g¿ù¤F.

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Row >= 1 And .Column = 2 Then
  .Offset(0, 3) = Application.VLookup(.Value, "Y:\¼Ú´ð-®w¦s\¶i¥X³f\«È¤H\34CO«È¤H.xls("²Î­p")".[C2:D500], 2, False)
End If
End With
End Sub

½Ð°Ý§Ú·Q§Q¥Îvba°µ¬d¸ß
¦ý¬°¦óµLªk¬d¸ß¨ìY:\¼Ú´ð-®w¦s\¶i¥X³f\«È¤H\34CO«È¤H.xls("²Î­p")¤ºªº­È©O?
¬O­þ¤@ ...
.Offset(0, 3) = Application.VLookup(.Value, "Y:\¼Ú´ð-®w¦s\¶i¥X³f\«È¤H\34CO«È¤H.xls("²Î­p")".[C2:D500], 2, False)
...
h99949 µoªí©ó 2014-12-31 10:35

§A½T©wÀɮצWºÙ¬O :      34CO«È¤H.xls("²Î­p")     ¶Ü?
§Ú¨S°O¿ùªº¸ÜÀɦW¤¤   .xls   À³¸Ó¦b³Ì¥kÃä, (§Y¨ä¥k¤è¤£À³¸Ó¦A¦³¨ä¥L¤å¦r¥X²{)
¥BÀɦW¤¤¤]¤£À³¸Ó¦³   "   ¥X²{³á.

TOP

¬O­n°Ñ·Ó¬¡­¶Ã¯34CO¸Ì¤u§@ªí ²Î­pªº·N«ä¶Ü¡H

TOP

¦^´_ 3# rbktwi


    ¬Oªº

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD