Calling a .bat file using Korn script

bhagya2340 · #1 (**permalink**) 01-08-2009

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Calling sql file from shell script	chintapalli001	UNIX for Advanced & Expert Users	1	11-24-2008 12:39 PM
calling a cgi file from shell script????	elavv	Shell Programming and Scripting	1	08-07-2008 04:32 AM
calling sql file from shell script	dummy_needhelp	Shell Programming and Scripting	6	09-30-2007 11:55 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by