melphillips

Ok, is it possible to set a command button to throw up a save function and automatically create a file name? For instance if i am saving all of my files in a folder where the files start with the name "03-NC1000 ABCCO" and the next job is saved as "03-NC1001 CDECO". I would like to pull the 03 as the year, NC as the state generating the quote (NC,FL,TX, etc.) 1000,1001 (here is the sequential part) and ABCCO as the company name i am quoting. The estimator will enter the State and Company name. I would like for excel to calc the rest. I would like to have a command button to execute a save function and automatically save the file. I am sure that this is simpler than i think, but i am having a hard time figuring it out. If anyone is willing to help me, i would be most grateful. Thanks, Mel

Can someone please let me know the vb code to cause a command button to activatte...rather take you to a "named" location. I am working on a bidding file in excel. I am organizing about 25 different headings and breaking each heading into about 50-100 rows of defined space. On the main page, the user can click one of 25 command buttons to quickly take him to that defined space. Basically this is just for simple navigation to save time. Thanks in advance. Mel Phillips