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

[µo°Ý] ³Â·Ð¦U¦ì°ª¤â¬Ý¤@¤U ¦³Ãö³]©w¯S©w¹q¸£¶}±ÒVBAªº°ÝÃD

¦^´_ 4# e19821223
  1. Option Explicit
  2. Private Sub Workbook_Open()
  3.     Dim mypath As String, myfile As String
  4.     mypath = "d:\"
  5.     myfile = Dir(mypath & "test.TXT")
  6.     If myfile = "" Then
  7.         MsgBox "½Ð¦b«ü©w¹q¸£§@·~¡A¤~¯à¶}±ÒÀÉ®×", vbOKOnly
  8.         ActiveWorkbook.Close SaveChanges:=False
  9.     End If
  10. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD