save excel file in vb

[alifyag]

hello,
i open an excel worksheet though vb and make some changes in the excel file. the excel worksheet is in hidden mode.
i want to create a save as button on my vb form. when the user clicks on the save as button i want to enable the user to save that excel file in the location he desires. i also want that the original excel file should remain open in the background in hidden mode..
please help.
thanks
al

 

[tb]

Read up on the Excel object ... spesifically the Workbook methods

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!