Tuesday, August 27, 2013

Enable and Disable of Excel Error Message



These alerts can be turned off by using this VBA-code:

Application.DisplayAlerts = False

After a routine you must turn on alert messages:

Application.DisplayAlerts = True

Related Posts:

  • Check file exist Here is how to check for file exist while we copy to or from machine’s data Example below show the checking of CMD.exe in Windows\system32 folder… Read More
  • How many Cell is filled in Row Having the ability to check the length of Row will give you the option to run script for the list of items in your EXCEL spreadsheet Here we are… Read More
  • Wait command Sometime we want the script to run a little bit slower than the time we executed them. Here is the command to wait for 6 sec Wscript.Echo "Ti… Read More
  • Check folder Existence Checking of folder existence to minimise extra step in your script. Below is an example to check for C:\Windows folder set objDRV = CreateObj… Read More
  • Folder Creation Here is how you create a folder Just put in the folder destination on the 2nd line and the name of the folder follow by “\” Set objFSO = Cr… Read More

0 comments:

Post a Comment