create and run .bat file

richurules · November 8th, 2009, 02:11 PM

hi..

I need help with a macro in excel which should be able to create and execute a bat file when opened..

the file can just have for example a command to launch notepad or the time..

the objective is basically to check the scurity problems with excel, pdf.. etc..
if you guys have any other ideas in which we can execute code using popular softwares without being detected by anti virus.. chip in your ideas..

thanx a lot :)

Shasur · November 9th, 2009, 01:26 AM

Hi

You can create a simple batch file using Open, Print and Close Commands

Code:

Open "c:\temp.bat" for output as 1
 
Print #1, Echo Off
 
Close #1

will create a batch file

You can execute the batch file from Excel VBA using Shell command.

On the other hand, you can also open the Notepad through shell directly

Code:

Shell "NOTEPAD.exe",vbNormalFocus

To run the macro automatically use Excel's events like Workbook_Open etc

Cheers
Shasur