Hello all,
I have an Excel Template that I am using to open, populate with data, print and close. I have a template, all the data goes to Excel, then the VBA code does some splits on strings and inserts the array results into individual cells. The code works perfectly, except it has to be run manually. I cannot get it to run automatically when a new workbook based on the template is created. Any ideas on where I need to insert the Aut
pen() function in a template to have it actually run automatically? Any help would be appreciated.
thanks
Leslie
I have an Excel Template that I am using to open, populate with data, print and close. I have a template, all the data goes to Excel, then the VBA code does some splits on strings and inserts the array results into individual cells. The code works perfectly, except it has to be run manually. I cannot get it to run automatically when a new workbook based on the template is created. Any ideas on where I need to insert the Aut
pen() function in a template to have it actually run automatically? Any help would be appreciated.thanks
Leslie