01-08-2009
how to call a .bat file using KSH
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 filenamefilename = "
\\pb-a-024\xyz.xls"Set xlApp = CreateObject("Excel.Application")set xlBook = xlApp.WorkBooks.Open(filename)set xlSht = xlApp.activesheet'xlBook.Close FalsexlApp.Quit'always deallocate after use...set xlSht = Nothing Set xlBook = NothingSet xlApp = Nothing
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi!!
Is there a possibility to call/start a subproces using ksh ??
Hope that there is somebody to help me.
thanks in advance.
Corine (3 Replies)
Discussion started by: TheBlueLady
3 Replies
2. Windows & DOS: Issues & Discussions
hi evry one , I did some ksh scripts for file editing in AIX 5.2 ver,
issue is while I was trying to run these scripts in windows box as batch files windows is not recognising the awk part of the ksh script,as it is GNU environment, so any one who can help me will be appreciated.
this is the... (3 Replies)
Discussion started by: 2.5lt V8
3 Replies
3. Windows & DOS: Issues & Discussions
Hi!
I'm very sorry for such simple and silly question but I cannot answer it by myself.
Can you please help me?
In .bat file I should run the C program which is in other directory, and the input configuration file is in this directory too.
This dir name is in dirRun variable. The... (3 Replies)
Discussion started by: Anta
3 Replies
4. Shell Programming and Scripting
Hi all
Im calling a DB procedure as foll
sqlplus -s $DB_USERID/$DB_PASSWD@$DB_NAME<<eof
var var1 VARCHAR2(200);
exec ODAS_BATCH_JOBS_RETRIEVE.retrieve_user_info(:var1);
eof
echo $var1
This echo is giving a blank.
Also in case the package ODAS_BATCH_JOBS_RETRIEVE is in an un compiled... (2 Replies)
Discussion started by: Sam123
2 Replies
5. Windows & DOS: Issues & Discussions
I have a .bat file on windows, which converts a .xls file into .csv file and using a ksh script i would usually FTP this .csv file...
Now i want to trigger this .bat form my ksh script.
can i use rsh command in my FTP to run .bat file on windows and then ftp the generated .csv file...is... (19 Replies)
Discussion started by: bhagya2340
19 Replies
6. Shell Programming and Scripting
Hi guys,
I need a *.bat to run a ksh file in the shell on Windows NT...nothing more :) How do I do it? I tried with the following but it failed:
set INFORMIXDIR=D:\user-applications\informix
set PATH=%INFORMIXDIR%;%PATH%
D:\user-applications\MKS\mksnt\sh.exe C:\hk_9.2\C3_weekly_auto.ksh... (4 Replies)
Discussion started by: Dird
4 Replies
7. Shell Programming and Scripting
I have searched the forums and couldn't find my specific issue so I figure that I would post on it.
I am trying to run a simple sql script that spools to a flat file from a unix script.
I have tried to make the call outright from inside of the ksh script as such:
sqlplus... (3 Replies)
Discussion started by: BkontheShell718
3 Replies
8. Windows & DOS: Issues & Discussions
Hi ,
I have a bat file on windows machine ,I need to excute it from my local unix machine using sambe utility.Is there any comman to execute the .bat file remotely.
Using samba utility i can post files to and fro from windows to unix but i don't comman to exute the .bat file.
can any one... (2 Replies)
Discussion started by: Raamc
2 Replies
9. Shell Programming and Scripting
I need to put/get files from Windows machine to Unix machine and vice-versa.
I wrote a text file "ftp1.txt" as below.
naga
naga06
cd /root/Naga
prom off
get time.unl
bye
I wrote another bat file "ftp.bat" as below.
ftp -n -s:C:\Users\Naga\Desktop\ftp1.txt IP_ADDRESS
but... (2 Replies)
Discussion started by: Naga06
2 Replies
10. Shell Programming and Scripting
Hi,
I have:
# Initialize variables
#!/usr/bin/ksh
FILENM=$1
INDEX=0
# read filename
echo "You are working with the Config file: $FILENM"
while read line
do
echo $line
data=$line
((INDEX=INDEX+1))
done <"$FILENM" (3 Replies)
Discussion started by: Marc G
3 Replies
LEARN ABOUT SUSE
pod::perldoc::tortf
Pod::Perldoc::ToRtf(3pm) Perl Programmers Reference Guide Pod::Perldoc::ToRtf(3pm)
NAME
Pod::Perldoc::ToRtf - let Perldoc render Pod as RTF
SYNOPSIS
perldoc -o rtf Some::Modulename
DESCRIPTION
This is a "plug-in" class that allows Perldoc to use Pod::Simple::RTF as a formatter class.
This is actually a Pod::Simple::RTF subclass, and inherits all its options.
You have to have Pod::Simple::RTF installed (from the Pod::Simple dist), or this module won't work.
If Perldoc is running under MSWin and uses this class as a formatter, the output will be opened with write.exe or whatever program is
specified in the environment variable "RTFREADER". For example, to specify that RTF files should be opened the same as they are when you
double-click them, you would do "set RTFREADER=start.exe" in your autoexec.bat.
Handy tip: put "set PERLDOC=-ortf" in your autoexec.bat and that will set this class as the default formatter to run when you do "perldoc
whatever".
SEE ALSO
Pod::Simple::RTF, Pod::Simple, Pod::Perldoc
COPYRIGHT AND DISCLAIMERS
Copyright (c) 2002 Sean M. Burke. All rights reserved.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
This program is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of
merchantability or fitness for a particular purpose.
AUTHOR
Current maintainer: Adriano R. Ferreira <ferreira@cpan.org>
Past contributions from: Sean M. Burke <sburke@cpan.org>
perl v5.12.1 2010-04-26 Pod::Perldoc::ToRtf(3pm)