¦p¦ó§Q¥ÎVBA¨Ó¹F¨ì "³sµ²" ®ÄªG?
- ©«¤l
- 95
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-11-10
- ³Ì«áµn¿ý
- 2020-5-25
|
¦^´_ 17# ã´£³¡ªL
¦pªG¨Ó·½ÀÉ( קïÀÉ)»P¥Ø¼ÐÀÉ(¨Ï¥ÎÀÉ)³£³Q«OÅ@µÛ¡A¨º»òVBA§Ú¦Û¤v§ï¦¨¦p¤U¡A¦ý¥Î°_¨Ó·Pı¦³ÂI©Ç©Çªº¡A¦n¹³¦³®É·|½Æ»s¦¨¥\¡A¦³®É·|¨S½Æ»s¨ì¡A¬O¨º¨à¦³°ÝÃD¶Ü?
Private Sub Workbook_Open()
Dim MyB As Workbook, xB As Workbook, xFile$
Set MyB = ThisWorkbook
xFile = ThisWorkbook.Path & "\קï¸ê®Æ§¨\קïÀÉ.xls" '¸ô®|ÀɦW¦Û¦æקï
Application.ScreenUpdating = False
Set xB = Workbooks.Open(xFile, ReadOnly:=True)
ActiveSheet.Unprotect "123" '¥ý¨ú®ø«OÅ@
xB.Sheets("¤u§@ªíA").[A1:H500].Copy MyB.Sheets("¤u§@ªía").[A1]
xB.Sheets("¤u§@ªíB").[AA1:AB20].Copy MyB.Sheets("¤u§@ªíb").[AA1]
xB.Close 0
ActiveSheet.Protect "123" '«·s³]©w«OÅ@
End Sub |
|
|
|
|
|
|
- ©«¤l
- 95
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-11-10
- ³Ì«áµn¿ý
- 2020-5-25
|
¦^´_ 19# ã´£³¡ªL
ì¨Ó¦p¦¹¡A"¤£¤@©w¬O¥Ø¼ÐÀɩΨÓìÀÉ" ³o¥y´£¿ô¤F§Ú;
¨º¥i¥H§ïÀ°§Ú¼g¦¨¶K¤W¥Ø¼ÐÀÉ«e¡A¥ý¸Ñ¶}¥Ø¼ÐÀɪº«OÅ@¡A¦A¶K¤W¥Ø¼ÐÀÉ¡A³Ì«á¦A«ì´_¥Ø¼ÐÀɪº«OÅ@¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 95
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-11-10
- ³Ì«áµn¿ý
- 2020-5-25
|
¦^´_ 21# ã´£³¡ªL
ÁÂÁÂã¤j«ü±Ð¡A¦³®É¶¡ªº¸Üªº½T¦Û¤v´ú¸Õ»·¤ñ¶K¤W¦¬Ã¬ªº¦h¡A¤]«Ü¸r¼}§A̯à¥Î±M·~´À¥L¤H¸Ñµª¡A³o¬O§ÚÌ·s¤â§V¤Oªº¥Ø¼Ð¡A¦A¦¸ÁÂÁ¸ÑÃD¡C |
|
|
|
|
|
|