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