>hi,
>
>how to create a sheet in a workbook on excel with vfp, is there any ole command reference manual some where.
>
>Regards
For a quick start, take a look at this program:
oExcel = CreateObject("Excel.Application")
oExcel.Visible = 1
oExcel.Workbooks.Add()
oSheet = oExcel.ActiveSheet
oSheet.Cells(1,1).Value = "Hello!"For additional commands, save a macro and adapt the commands to VFP.
Some of these will create constants - search the download section for "constants".
HTH, 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)
