Computing.Net > Forums > Unix > Calling a .bat file using Korn scri

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to get for your free account now!

Calling a .bat file using Korn scri

Reply to Message Icon

Name: bhagya2340
Date: January 8, 2009 at 13:00:49 Pacific
OS: Windows XP
CPU/Ram: 2
Manufacturer/Model: Hewlett-packard / Q
Subcategory: Software Problems
Comment:

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 = NothingPlease enlight be how to slove this issue

Thanking You
Bhagya


Report Offensive Message For Removal
Reply to Message Icon

Related Posts

See More







Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links

Ads by Google


Results for: Calling a .bat file using Korn scri

Calling a bat file from Korn www.computing.net/answers/unix/calling-a-bat-file-from-korn/8123.html

invoke bat file from FTP Urgent! www.computing.net/answers/unix/invoke-bat-file-from-ftp-urgent/7088.html

Status of a remote file using SCP? www.computing.net/answers/unix/status-of-a-remote-file-using-scp/7390.html