>>How about Excel Automation? That will let you control a variable number of columns.
>
>Excel Automation might be the way to go. This could work well. I knew there had to be something better than rebuilding grids <g>.
>
>Rob
>
>>
>>Another option would be to generate a text-file, and display that to the users with the default text editor.
>>
>>HTH, Hilmar.
In that case, I recommend referencing cells by row and column number - names like "A1" are very difficult to manage. See the following example, if you are not familiar with automation. Also, for additional actions (bold, numeric format, etc.), save a macro in Excel, to look at the generated code.
Please note that Excel is limited to 256 columns.
oExcel = CreateObject("Excel.Application")
oExcel.Visible = 1
oExcel.Workbooks.Add()
oSheet = oExcel.ActiveSheet
oSheet.Cells(1,1).Value = "Hello!"
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)