Model regeneration by using macros

Dear All,

Currently i am working on parametric modelling by using excel. But every time i had regenerate the model & update the analysis in model file wheneve i change the value in excel file.I want model updation automatically wuthout open model & regenerate model.I want to know about programming by using visual basic & use of macros in excel.

so plz you have answer then reply me asap.