bb.donnay-software.com

Greetings, I hope you and your families are well.

Please, if someone could give me some information about this error that appears when I try to export to Excel from my program,
I use the following statement:

cEnvName := "AccountsReceivable" + StrZ(Day(dFecCxC), 2, 0) + Left(MesAnno(dFecCxc), 3) + StrZ(Year(dFecCxc), 4, 0) + ". xls"
DBSelectArea("cTemporaryFileName")
DC_WorkArea2Excel("&PathToExe" + "&cEnvName",,,,,,)

MsgBox("FILE SUCCESSFULLY GENERATED" + Chr(10) + "&cEnvName" + Chr(10) + "&PathToExe","*** NOTICE ***")
DC_SpawnUrl("&PathToExe"+"&EnvName")

And then sometimes that happens.

ESPAÑOL

Saludos,cordiales espero que esten bien al igual que sus familias.

Por favor si alguien me pudiera dar informacion sobre este error que sale cuando intendo exportar a excel desde mi programa
uso la siguiente instruccion:

cNomEnv := "CuentasxCobrarAl"+StrZ(Day(dFecCxC),2,0)+Left(MesAnno(dFecCxc),3)+StrZ(Year(dFecCxc),4,0)+".xls"
DBSelectArea("cNombreArchivoTemporal")
DC_WorkArea2Excel("&RutaAExe"+"&cNomEnv",,,,,,)

MsgBox("ARCHIVO GENERADO EXISTOSAMENTE"+Chr(10)+"&cNomEnv"+Chr(10)+"&RutaAExe","*** AVISO ***")
DC_SpawnUrl("&RutaAExe"+"&cNomEnv")

y entonces alguna veces sale eso

Hi,

In _dcfunct.prg there is oSheet:Application:ActiveWindow:FreezePanes := .T.. This is the cause of the error.

This happens sometimes. Normally it works but it is something in the configuration of Windows or Excel. It is fails on a PC it will always fail. Maybe you can re-install Excel, but I'm not sure if this will solve the problem.

Tiene que correr su sistema como Administrador
para poder tener todos los derechos de windows