i need a button that will save the excel file when clicked. i dont want the
"save as" to pop up seeing that this file name will never change. just needs
to save as if i was to click the save button in the toolbar. thankyou

hi
i'm assuming that you are trying to save a newly created file.
by default, all first saves are save as. no way around this.
i was told that it a safty factor so that newly created files are saves to
where the user wants them as apposed to saving the file somewhere and
possibly being lost.

regards
FSt1

"YMC" wrote:

i need a button that will save the excel file when clicked. i dont want the
"save as" to pop up seeing that this file name will never change. just needs
to save as if i was to click the save button in the toolbar. thankyou