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

¨D±Ï¡G¨äÀɮ׮榡»P°ÆÀɦW©Ò«ü©wªº®æ¦¡¤£¦P

¨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ÁÂ

¦^´_ 3# jimmyhk


¦^ÂФ@¤Uªñ¨Óªº±¡ªp
§Ú²{¦b©ó VBA ¤º¥[¤F¥H¤Uªºµ{§Ç,
´N¸Ñ¨M¤F¦³Ãö°ÝÃD
  1. '²Ä¤@²Õ, ¥Î§@Àˬd²{¨Ï¥Î Excel ª©¥»
  2. Sub CheckExcelVersion()
  3.      verarr = Array("8.0", "9.0", "10.0", "11.0", "12.0", "14.0")
  4.      vername = Array("97", "2000", "2002", "2003", "2007", "2010")
  5.     For i = 1 To 6
  6.     If verarr(i - 1) = Application.Version Then
  7.     Sheets("Sheet1").Range("A501") = vername(i - 1)
  8.     Exit For
  9.     End If
  10.     Next i
  11. End Sub


  12. '²Ä¤G²Õ...
  13. ...
  14. ...
  15. If e_ver = "2007" Then 'e_ver
  16. ActiveWorkbook.SaveAs fname3, 56 '¦pªG¬O Excel 2007, «h Save ¬° xlsx ®æ¦¡
  17. Else

  18. ActiveWorkbook.SaveAs fname3 '¦pªG¬O Excel2003/XP, «h Save ¬° xls ®æ¦¡
  19. End If
½Æ»s¥N½X

TOP

¦^´_ 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²{¦b­n¶}±ÒÀɮ׶Ü?"

©óÀˬd¸Ó¶×¥Xªº Excel ÀÉ®× (§Y abc.xls),
µo²{©ó¨Ï¥Î Excel 2007 °õ¦æ®É¥¦·|¦Û¤vÅܦ¨ xlsx ®æ¦¡¶×¥X....
³o­Ó°ÝÃD§Ú¤´¥¼§ä¨ì¤èªk¸Ñ¨M.

¤£¹L¤£ª¾³o­Ó°ÝÃD·|§_©M§A¤@¼Ë~~~

TOP

¤£¯à¥´¶}ÀÉ®×¥i¯à¦³«Ü¦h­ì¦]
µLOFFICE³nÅé
ª©¥»¤£¹ï
ªþÀɦW¤£¹ï
Ãa­y

ÁÙ¬O½Ð¤W¶ÇÀɮפj®a¸Õ¸Õ¬Ý§a
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD