Home > WinDev Forum > Topic

TableToExcel solution with WD12 using Office2007

PROCEDURE MyTableToExcel(pFileName, pWindow, pTable)
TableToClipboard({pWindow+"."+pTable,indControl},taColumnsTitles)
x = new object OLE "Excel.Application"
x>>Workbooks>>Add(True)
x>>Range("A1")>>Select
x>>ActiveSheet>>Paste
x>>ActiveWorkbook>>SaveAs(pFileName, 51)  //xlWorkbookDefault
x>>Application>>Quit()

Author:

Your Email:


Subject:

Spam prevention:

Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.

Enter code:

Message: