- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
        
|
¦^´_ 4# die78325
n¦h¬Ý¬Ý VBA ªº»¡©ú
§Ú¸ÕµÛ«Å§i dim dd as workbooks
Workbooks ÄÝ©Ê ©w¶Ç¦^ Workbooks ¶°¦X¡A¦¹¶°¦X¥Nªí©Ò¦³¶}±Òªº¬¡¶Ã¯¡C°ßŪ¡C
Workbook ª«¥ó ¥Nªí Microsoft Excel ¬¡¶Ã¯¡C
Workbook ª«¥ó¬O Workbooks ¶°¦Xªº¦¨û¡CWorkbooks ¶°¦X¥]§t¥Ø«e Microsoft Excel ¤¤©Ò¦³¶}±Òªº Workbook ª«¥ó¡C
- Option Explicit
- Sub EX()
- Dim dd As String '¦r¦ê«¬ºA
- dd = Sheets("ºô¶°Ï").Range("A2")
- Workbooks.Open (dd)
- End Sub
½Æ»s¥N½X |
|