Windows & DOS: Issues & Discussions

Hi all,

I am a very new user for korn scripting and in a process of learning.
i have a .bat file that calls a .vbs file which calls a macro used to convert an excel spread sheet to .csv file...
Now i want to automate this process. I want to call this bat file using a korn script or a korn script that runs my .vbs file...
can anyone say me how to do that
the .bat and .vbs files are on windows. Even the created new .cvs file is also placed on windows.
Below code cotains my .bat and .vbs files

.bat

Code:

 
start /w wscript.exe \\pb-a-024\xyz.vbs

.vbs

Code:

Dim xlApp, xlBook, xlSht 
Dim filename

filename = "\\pb-a-024\xyz.xls"
Set xlApp = CreateObject("Excel.Application")
set xlBook = xlApp.WorkBooks.Open(filename)
set xlSht = xlApp.activesheet

'xlBook.Close False
xlApp.Quit
'always deallocate after use...
set xlSht = Nothing 
Set xlBook = Nothing
Set xlApp = Nothing

Please enlight be how to slove this issue

Thanking You
Bhagya

Do you have ksh installed on Windows? If so, is it via cygwin or SCO or mks?

I am sorry i dont know that... can ypu say me how i can check that....??
Actually we have a cron which we use for sheduling the .ksh scripts on Unix box... now i have a .bat or .vbs file on my windows server which i want to trigger using ksh or corn so the conversion of file for .xls to .csv is done automatically.
I general we do FTP all of files form windows to Unixbox using FTP code in our ksh scripts... is there anyway i can trigger this bat file form cron or by Ksh script...

Please enlight me...

SO you have 2 servers? A windows box and a unix box...

You want the unix box to trigger a script on the windows box?

Yes.... Excatly.. i want to trigger a bat file on my windows form a ksh script on my Unix...

can i use rsh command in FTP to do this triggering...I already have FTP commection in my script which gets me a file generated by the bat file which i want to trigger form unix script...So i want to rsh command to run my bat file which generated .csv file which is then FTPed to Unix form windows...if i can please explain me'

Thanks

Are you running a rsh daemon on the windows box?

Just use the scheduler on the windows box.

Mmmm no i thought about it.... actually we are going to put this Ksh script on cron tab... so we want the ksh script to trigger the bat file so it generates the required file which is then FTPed to unix box...
When i say triggering i mean it should run the bat file...
I dont know about rsh daemon on windows... I am thinking to have rsh command in between my ftp.