LOCAL oExcel,lcCursorName Select CrsToExcel1 sheetNames1 = "Megye_eseti" oExcel = Createobject("Excel.Application") With oExcel .DisplayAlerts = .F. .Workbooks.Add .Visible = .T. With .ActiveWorkBook lcCursorName = 'crsToExcel1' .WorkSheets(1).Name = sheetNames1 VFP2Excel(m.lcCursorName, .WorkSheets(1),"A1" ) .WorkSheets(1).Activate Endwith Endwith Function VFP2Excel Lparameters tcCursorName, toSheet, tcTargetRange tcCursorName = Iif(Empty(m.tcCursorName),Alias(),m.tcCursorName) tcTargetRange = Iif(Empty(m.tcTargetRange),'A1',m.tcTargetRange) Local loConn As AdoDB.Connection, loRS As AdoDB.Recordset,; lcTempRs, lcTemp, oExcel lcTemp = Forcepath(Sys(2015)+'.dbf',Sys(2023)) lcTempRs = Forcepath(Sys(2015)+'.rst',Sys(2023)) Select (m.tcCursorName) Copy To (m.lcTemp) loConn = Createobject("Adodb.connection") loConn.ConnectionString = "Provider=VFPOLEDB;Data Source="+Sys(2023) loConn.Open() loRS = loConn.Execute("select * from "+m.lcTemp) loRS.Save(m.lcTempRs) loRS.Close loConn.Close Erase (m.lcTemp) loRS.Open(m.lcTempRs) With toSheet .QueryTables.Add( loRS, .Range(m.tcTargetRange)).Refresh() Endwith loRS.Close Erase (m.lcTempRs)