antonc
10-24-2008, 03:46 AM
:banghead:
Hi Guys,
I have done a search, but can't seem to find anything that helps me.
I've attached a file for ease of explanation.
I'm trying to compile a forecast budget master file for my branches.
I'm have a bit of trouble trying to get the file to save as another filename based on the branch that a user selects.
The idea is that when any user opens the master file (I have made this a readonly file), a userform will force them to select a branch that they will work on (along with other options). When the OK button is pressed, I want to automatically save the file as another filename, based on the branch that they select. I want to save this file based on a naming convention that we have at this company.
The code for the ok button is :
ActiveWorkbook.SaveAs FileName:=Range("S2").Value
This doesn't seem to have any effect on the filename.
Is it because S2 refers to a formula?
Please help.
Thanks in advance for you time and effort and any help will be greatly appreciated.
Hi Guys,
I have done a search, but can't seem to find anything that helps me.
I've attached a file for ease of explanation.
I'm trying to compile a forecast budget master file for my branches.
I'm have a bit of trouble trying to get the file to save as another filename based on the branch that a user selects.
The idea is that when any user opens the master file (I have made this a readonly file), a userform will force them to select a branch that they will work on (along with other options). When the OK button is pressed, I want to automatically save the file as another filename, based on the branch that they select. I want to save this file based on a naming convention that we have at this company.
The code for the ok button is :
ActiveWorkbook.SaveAs FileName:=Range("S2").Value
This doesn't seem to have any effect on the filename.
Is it because S2 refers to a formula?
Please help.
Thanks in advance for you time and effort and any help will be greatly appreciated.