I simply want to run a .bat file in DOS when I open an Excel file.

My .bat file collects all the .txt file names in a specific directory and stores file names that start with "HC" in one .txt file and file names that start with "HR" in another:

   cd c:\My Files\Junk
   dir HC*.txt /b > Catfiles.txt
   dir HR*.txt /b > Retfiles.txt

Afterwards, my Excel macro reads each of these files (Catfiles.txt and Retfiles.txt), gets the file names, and opens them one at a time.

Currently, I run the .bat file before I open the Excel file. I WOULD LIKE to launch the .bat file when I open my Excel file with some sort of "On Open" command.

Thank you. Harold Hawken

Hi,

Use Shell "C:\My Files\Junk\MyBat.bat"

-vemaju

Implement this code in Workbook_Open. The /c closes the DOS prompt when finished.

Private Sub Workbook_Open()

Call Shell(Environ$("COMSPEC") & " /c C:\Path.bat", vbNormalFocus)

End Sub