How to Display the Message after the completion of OS task in EXCEL?

  • Thread starter Thread starter benazir
  • Start date Start date
B

benazir

Hi,


I am using a VB script in order to perform Operating system task via
EXCEL.

The routine, which is written in Excel VB, take a backup of files.

When the code runs it’s begin backup of several OS files via
Command prompt.

But after the completion of backup we can't know when its end or is it
successful or not.

I wanted that when this activity completes, a message box appear on
EXCEL, which informs that the task is completed and its status
(successful or unsuccessful).

What extra piece of code I add in the following code in order to
accomplish the desired result?

Could some please inform?

Thanks



Regards

Benazir





SAMPLE VB CODE:



strFileOut="c:\backup.sql"
set objFS=CreateObject("Scripting.FileSystemObject")
set objOutFile=objFS.OpenTextFile(strFileOut,2,1)
strOutput="backup datafile <datafile Name>;"
objOutFile.WriteLine strOutPut
set WShShell=CreateObject("WScript.Shell")
WShShell.Run "rman target / @c:\backup.sql"
 
see your next message.
Hi,

I am using a VB script in order to perform Operating system task via
EXCEL.

The routine, which is written in Excel VB, take a backup of files.

When the code runs it’s begin backup of several OS files via
Command prompt.

But after the completion of backup we can't know when its end or is it
successful or not.

I wanted that when this activity completes, a message box appear on
EXCEL, which informs that the task is completed and its status
(successful or unsuccessful).

What extra piece of code I add in the following code in order to
accomplish the desired result?

Could some please inform?

Thanks

Regards

Benazir

SAMPLE VB CODE:

strFileOut="c:\backup.sql"
set objFS=CreateObject("Scripting.FileSystemObject")
set objOutFile=objFS.OpenTextFile(strFileOut,2,1)
strOutput="backup datafile <datafile Name>;"
objOutFile.WriteLine strOutPut
set WShShell=CreateObject("WScript.Shell")
WShShell.Run "rman target / @c:\backup.sql"
Click to expand...
 
Back
Top