[AccessD] A2003:BAT/CMD file not outputting to log file if run from VBA

Would that suggest that a line like:

blah blah blah >> <absolute pathname>\LogFile.txt

Jim

----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Tuesday, November 5, 2013 1:41:09 PM
Subject: Re: [AccessD] A2003:BAT/CMD file not outputting to log file if run	from VBA

Bet you a beer that it's a "current directory" problem. :)

Either, your batch file is running in a directory that won't let you append to a file or your 
Logfile.txt is being written to but it is not where you think it is.



-- 
Stuart

On 6 Nov 2013 at 2:31, Darren 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
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com