FiveTech Software tech support forums

... " " FONT 3 Time from start: 0 hours 0 mins 3 secs Error occurred at: 10.03.2021, 18:32:34 Error description: Error Excel.Application:WORKBOOKS:ADD:ACTIVESHEET/3 DISP_E_MEMBERNOTFOUND: RANGE Args: [ 1] = O Excel.Application:WORKBOOKS:ADD:ACTIVESHEET:RANGE:CELLS [ 2] = N 6 I have uploaded ...

Hi All, How to send parameters to Open() method of Excel:Workbooks? The sintaxis for the command is: :Open (FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, ...

... tiene windows 8 en Ingles y el office 2013 en castellano, no tengo este problema en las pc con windows y office en castellano Excel.Application : WORKBOOKS/14 DISP_E_BADPARAMCOUNT:ADD Called from : TOLEAUTO:ADD(0) .\source\classes\XBROWSE.PRG => TXBROWSE:TOEXECEL(10294) alguna forma de solucionar ...

Maybe try making Excel visible to see if it has problems.

// Create the object
oExcel := ExcelObj( )

oExcel:Visible := .t.

oExcel:WorkBooks:Add( )
oAS := oExcel:ActiveSheet( )

oAS:Cells:Font:Name := "Arial"
oAS:Cells:Font:Size := 12

... Variables in use ================ Procedure Type Value ========================== TOLEAUTO:VALUE Local 1: U Local 2: C "Excel.Application:WORKBOOKS:OPEN:ACTIVESHEET:USEDRANGE" TEST Local 1: O Class: TOLEAUTO Local 2: L .F. Local 3: U Local 4: U Linked RDDs =========== DBF DBFFPT DBFBLOB ...

... Build 7601 Service Pack 1 Time from start: 0 hours 0 mins 39 secs Error occurred at: 04/23/19, 10:30:11 Error description: Error Excel.Application:WORKBOOKS:OPEN:ACTIVESHEET:USEDRANGE/14 E_OUTOFMEMORY: VALUE Args: Stack Calls =========== Called from: => TOLEAUTO:VALUE( 0 ) Called from: excelrange2.prg ...

... cFileName ) )  //==> Alwayse appear File not  oExcel := TOleAuto():New( "Excel.Application" )oExcel:WorkBooks:Open(cFileName)  or oExcel := CreateObject( "Excel.Application" ) oExcel:WorkBooks:Open(cFileName)  Got ...

... ) CATCH Alert( "Cannot Connect to Excel. [" + Ole2TxtError()+ "]" ) RETURN (.T.) END END // Open XLS... TRY oExcel:WorkBooks:Open( cDrive + cSource ) oSheet = oExcel:ActiveSheet CATCH Alert( "Error Reading XLS: " + cDrive + cSource + " - [" + ...

... xlDouble -4119 LOCAL oExcel := CREATEOBJECT( "Excel.Application" ) LOCAL oSheet LOCAL oSheet2 subdirc3 = "WK2.xlsx" oExcel:WorkBooks:Open( "&subdirc3" ) cNamex = "S1" oExcel:Sheets( cNamex ):Select() oSheet2 = oExcel:ActiveSheet subdirc2 = "WK1.xlsx" ...

... ) CATCH TRY oExcel := CreateObject( "Excel.Application" ) CATCH RETURN END END nPage := 1 nRow := 1 oBook := oExcel:WorkBooks:Add() oAS := oBook:Worksheets(1) oAs:Name := 'REPORT' oAS:Cells:Font:Name := "Arial" oAS:Cells:Font:Size := 10 oAs:PageSetup:PrintGridLines ...

Solucionado con:

oExcel:WorkBooks:Close()
oExcel:Application:Quit()

gracias.

Amigos del foro Error occurred at: 17/12/2016, 09:35:27 Error description: Error Excel.Application:WORKBOOKS/14 DISP_E_BADPARAMCOUNT: OPEN Args: [ 1] = C C:\nomina\nomina2.xlsm Por fin pude resolver el problema Por si a alguien le llega a ocurrir Desinstale el foxit reader, ...

... visualizar previamente un archivo de excel, cTmpXls:='P:\Tmp\FINAL.xlsx' oExcel:=TOleAuto():New( "Excel.Application" ) oBook :=oExcel:WorkBooks:Open(cTmpXls,0) oSheet:=oExcel:Get("ActiveSheet") oSheet:PrintPreview() oExcel:Close() oExcel:Quit() Que tendre mal?

Saludos Una duda de como abrir un archivo de excel y como cerrarlo Tengo esto: oExcel:=TOleAuto():New( "Excel.Application" ) oExcel:WorkBooks:Open('C:\tmp\agricola.xlsx') oHoja := oExcel:Get( "ActiveSheet" ) ... proceso oExcel:Quit() si lo habre, pero de alguna forma este ...

... usando tOleAuto para abrir archivos de excel y poder leer su informacion, usando oExcel :=TOleAuto():New("Excel.Application") oExcel:WorkBooks:Open(cFilePol) oHoja :=oExcel:Get("ActiveSheet") pero no se cual de estas 3 instrucciones tarda demasiado, una vez abierto ya es ...