¨D±Ï¡G¨äÀɮ׮榡»P°ÆÀɦW©Ò«ü©wªº®æ¦¡¤£¦P
- ©«¤l
- 44
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-24
- ³Ì«áµn¿ý
- 2023-9-21
|
¨D±Ï¡G¨äÀɮ׮榡»P°ÆÀɦW©Ò«ü©wªº®æ¦¡¤£¦P
¤½¥qSERVER¤º¸ê®ÆÂಾ¦Ü·sªºµwºÐ¡Aµ²ªG«Ü¦hEXCEL2007Àɮ׳£¥´¤£¶}¤F¡C
Àɮפj¤p¬ù400K¥ª¥k
¥X²{°T®§¡i¨äÀɮ׮榡»P°ÆÀɦW©Ò«ü©wªº®æ¦¡¤£¦P¡j¡C
½Ð±Ð¦p¦ó¸Ñ¨M?©Î¬O¥~±¦³À°§O¤H¸Ñ¨M×´_ªº¤½¥q¡C
·PÁÂ |
|
|
|
|
|
|
- ©«¤l
- 107
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 127
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2023-11-17
|
¦^´_ 3# jimmyhk
¦^ÂФ@¤Uªñ¨Óªº±¡ªp
§Ú²{¦b©ó VBA ¤º¥[¤F¥H¤Uªºµ{§Ç,
´N¸Ñ¨M¤F¦³Ãö°ÝÃD- '²Ä¤@²Õ, ¥Î§@Àˬd²{¨Ï¥Î Excel ª©¥»
- Sub CheckExcelVersion()
- verarr = Array("8.0", "9.0", "10.0", "11.0", "12.0", "14.0")
- vername = Array("97", "2000", "2002", "2003", "2007", "2010")
- For i = 1 To 6
- If verarr(i - 1) = Application.Version Then
- Sheets("Sheet1").Range("A501") = vername(i - 1)
- Exit For
- End If
- Next i
- End Sub
- '²Ä¤G²Õ...
- ...
- ...
- If e_ver = "2007" Then 'e_ver
- ActiveWorkbook.SaveAs fname3, 56 '¦pªG¬O Excel 2007, «h Save ¬° xlsx ®æ¦¡
- Else
- ActiveWorkbook.SaveAs fname3 '¦pªG¬O Excel2003/XP, «h Save ¬° xls ®æ¦¡
- End If
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 107
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 127
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2023-11-17
|
¦^´_ 1# hero_lin
§Úªñ¤é¦b¼g VBA (§Ú¬Oªì¤ßªÌ) ®É¥ç¦³¬Ý¨ì³oÓªF¦è.
·½°_¬O§Ú¥H Excel 2003 ¼g¤F¤@Ó¤pµ{¦¡,
¤º¸Ì·|§â¨ä¤¤¤@±i Sheets ¥t¦s¨ì¤@Ó·s«Øªº excel ÀÉ¥h.
¥H¥H¤U VBA ½X
ActiveSheet.Copy
ActiveWorkbook.SaveAs Filename:=fname3
ActiveWorkbook.Close True
¦p¥H Excel 2003 °õ¦æ¶×¥XªºÀɮ׬O abc.xls
¬O§¹¥þ¨S¦³°ÝÃDªº.
¦ý¦p³o¥y¥Ñ excel 2007 °õ¦æ,
¶×¥XªºÀÉ®×ÀɦW¤´¬O abc.xls
¦ý¨Ï¥Î Excel 2007 ¶}±Ò®É´N·|¦³
"¨äÀɮ׮榡»P°ÆÀɦW¤£¦P.¶}±ÒÀɮפ§«e,½Ð½T»{ÀÉ®×¥¼·l·´, ¥B¨Ó¦Û«H¥ôªº¨Ó·½.
§A²{¦bn¶}±ÒÀɮ׶Ü?"
©óÀˬd¸Ó¶×¥Xªº Excel ÀÉ®× (§Y abc.xls),
µo²{©ó¨Ï¥Î Excel 2007 °õ¦æ®É¥¦·|¦Û¤vÅܦ¨ xlsx ®æ¦¡¶×¥X....
³oÓ°ÝÃD§Ú¤´¥¼§ä¨ì¤èªk¸Ñ¨M.
¤£¹L¤£ª¾³oÓ°ÝÃD·|§_©M§A¤@¼Ë~~~ |
|
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
¤£¯à¥´¶}ÀÉ®×¥i¯à¦³«Ü¦hì¦]
µLOFFICE³nÅé
ª©¥»¤£¹ï
ªþÀɦW¤£¹ï
Ãay
ÁÙ¬O½Ð¤W¶ÇÀɮפj®a¸Õ¸Õ¬Ý§a |
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|