Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
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.vbsCode:
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 False
xlApp.Quit
'always deallocate after use...
set xlSht = Nothing
Set xlBook = Nothing
Set xlApp = NothingPlease enlight be how to slove this issueThanking You
Bhagya
![]() |
![]() |
![]() |
| Login or Register to Reply | |
| Login | Register |
| Ads by Google |