Programming with events
I'm not sure how you're importing your data, but couldn't you just copy Sheet1,
clean up what you want and then import your data into that copied sheet (or
paste your data into that sheet).
It might be best to turn off events first, then do the pasting, then re-enable
the events.
Newsgroup wrote:
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.
--
Dave Peterson
|