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

[µo°Ý] ¦³Ãö¼½©ñ´¡¥ó­µ®ÄÀÉ°ÝÃD

[µo°Ý] ¦³Ãö¼½©ñ´¡¥ó­µ®ÄÀÉ°ÝÃD

¥Ñ©ó±ý©ó Excel VBA ¥[¤J¹Ï¹³°T®§´£¿ô¥~,
ªñ¤é¥ç¶}©l¥[¤J¸Ü­µ´£¥Ü.
¥t¬°¤F´î¤Ö xls Àɮתº®e¶q,
§Ú§â¼½©ñªº­µ®ÄÀɤÀ¬°¨âÃþ,
¤@Ãþ¬Oµøµ¡¤º¸m¦³ªº­µ®ÄÀÉ,
§Ú¨Ï¥Î¥H¤U¤è¦¡¼½©ñ.
  1. Private Declare Function sndPlaySound32 _
  2. _
  3.     Lib "winmm.dll" _
  4.     Alias "sndPlaySoundA" ( _
  5.         ByVal lpszSoundName As String, _
  6.         ByVal uFlags As Long) As Long
  7. Sub PlayFunishWavFile()
  8.     sndPlaySound32 "C:\Windows\Media\tada.wav", 0&
  9. End Sub
½Æ»s¥N½X
·í­n¼½©ñªº®É­Ô¥u¥Î application.run "PlayFinishWavFile" ³o¤@¥y´N¥i¥H.
³o­Ó¤èªk©ó Excel 2003 ©M 2007 ¬Ò¨S¦³¥X²{°ÝÃD.

²Ä¤GÃþªº­µ®ÄÀɧڥHª«¥óªº¤èªk´¡¤J¨ì Excel ¤º,
¨Ï¥Î¥¨¶°¿ý¨úªº¤èªk¨ú±o¥H¤U¥N½X.
  1. Sub PlayWelcomeWavFile()
  2.     Sheets("Data_Field").Select
  3.     Sheets("Data_Field").Shapes("Object 1410").Select
  4.     Selection.Verb Verb:=xlPrimary
  5. End Sub
½Æ»s¥N½X
·í­n¼½©ñªº®É­Ô¥u¥Î application.run "PlayWelcomeWavFile" ³o¤@¥y´N¥i¥H.
³o­Ó¤èªk©ó Excel 2003 ¨S¦³¥X²{°ÝÃD,
¦Ó¥B®ÄªG§Ú¤Q¤Àº¡·N.
¦ý·í§Ú§â³o­ÓÀɮײ¾¦Ü 2007 °õ¦æ®É,
¥X²{¤F¥H¤U°ÝÃD:

1.  ­ì©óÀɮשl­º°õ¦æªº
  1. Private Sub Workbook_Open()
  2. Application.ScreenUpdating = False
  3. Application.Visible = False
½Æ»s¥N½X
, ©ó²Ä¤@¦¸°õ¦æ¼½©ñ´¡¥ó­µ®ÄÀɮɳo¨â­Ó«ü¥O´N·|¥¢®Ä,
·|¦Û¦æÅã¥Ü¦^¨Ó.

2.  ©ó¼½©ñ­µ®ÄÀɮɷ|¼u¥X Windows Media Player, ¦ý©ó 2003 °õ¦æ®É¤£·|¦³³o­Ó±¡ªp.


½Ð°Ý°ÝÃD¥X¦b¨º¸Ì, ¬O 2007 ªº°ÝÃDÁÙ¬O...?

½Ð«ü±Ð

¥»©«³Ì«á¥Ñ jimmyhk ©ó 2011-10-23 07:04 ½s¿è
¥Ñ©ó±ý©ó Excel VBA ¥[¤J¹Ï¹³°T®§´£¿ô¥~,
ªñ¤é¥ç¶}©l¥[¤J¸Ü­µ´£¥Ü.
¥t¬°¤F´î¤Ö xls Àɮתº®e¶q,
§Ú§â¼½©ñ ...
jimmyhk µoªí©ó 2011-10-19 06:45


¤µ¦­¦bºô¤W³o¸Ì http://blogs.technet.com/b/csstwplatform/archive/2010/02/06/windows-vista-7-cannot-add-movie-ole-object-using-office-2007.aspx §ä¨ì¤@½g¸Ñ»¡,
²{¦b¤j­P©ú¥Õ¬°¦ó¦P¼Ë´¡¤Jªº­µ®ÄÀÉ (wav) ©ó 2003 ©M 2007.  (§ó¥¿, ¬O¦b XP ©M windows7 ) ·|¦³¤£¦Pªº¤ÏÀ³.

¦ý²{¦b¥¼¦³¤èªk¥i¥H¸Ñ¨M³o­Ó¬Û®eªº°ÝÃD.
(¦p¥u¬O³æ¤@­n¸Ó xls Àɮצb 03 ¤W°õ¦æ, ©Î¥u¦b 07 ¤W°õ¦æ, «h¨S¦³³o­Ó°ÝÃD.)

¤j®a¦³¨S¦³¤°»ò¥i¸Ñ¨Mªº¤èªk©Î·Qªk?

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD