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

Jim Lawrence accessd at shaw.ca
Tue Nov 5 18:28:01 CST 2013


:-)

Jim

----- Original Message -----
From: "Darren" <darren at activebilling.com.au>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Tuesday, November 5, 2013 2:33:10 PM
Subject: Re: [AccessD] A2003:BAT/CMD file not outputting to log file if	run	from VBA

Thank you Heenan, Jim and Stuart.

Stuart gets a beer. Sheesh what a PITA.
It was writing the text file to the 'MyDocs' folder.
How frustrating.
All good and all resolved now.
Many thanks to you all. I had wasted too many hours on this.

Stuart, thanks...again - When you're in  Sydney, gimme a yell, it's my
shout.

D


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Wednesday, 6 November 2013 8:41 AM
To: Access Developers discussion and problem solving
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

-- 
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