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

Stuart McLachlan stuart at lexacorp.com.pg
Tue Nov 5 15:41:09 CST 2013


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
> 




More information about the AccessD mailing list