Hope the below detail helps:
gcTemplate = name of the template file already created for specific reports
gcSaveAs = name in which the generated report should be saved
gcSourcePath = path in which the template file is placed
gcDestPath = path where the generated report should be placed...
Here is the part of the code which generates the Excel:
=STATMSG("Creating the report...")
lnFirstRow=6
lnCurRow=lnFirstRow
oExcel=ExcelInit(gcTemplate,gcSaveAs,gcSourcePath,gcDestPath,"infocentral050.jpg",CompanyName)
oExcel.Sheets("Layout").Name="Template"
SELECT DISTINCT...
I'm getting below error while trying to generate a Excel report through Fox pro. I get below error at times while doing so.
Error executing program: Error 1429, Line 4 -- OLE IDispatch exception code 0 from Microsoft Office Excel: A workbook must contain at least one visible worksheet. To hide...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.