activeX, Submit Button

[Ryan Leithall]

Not sure if I’m in the right place to ask this but got a project at work, I’ll try to describe it best I can but hope someone is able to nudge me in the right direction.

Basically I have a work plan that will have fields to be filled in by engineers as they work, once completed there will be a submit button to send the data to an new excel file for future tracibiltiy. I have found the button and have figured I will need to use activeX to code this.

I need it to duplicate a template file, rename it and store the inputs in it each time it has been submitted.

[#2]

Can't you just save an empty version of your file as a template (File, Save as, use drop-down to select the appropriate template)?
Tip: watch carefully as you select the template file type as Excel will change the location for you and it can be quite hard to find that location later on! You may want to select a different location than Excel suggests, like a file share or Onedrive.

[#3]

one thing I learned is to make your File Attribute = Read-only,

this will prevent the overwriting of the templates.

HTH