Hi,

I am a Service Manager for a controls company and have been creating an Engineers Report which provides some automated functions for the engineers. Largely it is now working but I have a problem that I cannot seem to resolve; I have tried many of the examples that I have found in the forum but have not been successful.

When the engineer has completed his report, he has two options - save a Customer copy or save an Office copy. When either button is selected, a listbox of all tabs that are appropriate for either the Office or the Customer is presented and the engineer can select which to save. The code will then create the new workbook to save and add the prefix 'Customer Copy' plus 'Site Name' plus 'Job Name' to the file and save it in a folder 'Reports' in the C: drive. This works but I also end up with another sheet 'Book1' which I cannot immediately close.

Code below is for the Customer copy.

Guidance on this will be greatly appreciated.

Cliff
Please Login or Register  to view this content.