How to create VBA that runs on excel file open ?

[mrchonginhk]

How to create VBA that runs on excel file open and after run closes the file itself (but not the Excel program and other Excel file that has been opened) ?
ie autoexec Macro.

Pls help to post code if possible, thanks

 

[prince141987]

Why dont you put your code on workbook open Event.

regards
Prince

 

[anil.ishaq]

Add this to the end of your code. The text highlighted in bold would need to be the file you wish to close at the end.

Windows("Your_File_Name.XLS").Activate
ActiveWorkbook.Close