Darren
darren at activebilling.com.au
Tue Nov 5 10:07:54 CST 2013
Hi Paul, Thanks for the prompt response. I'm having no issues with timing. I create the batch file then run it all via code. The issue is: Running it via code (VBA) the bits in the batch file that should output stuff to a log file via ">>" just don't work. Yet if I double click that 'very same batch' file from its folder, it runs and outputs to the log file. Same batch or CMD file. Double clicking works - file runs does what it's supposed to and outputs some stuff as required to a txt file.. Yet Calling it via code, allows the batch to run and do what it's supposed to do, but no outputs to the log file. Weird! Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland Sent: Wednesday, 6 November 2013 2:48 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003:BAT/CMD file not outputting to log file if run from VBA Darren, Seems to ring a bell from somewhere in my past experience, try searching on google for a function called ShellWait, I am sre this cured a similar problem for me a couple of years back. Paul On 5 November 2013 15:31, Darren <darren at activebilling.com.au> wrote: > Hi guys > > > > I have a CMD file that is run from VBA. > > Inside this CMD file are lines like: > > > > Echo blah blah blah >> LogFile.txt > > > > All good and pretty basic - If I double click the CMD or BAT file the > outputting to the log file via the '>>' works a treat. > > If I 'run' the CMD/BAT file from VBA then the file runs but the >> > bits seem to be ignored. > > As a result the log file isn't created and (of course) there are no > log entries. > > I have tried with CMD and with BAT files > > I have tried calling the BAT/CMD file a few ways from within VBA too. > All no joy. > > > > Dim strFileToRun As String > > strFileToRun = Me.txtDeployFileToBuildPath > > ''strFileToRun = "C:\Program Files\Microsoft SQL > Server\90\Tools\Binn\Run.bat" > > > > Dim retval > > 'retval = Shell(strFileToRun, vbNormal) > > > > Call fHandleFile(strFileToRun, -1) > > 'Call Shell(strFileToRun, 0) > > > > And so on > > > > Anyone come across this before? > > > > Many thanks in advance > > D > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Paul Hartland paul.hartland at googlemail.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com