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

±q¦r¦ê¤¤¨ú±o©T©w¦ì¸mªº¼Æ¦r

±q¦r¦ê¤¤¨ú±o©T©w¦ì¸mªº¼Æ¦r

Hello
·Q­n±q¦r¦ê¤¤¨ú±o©T©w¦ì¸mªº¼Æ¦r(µ¥¸¹«á­±ªº¼Æ¦r)
¦p: ·Q±q"h=8"¨ú¥X8
¥H¤Uµ{¦¡µLªk°õ¦æ, ¥i§_À°À°¦£, ­×§ï¤@¤U? ¶¶«KÀ°¦£Âন¼Æ­È. ÁÂÁÂ

Sub index()
Dim ar1, xx
Dim yy
ar1 = "h=8"
xx = InStr(1, ar1, "h", 1)
yy = Mid(ar1, xx + 1, 10)
End Sub

µ{¦¡°õ¦æ¤¤Â_®É,"³]©w¤Þ¥Î¶µ¥Ø"¤Ï¥Õ,¸Ñ°£«á,§Y¥i³]©w
¤Ä¿ï¨ú®ø"¿òº|......"
´ú¸ÕOK
¦A¤@¦¸ÁÂÁÂ

TOP

¦hÁ¤ì¤uª©¥Dªº¨ó§U
§ï¬°vba.mid¸Õ§@OK
¦ý¬O§Úªºvba½s¿è¾¹¤¤ªº¤u¨ã~"³]©w¤Þ¥Î¶µ¥Ø"¤¤¬O¤Ï¥Õ,µLªk³]©w­C,À³¸Ó¬O«D¥ø·~ª©ªºÃö«Y
ÁÙ¬OÁÂÁ°Õ!!

TOP

§A³o­ÓÀɮפ¤¦³¿ù»~ªº¤Þ¥Î¡A¨ìvba½s¿è¾¹¤¤ªº¤u¨ã~³]©w¤Þ¥Î¶µ¥Ø¤¤§ä¨ì¿ù»~¡A¨ú®ø¤Ä¿ï
©ÎªÌ­«¶}¤@­Ó·sÀɨӥÎ
¦A¤£µM§âmid§ï¬°vba.mid¸Õ¸Õ¡I

TOP

¸Õ¤F¤@¤U
¥i¬OÁÙ¬O¤@ª½¥X²{¤U­±°T®§
¬OExcel¤£§¹¾ã¶Ü? §Ú´«¤F´X¥x¹q¸£´ú¸Õ³£¤@¼Ë¥X²{½s¿è¿ù»~

TOP

ar1 = "h=8"
xx = InStr(ar1, "=")
yy = Mid(ar1, xx + 1, 10)
¥t¥~Sub index()
¤£¯à¥Î index §@¬°µ{¦¡¦W¡A¨t²Î«O¯d¦r

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD