>
>>I have a template for an Excel sheet.
>>>from within VFP9.1 I would like to add a new sheet and inherit the formatting of sheet1
>>>
>>>can that be done?
>>>
>>>Peter
>>
>>Re: Load Excel template Thread #1021794 Message #1021842
>>
>>BTW, you participated in Re: Using XLS template in VFP Thread #1017708 Message #1018073
>>
>I don't see how those messages answer my question. And what my participation has to do with it?
>
>
>I need to copy a sheet with formatting (column width, lines, ... basically the header/ title row)
>from sheet1 to a newly created sheet2
>Without having to do DOM manipulation over and over again...
>
>Peter
From VBA Help
Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet.
expression.Add(Before, After, Count, Type)
expression Required. An expression that returns one of the above objects.
Before Optional Variant. An object that specifies the sheet before which the new sheet is added.
After Optional Variant. An object that specifies the sheet after which the new sheet is added.
Count Optional Variant. The number of sheets to be added. The default value is one.
Type Optional Variant. Specifies the sheet type. Can be one of the following XlSheetType constants: xlWorksheet, xlChart, xlExcel4MacroSheet, or xlExcel4IntlMacroSheet. If you are inserting a sheet based on an existing template, specify the path to the template. The default value is xlWorksheet.
Though for me it is still not clear and I don't see how to do it interactively from Excel to record a macro.
BTW, missed your question about "message police" <s> I thought about writing deja-vu first, but then somehow changed it. Sorry if it sounded bad.
If it's not broken, fix it until it is.
My Blog