FiveTech Software tech support forums

When I click on cell from the worksheet named "MASTER" that has a hyperlink to another cell in "DETAILS" worksheet I found the cell in the bottom of the video. This almost always happens. Is it possible to scroll the ...

Very interesting and fascinating. If you ask "... And fivewin" then the answer is very different: To convert an Excel worksheet containing addresses with columns for Street, City, State, and Zip to a SQL table using Harbour and FiveWin, you can follow these steps: 1. Load the ...

... occurred at: 01/08/2023, 00:47:35 Error description: (DOS Error -2147352567) WINOLE/1007 Impossibile trovare la proprietà Paste per la classe Worksheet. (0x800A03EC): Microsoft Excel Stack Calls =========== Called from: => TOLEAUTO:PASTE( 0 ) Called from: prog\xBrowse.prg => TXBROWSE:TOEXCEL( ...

Code: Select all  Expand view

oRange:Parent:Parent:Close( .f. )

oRange:Parent --> oSheet
oRange:Worksheet --> oSheet
oSheet:Parent --> oWorkBook

the *.XLSx was about 17000 x 11 My sample with 100,000 rows and 21 columns ( A to U ) is working. I opened the Worksheet in excel and then executed this one line code:   XBROWSER GetExcelRange() FASTEDIT  https://imagizer.imageshack.com/v2/xq70/922/lj3Msn.png

Hello,

I'm very sorry but I might have asked this question before. Unfortunately I can't find it anymore.

But can someone tell me how to add or delete lines in an Excel worksheet?

Thank you very much in advance for any help.

... a.) Dbf2HTML( cPath + cFile, cAlias ) b-) oBrwDBF:ToExcel() Error description: (DOS Error -2147352567) WINOLE/1007 Die Paste-Eigenschaft des Worksheet-Objektes kann nicht zugeordnet werden. (0x800A03EC): Microsoft Office Excel Stack Calls =========== Called from: => TOLEAUTO:PASTE( 0 ) ...

... Microsoft Excel TXBROWSE:TOEXCEL( 9335 ) Con Office 2019 me sale el siguiente error: No se puede obtener la propiedad Paste de la clase Worksheet. (0x800A03EC): Microsoft Excel TXBROWSE:TOEXCEL( 9241 ) Gracias por la ayuda

... Microsoft Excel TXBROWSE:TOEXCEL( 9335 ) Con Office 2019 me sale el siguiente error: No se puede obtener la propiedad Paste de la clase Worksheet. (0x800A03EC): Microsoft Excel TXBROWSE:TOEXCEL( 9241 ) Gracias por la ayuda

... FW_ExcelToDBF() --> lSuccess Writes the contents of excel range to default alias. Parameters: 1. [oRange] Defaults to used range in active worksheet if already open by the user. 2. [cFieldList] a) NIL: ( i) If range has headers in first row: Copies contents of each column to the field whose ...

... FW_ExcelToDBF() --> lSuccess Writes the contents of excel range to default alias. Parameters: 1. [oRange] Defaults to used range in active worksheet if already open by the user. 2. [cFieldList] a) NIL: ( i) If range has headers in first row: Copies contents of each column to the field whose ...

Hi, I want to open 2 excel-files, and want to copy a complete worksheet to the other excel-file. How can I do this? One excel is object oExcel, the other oExcelInput with this code I can copy it       oExcelInput:Sheets(oExcelInput:Worksheets( ...

... 60 printouts, and they can be quite different. Each has it's own .prg. For example, on any workorder, there are 3 options: Estimate, Invoice, and Worksheet. So in one .prg, as it goes through the process I mentioned earlier, it may print different data or formats. How does it know ? You can use ...

... 60 printouts, and they can be quite different. Each has it's own .prg. For example, on any workorder, there are 3 options: Estimate, Invoice, and Worksheet. So in one .prg, as it goes through the process I mentioned earlier, it may print different data or formats. How does it know ? You can use ...

... occurred at: 02/10/2020, 12:01:56 Error description: (DOS Error -2147352567) WINOLE/1007 Impossibile trovare la proprietà Paste per la classe Worksheet. (0x800A03EC): Microsoft Excel Stack Calls =========== Called from: => TOLEAUTO:PASTE( 0 ) Called from: .\source\classes\XBROWSE.PRG => ...