- ©«¤l
- 214
- ¥DÃD
- 74
- ºëµØ
- 0
- ¿n¤À
- 296
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- hk
- µù¥U®É¶¡
- 2013-6-17
- ³Ì«áµn¿ý
- 2018-11-3
|
¦^´_ 2# mark15jill
¥i¯à§Ú³¯z¤£²M·¡,§Úªºn¨D¬O"¤£¶}±Òexcel¤å¥ó,¦p¦óª¾¹D¬Y¤å¥ó¨½¦³¬Ysheet¦s¦b",©Ò¥H§Aªº°µªk¤£¯à¥Î,§Ú¦Û¤v¼g¤FÓfunction,¤w¸g¥Î¤W,¤£¤Ó¼vÅTµ{§Ç°õ¦æ³t«×.
''''´ú¸Õ¤å¥ófl(fl¬O¤å¥óªº¸ô®|)¨½¦³¨S¦³sheets("Test A"),¦Ó¸Ósheetªº[A1]="ABC"
Function Benew(fl$) As Boolean
Dim Fname$, Fpath$, temp$, temp2
Fname = Right(fl, Len(fl) - InStrRev(fl, "\"))
Fpath = Replace(fl, Fname, "")
On Error Resume Next
temp = "'" & Fpath & "[" & Fname & "]Test A'!R1C1"
temp2 = Application.ExecuteExcel4Macro(temp)
Benew = IIf(temp2 = "ABC", True, False)
End Function
§Ún±q55000Ó¤å¥ó´£¨ú¸ê®Æ.¦]¬°³o¨Ç¤å¥ó¦³2ºØ¤£¦P®æ¦¡,¨ä¤¤1ºØ®æ¦¡¬O¤å¥ó¨½¦³±isheet,¦W¬°"Test A",¦Ó¥BTest A¶ªº[a1]="ABC"
§Ú²{¦b§Q¥Î¤W±function,§Y®É¥i¥H°Ï¤À³o55000¤å¥ó,þ¨Ç¬O²Ä¤@ºØ®æ¦¡,þ¨Ç¬O²Ä¤GºØ®æ¦¡,µM«á¥Î¤£¦Pªº¤èªk¨ú¸ê®Æ.¨Ã¤£¤Q¤À¼vÅT³t«×.
¦]¬°©T©w®æ¦¡ªº¸ê®Æ¨½¥²©w¦³¬Y©T©w¦ì¸mªºÈ¬O©T©wªº,¤W±¨úªº[a1]="ABC"´N¬O©T©w¦ìªº·N«ä¥Ü·N. |
|