Visual Basic :: Working With Batch Files And BCP

Working With Batch Files
--------------------------------------------------------------------------------

Here is what I am trying to achieve, I have small program in VB which is called File Search. The object of this program is to look for a file and if its there delete it and than do some other work. The problem is that the file lies on an FTP site which makes it harder because I have to figure out a way to work with batch file, that will login to the FTP site delete the file and than logout. Below is the code that I am trying to write, some of the it is in psedocode, can anyone help me with this.

Code:

While x <> ""

x = UCase(x)

fFormat = ""
If InStr(x, "ARC0479.SCTOPN'") <> 0 Then
If InStr(x, "ARC0486. SOARCNTL'") Then
delete(controlfile)
fFormat = "ARCS001"
outFileName = TargetDir & "ARC_DISP.txt"
End If

Working With Batch Files
I am currently writing a program which needs to use existing batch files. The problem is that each bat file needs to be run at a different stage in the program but I need them to all run in the same window due to variables that are set.

How can I get each batch file to run in the same process window?

Any help appreciated

Update Batch Not Working
Hello All!

I have a recordset called "rsOrigRS" and populate it with data from another recordset "rs" in the Form_Load Event handler, so that if a user clicks the "Reset" button, OR they decide not to save their changes, then I can restore the data to it's original state.

I open the "rsOrigRS" recordset like this:

CODE    sql = "select r.fname, r.lname, g.* from (Grid g INNER JOIN "
    sql = sql & "registration re on re.eventid = g.eventid and re.classid"
    sql = sql & "= g.classid and re.comp = g.comp) INNER JOIN racer r on"
    sql = sql & " r.racerid = re.racerid where g.eventid = -1"
    Set rsOrigRS = New ADODB.Recordset
    rsOrigRS.CursorLocation = adUseClient
    rsOrigRS.Open sql, cn, adOpenKeyset, adLockBatchOptimistic
    rsOrigRS.ActiveConnection = Nothing ' disconnect
    rs.MoveFirst ' rs has the appropriate data in it.
    Do While Not rs.EOF
        rsOrigRS.AddNew
        rsOrigRS!EventID = entId
        rsOrigRS!GridType = GridType
        rsOrigRS!GridNum = Trim(rs!GridNum & " ")
        rsOrigRS!classid = classid
        rsOrigRS!cyear = entYear
        rsOrigRS!fname = Trim(rs!fname & " ")
        rsOrigRS!lname = Trim(rs!lname & " ")
        rsOrigRS!runclassid = Trim(rs!runclassid & " ")
        rsOrigRS!comp = Trim(rs!comp & " ")
        rsOrigRS!pos = Trim(rs!pos & " ")
        rsOrigRS!advflg = Trim(rs!advflg & " ")
        rsOrigRS.Update
        rs.MoveNext
    Loop

How To Run Batch Files,exe Files Using OLE-Urgent
hi,

how to execute batch files and exe files using OLE in vb 6.0. it is very helpful to me.
not using shell command.

thank u.

Wave Files And Vista. Some Working And Some Not Working. Strange.
Hello everybody,

I have an application with embedded in the ressource file wave files. I use PlaySound to play them. This works perfectly up to Windows Xp.

Recently I have a friend testing the application on Vista. Certain files are not playing, and others are.

Any ideas why some would play and some wouldn't? It seems very strange.

Here is the code. It works for some wave files and not others

VB Code:
Call PlaySound("MY_EMBEDDED_WAVE_FILE", App.hInstance, SND_RESOURCE Or SND_NOWAIT Or SND_NODEFAULT Or SND_ASYNC)

Batch Files
I wasn't sure where to ask this question, but I'm trying to copy a folder to a new directory using a .bat file I'd like to create. I'm trying to use something like this:

Code:
xcopy C:DavesSounds *C:DavesSounds2* /a /e /k
but it doesn't do anything. I've looked at Microsofts help on this, and it gives this example:

Code:
xcopy h:*.* /a /e /k

The above command would copy everything located on the H drive to the drive you are currently on.
So "my" logic would make me believe the my above line would work....but it doesn't. Does anyone out there know how to create a .bat file that will copy a folder to a different directory?

Sorry this has nothing to do with Excel...but I'm at a loss....

Dave :-(

Batch Files
i post this once before but i lost the code
how would i Write a batch file

Batch Files And VB
I created a batch file to automatically run in my vb program. It will ftp files to other ip addresses. How can I (in my vb program) get back a result to let me know if it was successful?

Batch Files Or A VB Exe???
Hello,

I have a freebie tool that creates autoplay menus for CD's. My problem is that when I click on the button to run a program...I want it to run it from a folder rather than from the root of the CD. Is there a way to run a batch, script, or small vb app that will will start a program from another folder on a CD?

In summary, I just want a file that when run..will call another file or program.

Thanks!

Batch Files
Hello,
Not directly related to VB but ,
I am using the following line in DOS on NT4
copy c:files*.* k:Reports2002

where K is a shared network drive.

This works fine , but when I place it in a batch file , it gives me an error , 'System cant find specified file'

The contents of the batch file are just the above line.

Any ideas , please send them on.
Thanks
Dave

Batch Files!!!!
=( dont flame me for this question, i have looked through the forum for something similar to my topic......no luck
im a bit new to vb.. only been using it for about 2 months or so
i used to use pascal - delphi borland and the interface allowed for quick batch files
BUT in vb i have no clue how to make a batch files ='( any help??

Batch Files!
Can anyone help?

I want to write a Batch File to allow me to
register a group of DLL's to a System directory
of a clients computer.

And can a command line entry be used with a Batch File?

Thanks for any help.

Do U No Your Batch Files
i created a batch file, and my first command is
cd
c:
file2cd c: ester
cdtools /eject
so when the cd execute, it goes automatically to the next line, but after the file2cd command, i nne another ENTER before going to the cdtools command, is there a way to tell him to do a enter with a command.
thanxs

Help With Batch Files
I'm Running a DOS Appl and i am redirecting the output to a file.

RetVal= Shell(BatFile, vbHide) ' run the bat

1) How do i close Dos appl??
2) How colud i know if my bat file is finished executing ?? (i want to read the output).

Regards

Batch Files
When using the P&D wizard, one finishes normally with 3 files something like
:

- programfiles.cab
- setup.exe
- setup.lst

which are in some folder e.g. "c:mysetupfolder"

On many forums one sees that these files are often zipped all three together
into one single zip file. However, for installing on another computer, one
needs first to unzip and then running the exe file.

How to make a batchfile i.e. ONE file with a *.exe suffix which does the
same but not within two steps (as above) but in one single step only, i.e.
what normally happens when downloading from a website ?

any help appreciated
willibrord oomen

VB.Net And DOS Batch Files
Quick question on something I'm playing with, does anyone know a way to store a DOS batch file in a vb.net application so that I can edit batch file as needed and still have it running from within my application? Any pointers in the right direction will be appreciated. Thanks in advance guys and gals.

Dos Batch Files
I have some really old games which run in Dos, which have to be started from
a batch file. I am using VB5 and would like to create a program which will
run a batch file with a click of a button. How do I run .bat's from VB?

Graham

Batch Files
I have a visual basic program and I use a batch file to run it. So when I double click the batch file the program runs. Here is the code that is inside the batch file.

md C:Apps
copy L:SWAIIAppsSDBRelease*.* C:Apps
C:
cd Apps
start prjAssemblyPU.exe

What this code does is it first creates a folder called ‘Apps’ on the C: drive. Then it copies all the files on a network drive folder to the C:Apps folder. Then it opens the application prjAssemblyPU.exe.

Does anybody know how to do this in Visual Basic? For example when I click a button on a form it should run the commands

VB & MS DOS Batch Files
I have a batch which when I run a have to pass a number of parameters to it. For example - test.bat x86 server local
I wan to create a simple vb dialogue which will pass these parameters to the batch file and the run the batch file.
How can I do this?

Help With Batch Files!!!!
Hi all,

Recently i have been making a program to send over a network.

It worked but the way you sent the messages was by going into the batch file and editing the message and person to send to.

Then tou would go into vb and start the batch file and etc...

What i have done is add two more text boxes on my form(one for network user name or computer name and one for the actual message.

Is there anyway that by the click of a button the program will take the username and message and replace them with the ones already in the batch file(From previous messages)????

BTW the batch file looks like this:net send (USERNAME) (MESSAGE)
that is all that is in it!

Thanks very much in advance,

Hayden COpe.

PS: I have recieved one reply so far but was not good because all it did was read the values in the batch file and parse them into the text boxes. What i want to do is the oppisite.

Thanx alot all.

Batch Files
How do i create a opening files dialog when i open a DOS batch files?

Running Batch Files From VBA
Hi. I'd like to run a batch file from VBA (within Access). I've been trying to do it using the Shell command, however no matter which 'windowstyle' I use, the window pops up then goes away again. The batch file I'm running should take a matter of minutes to run, but it looks like VB is killing the window as soon as it starts.

Am I doing it incorrectly, or is there a better way to run a batch file / wait until the batch file has finished?

Thanks,

Flex

Invoking The Batch Files
I want to run few batch files (like file1.bat, file2.bat etc) from my vb program. How can I do it?

VB Variables And Batch Files
Hi everyone,

I have been programming using VBA for a little under a year now, but this is the first time I've tried to make an executable. My problem is that I am writing a batch file where I need to use yesterday's date.

My question is, since you cannot access the system date with the batch language, can you write a small vb executable file and have that find the value of yesterday's date with date-1 and assign a variable in the batch file to the value found using vb by calling the vb file from the batch?

Thanks for your help,
berry

How To Know Status Of Batch Files?
Hello,
I have a section of vb6 code that runs four batch files if the user makes a certain selection in an option group. The application needs to keep the user informed of the progress of the batch files, and not allow for user interaction while the batch files are running.

So far, the code that I have to execute the batch files looks like this;

******************************************
Dim bTrainingValue As Boolean
Dim iTrainingOptions As Integer
Dim iFirstResponse As Boolean

If optTraining.Item(2) = True And bTrainingValue = True Then
iFirstResponse = MsgBox("This will put the training environment in the original state." & vbCrLf & vbCrLf & "You will lose changes made in previous training sessions.", vbOKCancel, "Training Reset")
If iFirstResponse = 1 Then
msShellCreate = "C:Documents and SettingsAll UsersApplication DataAIG Datascriptssbnad201cpSBNAD201in.bat"
Shell msShellCreate, vbNormalFocus
msShellCreate = ""
End If

If iFirstResponse = 1 Then
msShellCreate = "C:Documents and SettingsAll UsersApplication DataAIG Datascriptssinsd201cpSINSD201in.bat"
Shell msShellCreate, vbNormalFocus
msShellCreate = ""
End If

If iFirstResponse = 1 Then
msShellCreate = "C:Documents and SettingsAll UsersApplication DataAIG Datascriptssnbad201cpSNBAD201in.bat"
Shell msShellCreate, vbNormalFocus
msShellCreate = ""
End If

If iFirstResponse = 1 Then
msShellCreate = "C:Documents and SettingsAll UsersApplication DataAIG Datascriptssposd201cpSPOSD201in.bat"
Shell msShellCreate, vbNormalFocus
msShellCreate = ""
End If
End If

**********************************

All this code does is execute the four batch files without giving the user any indication of the progress of the batch files.

Are any of you aware of resources that I could look at that would assist me in my efforts to 'track' the status of the batch files, and inform the user?

Thank you for your help!

CSDunn

Appending To Batch Files
I have a batch file which i wanting to append variables to.

For example, one of the entries in the batch file says :

version=

I want to be able to use a value which i have in the database form and edit the version that i can see into the batch file.

Please help !

Executing DOS Batch Files In VB .. ??
How I can execute a DOS Batch file in VB..???

I have a set of DOS Commands like Del, Move, rm etc..which I wish to put in a batch file and run using VB..

Can someone tell me how I can go about doing this??

Batch Files - No Answer Yet :(
Yes, I know it's not a VB question, but it doesn't fit in any of the other categories either...

I've just had Windows 2000 installed, and I've found that on certain files types - .bat files for example - I don't have a menu option of "Open With..." when I right-click (or shift+right-click) on them in Windows Explorer.

This is presumably a setting somewhere, but does anyone know where?

Thanks...

Shelling Batch Files
Ok, when you shell a batch file it executes, but a window remains after it is terminated. You could shell it a million times and end up with a million windows. But what if a used:

Code:
Shell "C:mybatch.bat", vbHide

Would this actually purge the window from memory or would it simply result in a hidden window that you would have no hope of closing?

How Do Batch Files Really Work
Really.. How do they work.. ?
as well can someone shed some light on the other obscure file extensions... ini .. etc..
Seahag

Though Problem With Batch Files :(
Hello everybody,

I just wrote a small program which writes a few lines to a batch file (these lines contain directories). These lines can contain é. When I execute the batch file, the é gets converted to ü . So when this happens, the directories can't be found

So I've been experimenting with opentextfile function to open the file as unicode. So everything's all right. When I do type test.bat, then I see my é correctly !

But when I run that batch file, I get all weird signs.
I've been trying to execute the batch files with cmd /u /c "c:/Test.bat" but this doesn't help.

Can anyone help me please ! Cause I'm talking here about a few thousands unexecutable lines

Thanks in advance !

Bjorn

Wating In Batch Files
I have a bat file that kicks off a series of programs. However, I need it to wait until one program finishes before going on to the second call.

The reason I'm using bat files, is I am installing my application (to get the vb runtime etc) and then I want to run it, but I don't want any user interfaces during the install. I'm using Install Shield Express 2.1. I don't recall seeing anything in there that will do it without asking the user first.

Anyone have any ideas?

Thanks,

John

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org

Running Multiple Batch Files With Vb
I am working on a simple VB program that will run 18 different batch files with a single click of a button. It is working OK, but they are running/launching at the same time. I would like to know if there is way to run the batches, say the first one, have the system/computer finish executing a batch file before moving to the next one. Also, at the end of running the batch files, I would like to display a message box with a list of the files that were run. I would appreciate any help!!

Running Batch Files From Vb Program
I want to pass few parameters and run batch files from my vb front end. How can this be done? Any examples will be of good help.

Shell And Wait With Batch Files
I have a couple of questions regarding the shell and wait (if I've read it correctly from old threads)

I want my program to read a series of assigned drives from an INI file, map a drive, do the downloading and unzipping to the assigned drives, then unmap the drive.

Some strange things are happening on my shell and wait command lines however.

1. If the drive is UNMAPPED at the time I run the program the batch file runs but appears to bomb out after the first command and not run the second command because I get ane error (20608 Could not open file) and the z: drive is never mapped.

If the drive is MAPPED at the time I run the program the batch file runs without error and the drive gets mapped correctly.

Question here is why does it seem to only shell and wait if there are no 'error' lines in the batch file? is there a way to prevent this? I want the program to unmap any drive that is currently on the assigned drive and remap it to the 'download' drive.

2. When it does map the drive correctly (i.e. the drive is currently mapped so it unmaps then remaps the drive correctly) and the program reaches the shell and wait unzip.bat it never unzips correctly, it opens for a split second then goes on to the drive disconnect batch file. I have no idea why this is happening.

ALL THREE batch files run correctly if I run them on my own outside the FTP download process.

Can anyone offer insight into why a these batch files seem to be outside the realm of the shell and wait (as I've used it here) or have I got some other error I'm unaware of in my syntax.
------------------------------

sunmapbatch = App.Path & "unmapdrive.bat"
smapbatch = App.Path & "mapdrive.bat"
sUnzipBat = App.Path & "unzip.bat"

dMapDrive = Shell("command.com /c > " & sMapBatch, 6)

.
.
bunch of code that downloads files from various directories
in the process creates the unzip.bat file with the lines listed
below.
.
.

dUnzip = Shell("command.com /c > " & sUnzipBat, 6)
dUnmapDrive = Shell(sunmapbatch)

************************
CONTENTS OF sUnzipBat

gzip -cd z: ester
azipped estfile1.gz > z: ester
a estfile12002.329
gzip -cd z: ester
azipped estfile2.336.gz > z: ester
a estfile22002.336

************************
CONTENTS OF sMapBat

net use z: /delete /yes
net use z: \ppserveg-drive

************************
CONTENTS OF sUnmapBat

net use z: /delete /yes

thanks in advance
rp

Problems With Calling Batch Files
Hey,

I have written this program and I need a directory listing of a specified directory. I am calling a batch file, which works fine with other batch commands. But for this one it doesn't. Here is my vb code:
Call Shell("c:init.bat", vbNormalFocus)

in the init.bat this is the code:
dir /x /b d: >list.txt

If I run the vb program it executes the batch file but nothing is posted to the list.txt file, but if i run the init.bat file from outside of the program the list.txt file has the apporpriate posting in it.

I know this is probably n00bish stuff so help me out if you don't mind.

-Toad

MSDOS Batch Files - WinXP
I know this aint vb but im creating a batch file, to install my app but i was wondering if there was a way to copy multiple files with one command? because rather than get an output of:

1 file(s) copied.
1 file(s) copied.
1 file(s) copied.

it gets nasty when you have alot of files, i would prefer:

3 file(s) copied.

here is the method im using.

copy Dataapp.exe C:myapp
copy Dataconfig.ini C:myapp
copy Datalibrary.dll C:windowssystem32

Cheers.

Calling Batch Files From Shell
Little help needed.

I have a batch file that runs from a command line, but when called from VB it will not produce the same results. It runs, produces no errors, but will not produce what the batch file will when ran from a command line.

Thanks

Batch And Script Files Failing
Hi Guys,

This is a bit of an off subject,but all of a sudden my batch files and vbs files are failing to work and i thought maybe someone could help me out.
With the vbs file i get an alarm saying :

The procedure entry point DoOpenPipeStream could not be located in the dll ScrRun.dll.

The Batch file alarm is saying:

There is no script engine for ".bat" files.

I know this is an OS problem but i thought someone could have seen this before as WWW.MS.COM has no reference to this error.

cheers.

Environment Variables && Batch Files
I have an VB application that is hard-coded to install in the C:Program Files[application name] folder. I would like to be able to install it anywhere on a computer. I think I would like to create a batch file to grab the folder location during the install and put it in an Environment Variable. Then use the Environment Variable in the VB code. How do I go about doing this. Or is there an easier way to do this?

Thanks in advance

Running Multiple Batch Files With Vb6
I am working on a simple VB program that will run 18 different batch files with a single click of a button. It is working OK, but they are running/launching at the same time. I would like to know if there is way to run the batches, say the first one, have the system/computer finish executing a batch file before moving to the next one. Also, at the end of running the batch files, I would like to display a message box with a list of the files that were run. I would appreciate any help!!

Running Batch Files Inside A VB App
I am trying to automate my morning routine. While most of what I need to get done can be done through my VB app, the first part of my morning runs a MS_DOS batch file which in turn launches a script that downloads my data. I do this manually and when it is finished, I then launch my VB app to finish up. Is there a way I can have my VB App launch the batch file? Back in the old days, we would use the shell command which is still in the VB language but I need to make sure that the entire batch completes before my program continues on. Any help on this would be greatly appreciated...

Batch Files And The Black Screen
Is there a way to run a batch file without the editing window appear?
Seahag

Creating Batch Files --> Runtime
Can I creat a batch file at runtime through code?

Seahag

Batch Files And Special Characters
Hello everybody,

we're currently rearranging our servers to new structures.
I've been logging almost all the files on the server.

Now I'm writing to batch files from VB with open, print 'n close file.
Everything works fine except for the special characters like é, °, ...

I really don't know how I need to work around this cause I have a few thousand of these characters in my pathnames

I hope someone could point me ? Cause I've been playing around with the opentextfile action to open my file as unicode. This works fine when I use type c:filename.bat, then my output is correct, but when I run that batch file, the output gives only garbage .

I'm really stuck with this problem !

Can anyone help me ?

Thanks a lot !

Bjorn

Executing Batch Files Sequentially
This is my first time posting to this list. It's been a while since I've played around with VB, but now I need some help. Here we go...

I need an application to:

modify a batch file
execute that batch file
wait till that's done
modify a second batch file
execute that second batch file
wait till that's done

here's what I've got so far...

Const strFile1 As String = "C:atch1.bat"
Const strFile2 As String = "C:atch2.bat"

Private Sub cmdRun_Click()
Dim strAppID1 As String
Dim strAppID2 As String

(Modify 1st batch file)
strAppID1 = Shell(strFile1)
DoEvents
MsgBox ("File One Executed!")
(Modify 2nd batch file)
strAppID2 = Shell(strFile2)
DoEvents
MsgBox ("File Two Executed!")
End Sub

However, I'm having problems with the DoEvents (i believe) for I'll get the message box before the batch file is done. I am doing this correctly? I must add that I am running on Win2K

Thank you

What Is The Fastest Way To Move A Batch Of Files?
What is the fastest way to move a batch of files, not one at a time.

Running Multiple Batch Files With VB
I am working on a simple VB program that will run 18 different batch files with a single click of a button. It is working OK, but they are running/launching at the same time. I would like to know if there is way to run the batches, say the first one, have the system/computer finish executing a batch file before moving to the next one. Also, at the end of running the batch files, I would like to display a message box with a list of the files that were run. I would appreciate any help!!