............ Foro Excel
Si no lo has hecho aún: REGISTRATE!!!

Necesito generar un TXT desde un Excel con Macros, alguien puede ayudarme? gracias!!!!

Ver el tema anterior Ver el tema siguiente Ir abajo

Necesito generar un TXT desde un Excel con Macros, alguien puede ayudarme? gracias!!!!

Mensaje por dated el Vie Sep 06, 2013 5:05 pm

Tengo que mostrar LAS COLUMNAS J Y K. Con la hora adelante y algunos carteles arriba. Adjunto Excel. Y Esto es lo q debo mostrar:

"kw"
"Time ","SLOMM41P"."SLOMM41P"  
" 6/01/13 00:15",237.5,0.0
"00:30",236.0,0.0
"00:45",235.2,0.0
"01:00",237.1,0.0
"01:15",237.0,0.0
"01:30",237.3,0.0
"01:45",235.9,0.0
"02:00",236.3,0.0
"02:15",236.2,0.0
"02:30",236.0,0.0
"02:45",236.0,0.0
"03:00",235.8,0.0
"03:15",236.7,0.0
"03:30",235.9,0.0
"03:45",236.2,0.0
"04:00",235.2,0.0
"04:15",235.0,0.0
"04:30",236.0,0.0
"04:45",235.7,0.0
"05:00",236.1,0.0
"05:15",235.1,0.0
"05:30",235.0,0.0
"05:45",234.6,0.0
"06:00",234.7,0.0
"06:15",234.6,0.0
"06:30",234.6,0.0
"06:45",234.4,0.0
"07:00",234.5,0.0
"07:15",234.6,0.0
"07:30",234.9,0.0
"07:45",234.7,0.0
"08:00",234.8,0.0
"08:15",233.9,0.0
"08:30",232.5,0.0
"08:45",238.5,0.0
"09:00",239.9,0.0
"09:15",240.0,0.0
"09:30",240.8,0.0
"09:45",240.8,0.0
"10:00",240.7,0.0
"10:15",240.6,0.0
"10:30",240.6,0.0
"10:45",240.3,0.0
"11:00",240.5,0.0
"11:15",239.7,0.0
"11:30",239.3,0.0
"11:45",239.1,0.0
"12:00",239.3,0.0
"12:15",238.4,0.0
"12:30",238.4,0.0
"12:45",238.4,0.0
"13:00",238.4,0.0
"13:15",241.9,0.0
"13:30",241.9,0.0
"13:45",241.9,0.0
"14:00",241.9,0.0
"14:15",239.5,0.0
"14:30",239.5,0.0
"14:45",239.5,0.0
"15:00",239.5,0.0
"15:15",239.5,0.0
"15:30",239.5,0.0
"15:45",239.5,0.0
"16:00",239.5,0.0
"16:15",241.9,0.0
"16:30",241.9,0.0
"16:45",241.9,0.0
"17:00",241.9,0.0
"17:15",241.9,0.0
"17:30",241.9,0.0
"17:45",241.9,0.0
"18:00",241.9,0.0
"18:15",240.7,0.0
"18:30",240.7,0.0
"18:45",240.7,0.0
"19:00",240.7,0.0
"19:15",238.1,0.0
"19:30",238.1,0.0
"19:45",238.1,0.0
"20:00",238.1,0.0
"20:15",237.0,0.0
"20:30",237.0,0.0
"20:45",237.0,0.0
"21:00",237.0,0.0
"21:15",237.0,0.0
"21:30",237.0,0.0
"21:45",237.0,0.0
"22:00",237.0,0.0
"22:15",238.1,0.0
"22:30",238.1,0.0
"22:45",238.1,0.0
"23:00",238.1,0.0
"23:15",238.1,0.0
"23:30",238.1,0.0
"23:45",238.1,0.0
" 6/01/13 24:00",238.1,0.0
avatar
dated

Femenino Cantidad de envíos : 2
Edad : 29
Ciudad - Pais : san juan argentina
Version de Excel : 2007
Fecha de inscripción : 06/09/2013

Volver arriba Ir abajo

Re: Necesito generar un TXT desde un Excel con Macros, alguien puede ayudarme? gracias!!!!

Mensaje por Cacho R el Sáb Sep 07, 2013 2:13 pm

Hola! dated
Hay varias cosas importantes que no has comentado sobre tu consulta.

Para evitarnos -a todos- hacer suposiciones que podrían no ser ciertas, te sugiero que subas al Foro dos archivos reducidos:

- Un Excel donde veamos algunas filas de datos a transferir (digamos: 10 filas de datos)
- Un archivo de texto donde veamos: la cabecera del archivo y las 10 filas antes mencionadas dispuestas del modo que deseas.

A partir de ellos podremos sugerirte soluciones útiles.
Saludos, Cacho R.
avatar
Cacho R
Moderador
Moderador

Masculino Cantidad de envíos : 210
Ciudad - Pais : Buenos Aires
Version de Excel : Desde Multiplan (pre-Excel) hasta 2010
Fecha de inscripción : 29/06/2011

Volver arriba Ir abajo

Generar una MACRO!!

Mensaje por dated el Miér Sep 11, 2013 5:15 pm

Gracias Cacho por responder a mi consulta!!. La verdad q llevo días con esto porq no sabia nada de macro. Tengo q terminarlo para el viernes ya que es mi ultimo día de trabajo así q lo q me envíes o envíen sera de mucha bendición !!
Vuelvo a enviar lo que me dijiste.

Les envío el excel.
En la segunda hoja puse un botón que este debería generar un TXT.
También adjuntare el TXT que me dieron de referencia.
Desde ya muchas gracias!!!
Archivos
BASE.xlsm No tienes los permisos para descargar los archivos.(35 KB) Descargado 16 veces
Sin título.jpg Formato de salida del TXTNo tienes los permisos para descargar los archivos.(27 KB) Descargado 10 veces
avatar
dated

Femenino Cantidad de envíos : 2
Edad : 29
Ciudad - Pais : san juan argentina
Version de Excel : 2007
Fecha de inscripción : 06/09/2013

Volver arriba Ir abajo

Re: Necesito generar un TXT desde un Excel con Macros, alguien puede ayudarme? gracias!!!!

Mensaje por Contenido patrocinado


Contenido patrocinado


Volver arriba Ir abajo

Ver el tema anterior Ver el tema siguiente Volver arriba


 
Permisos de este foro:
No puedes responder a temas en este foro.