Good day all,
I have tried several ways to do this and can not find a way to make it
happen with out creating a template and copying data from a worksheet into
the template.
I have a workbook that has 3 different events programmed into it. I am using
the ThisWorkbook and Sheet1 excel objects. We are currently using a table
exported from VFP into an excel sheet, and I would like each time this sheet
is generated to have the events I have programmed to be "automatically"
imported. I know I can open the Workbook and copy and paste the events into
it, but I want it to happen automatically so our marketing department can
use it. So my question is how do I take a NEW worksheet and add my events to
it...I've tried to create an Addin and that doesnt work, the only way I have
found this to work is by creating template with the events programmed into
it, and copy the data from the exported worksheet into the template, and
then re-save the template worksheet to the exported worksheet name.