There are the two exisiting MS Excel files. One is a master file which needs some modification. The way the program should work is the user opens the master file, the program asks for the master password. Once the user has entered the password, the program asks you to save the master file to a new file and location of the user's choice, so as not to overwrite the master file.
Once the file is saved a new menu comes in excel called 'estimate' with various functions within that menu.
The modifications we need are:
1. It seems that once the master file is saved as a new file, then closed and re-opened, the new file still asks you to save it again as another file, acting like the master file. We need this to work properly.
[login to view URL] the master file password
[login to view URL] we go to 'Insert a new page' via the 'estimate' menu it inserts a company header . We need to take out that header or be able to change the information in that header so when that task is executed it puts in the right information.
Should be quick and easy stuff for someone who knows vbscript. Files are attached