Search results for query: *

I am creating different worksheets for each Contact. On each contact (or worksheet) I have labels like Name, Address and so on. I can have the worksheets created on the fly, but can not copy the Name, Address on the other worksheets. Please, add any code. Thanks! <% 'Variables varName =...

Eventhough, I may be using asp/vbscript, I am using the same VBA Coding Techniques to create the Excel Application Object, the Workbooks + Worksheets. I need the vba resources, that is why I am in this forum. I need to create multiple worksheets with a template background (xlt file). How do I...

Skip, Great! I am creating 1 workbook with multiple worksheets. Multiple worksheets are created dynamically depending on the end user's selection. In summary, 1 excel application, 1 workbook and x number of worksheets based on x number of selected items from the end user. Also, I am...

Hi SkipVought, Thanks for the quick response. Yes, all worksheets in Template1.xlt are the same. How do I assign the object to one of the Template1.xlt sheets to propagate sheets? Please, provide code. If you need more code/info, please let me know. Thanks, Picu

'Create the Excel Object Set xlApp = Server.CreateObject(&quot;Excel.Application&quot;) 'Getting the Template from server Set xlWb = xlApp.Workbooks.Add (Server.MapPath (&quot;/folderPath/Template1.xlt&quot;)) 'Create new worksheets but after 3 I need other 'worksheets with the template from...