batch file

Hey all, It's not exactly related to VBA and excel, but I hope this has enough relation to it. I wrote a .bat file. The purpose of this .bat is to watch a folder for new files, and if so, call a VBA command. :loop dir /b "%folder%" > nul 2>&1 if errorLevel 1 ( timeout /t 30...

Hi brains trust I was wondering if someone could help me. I have a folder with over 30 batch files. I need to run them in order but with a 2 minute wait time between running the batch files. I understand I could do this: shell("CMD.EXE /c c:\abc.bat") This might make things tricky as I...

Hi Guys, Not sure if I can post any batch file related question in this forum. If this is not appropriate, please let me know. Thanks in advance. In any case, here is my quest looking for resolution if possible. I use this code to delete files and folders but I want to know how many files and...

Hi Guys and Gals I have a problem that is out of my expertise I have some VBA working fine doing what it needs however the end goal is to copy a file form a network drive to a local drive, however, the local machine i need this on does have excel installed to fire the VBA form task scheduler...

My Excel Data has two coloms 1st Column is Bank A/c No & 2nd Column is Amount Excel Data Bank No Amount 17755 65000 17692 25000 17456 1500 25005 500 27201 10 26845 2 Required text File Data 0250010000.17755.00065000.00...

Hi I have problem in running ".bat" files through VBA, but when I run ".bat" file it executing properly. but not through VBA. Below is the code I'm using Sub RunBatFile() Dim txtFpath, FilePath As String txtFpath = wksCmdJen.Range("C12").Value ' given path is C:\Elements FilePath...