Formatting in reports

Hi Dave

Thank you for your question

It is possible to write a procedure that would;
1. Create a new workbook
2. Place entries and value directly into certain cells
3. Format various cells as required.

as an example, the following code snippet shows you how to create a workbook ad some values and do some basic formatting

Application.Workbooks.Add

    

    ActiveWorkbook.Sheets(1).Range("A1").Value = "My New Template"

    

    ActiveWorkbook.Sheets(1).Range("A1").Interior.Color = vbRed

    

    ActiveWindow.DisplayGridlines = False

    

    ActiveWorkbook.Sheets(1).Columns("A").EntireColumn.AutoFit