how to save excel file using a vb add in for excel

[anandanatarajan]

Dear sir/Madam

i have created a vb addin for excel which is shown in the excel when it is opened. the addin is a button. when it is clicked a vb form will be opened and it has a button called save.
my question is
is ther any possible way that when i clicked the save button the current opened work should be saved in a path specified in the form. instead of using the conventional save of file menu.

your help will literate me on new venture

thanks and regards
s.anandanatarajan