Tecnologia, programação e muito Visual FoxPro.

quarta-feira, 30 de abril de 2014

]] XL-mania [[ Tanya penilaian guru

 

Dear Master XL dan temen mania XL..

saya mau tanya..adakah yang punya form dan penilaian karyawan khususnya guru dalam bentuk xcel..

terimakasih.

hormat saya,

hendri

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Now you can search Photos & Files in your Group !
You can now search for photos and files in your Yahoo Group, in addition to searching for messages in your Group archive

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Maaf moderasi terlambat karena yahoogroups sering error           |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

.

__,_._,___

]] XL-mania [[ Membuat halaman [1 Attachment]

 

Dear Para Master,

Berikut saya mempunyai kasus ingin membuat halaman tetapi rumus/formula excel bingung sudah kutak-kutik tidak berhasil.

berikut terlampir kasus excelnya.

Best regard,

Landy

__._,_.___
View attachments on the web
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Now you can search Photos & Files in your Group !
You can now search for photos and files in your Yahoo Group, in addition to searching for messages in your Group archive

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Maaf moderasi terlambat karena yahoogroups sering error           |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

.

__,_._,___

Re: ]] XL-mania [[ Refresh color - macro

 

Coba tambahkan macro ini di VBE Sheet (Sheet1):
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column >= 3 And Target.Column <= 6 Then
        If Target.Row >= 5 And Target.Row <= 10 Then
            Range("C14:F18").FormulaR1C1 = "=ColorFunction(RC2,R5C:R9C,TRUE)"
        End If
    End If
End Sub

Salam,
HK
On Monday, 28 April 2014, 22:10, "Pujiono, Setyo" <setyo.pujiono@philips.com> wrote:
 
Dear Excel Guru's
Sy coba untuk menghitung  produk capacity dgn base color function dengan menambahkan macro dan ternyata berhasil. Namun ketika sy mengganti color di capacitynya, ternyata di perlukan satu macro unutk merefresh total colorfunction nya. Udah coba bikin macro, cuman hasil keluar dari area diimana cell yang di harapkan.
 
Option di excel untuk formula udah otomatis.
 
Mohon bantuan nya Gan, unutk create macro yang mana jika sy mengganti capacity color, refresh product output qty akan terhitung .
 
Thanks.
 
Best Regards,
 
Setyo Pujiono
 
 


The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

Now you can search Photos & Files in your Group !
You can now search for photos and files in your Yahoo Group, in addition to searching for messages in your Group archive

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Maaf moderasi terlambat karena yahoogroups sering error           |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

.

__,_._,___

terça-feira, 29 de abril de 2014

]] XL-mania [[ Looping antar sheet [1 Attachment]

 

Assalamu'alaikum Wr. Wb.
Semangat Pagi ...
 
Mohon bantuannya, kiranya guru, master dan rekan2 XL-Mania berkenan membantu permasalahan saya.
 
Saya punya 2 DATA SUMBER di 2 sheet berbeda, sheet (DATA_SS_2014) dan sheet (Data_Sales_2014).
Kemudian ada 3 Sheet utk menampilkan data dan graphic dg nama sheet sbb :
1. (JDWL_SS_ EXPORT14) utk menampilkan data shipment yg datanya diambil dari sheet (DATA_SS_2014) dg proses looping saat klik tombol LOOPING DATA yg menampilkan data tiap 10 row.
 
2. (GRAPHIC_SALES_BY_BRAND14) yg memunculkan graphic dg datanya diambil dari Sheet Data_Sales_2014.
3. (GRAPHIC_SALES_BY_CUST14) yg memunculkan graphic dg datanya diambil dari Sheet Data_Sales_2014.
 
Pertanyaannya :
 
1. Bagaimana caranya agar saat saya klik tombol Looping Data di sheet JDWL_SS_EXPORT14, setelah proses Looping data pd tabel di sheet tersbt selesai maka Looping akan dilanjutkan ke sheet GRAPHIC_SALES_BY_BRAND14 dg menampilkan semua Grafic yg ada disheet tersbt (dlm contoh hanya 1 graphic dan sangat dimungkinkan akan lebih 1 graphic dlm sheet tersbt.
 
2. Setelah proses looping pada sheet GRAPHIC_SALES_BY_BRAND14  selesai maka Looping akan berlanjut ke sheet GRAPHIC_SALES_BY_CUST14.
 
3. Setelah proses Looping di sheet GRAPHIC_SALES_BY_CUST14  selesai maka proses Looping akan kembali ke sheet  JDWL_SS_EXPORT14 dan melakukan Looping data yg ada disheet tersbt sampai selesai kemudian berlanjut ke Sheet Graphic dst akan terus begitu sampai saya klik Tombol Stop Looping maka proses looping akan berhenti.
 
Kiranya guru, master dan rekan2 XL-Mania berkenan memberikan pencerahan kepada saya yg masih fakir ilmu ini.
 
Sekali lagi terimakasih banyak atas pencerahan dan pertolongan yg diberikan.
 
 
Wassalam,
Mulki

__._,_.___
View attachments on the web
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Now you can search Photos & Files in your Group !
You can now search for photos and files in your Yahoo Group, in addition to searching for messages in your Group archive

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Maaf moderasi terlambat karena yahoogroups sering error           |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

.

__,_._,___

]] XL-mania [[ mengubah file excel ke notepad

 

halo

bagaimana ya cara mengubah file excel ke notepad (.dat) ??
terimakasih atas bantuannya.

salam 


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Now you can search Photos & Files in your Group !
You can now search for photos and files in your Yahoo Group, in addition to searching for messages in your Group archive

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Maaf moderasi terlambat karena yahoogroups sering error           |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

.

__,_._,___

Re: [usuarios_fox] Migracion a la nube Entity Framework y WCF

 

Hola buen dia

En el entorno de .NET  consulten LIGTHSWITCH  de Visual Studio

Para los programadores de Visualfox que quieran aprovechar su background   visiten  www.lianja.com 

Ambos productos nos permiten generar un desarrollo e implementarlo en la red local, en la web y en la nube permitiendo el acceso a dispositivos moviles




El 29 de abril de 2014, 10:14, Fernando Montero Gutierrez <fmonterog@hotmail.com> escribió:
 

buenos dias, disculpe quisiera hacerle una pregunta. ¿Visual Fox Pro es una plataforma potente en el mercado para desarrollo de software?, yo era programador de fox me quede en la version 6.0 y emigre a visual basic .net.


From: jamorquecho@hotmail.com
To: usuarios_fox@yahoogrupos.com.mx
Date: Tue, 29 Apr 2014 10:02:03 -0500
Subject: [usuarios_fox] Migracion a la nube Entity Framework y WCF


 


Hola a todos:

Quiero comentarles dese hace tiempo he buscado formas de poder migrar hacia la  nube y otras nuevas tecnologías.

Encontré un camino en .Net con el Entity Framweork, me gustaría saber si han tenido alguna experiencias en esto igual que en Windows Comunication Foundation.

Y claro ver si se podemos preparar algo de material.

Saludos Cordiales.




--
Saludos

Víctor Jiménez

__._,_.___
Responder mediante la Web Responder a remitente Responder a grupo Crear un tema nuevo Mensajes con este tema (7)

Comentarios, agregar archivos en el foro, observaciones o si deseas darte de baja avísame a: jamorquecho@hotmail.com

.

__,_._,___

RE: [usuarios_fox] Migracion a la nube Entity Framework y WCF

 

buenos dias, disculpe quisiera hacerle una pregunta. ¿Visual Fox Pro es una plataforma potente en el mercado para desarrollo de software?, yo era programador de fox me quede en la version 6.0 y emigre a visual basic .net.


From: jamorquecho@hotmail.com
To: usuarios_fox@yahoogrupos.com.mx
Date: Tue, 29 Apr 2014 10:02:03 -0500
Subject: [usuarios_fox] Migracion a la nube Entity Framework y WCF

 


Hola a todos:

Quiero comentarles dese hace tiempo he buscado formas de poder migrar hacia la  nube y otras nuevas tecnologías.

Encontré un camino en .Net con el Entity Framweork, me gustaría saber si han tenido alguna experiencias en esto igual que en Windows Comunication Foundation.

Y claro ver si se podemos preparar algo de material.

Saludos Cordiales.

__._,_.___
Responder mediante la Web Responder a remitente Responder a grupo Crear un tema nuevo Mensajes con este tema (6)

Comentarios, agregar archivos en el foro, observaciones o si deseas darte de baja avísame a: jamorquecho@hotmail.com

.

__,_._,___

[usuarios_fox] Migracion a la nube Entity Framework y WCF

 


Hola a todos:

Quiero comentarles dese hace tiempo he buscado formas de poder migrar hacia la  nube y otras nuevas tecnologías.

Encontré un camino en .Net con el Entity Framweork, me gustaría saber si han tenido alguna experiencias en esto igual que en Windows Comunication Foundation.

Y claro ver si se podemos preparar algo de material.

Saludos Cordiales.

__._,_.___
Responder mediante la Web Responder a remitente Responder a grupo Crear un tema nuevo Mensajes con este tema (5)

Comentarios, agregar archivos en el foro, observaciones o si deseas darte de baja avísame a: jamorquecho@hotmail.com

.

__,_._,___

]] XL-mania [[ Re: Refresh color - macro [1 Attachment]

 

Dear Syech,

 

Monggo, macro dari jeng ctv dulu..

 

Cheers,

Rommy A


__._,_.___
View attachments on the web
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Now you can search Photos & Files in your Group !
You can now search for photos and files in your Yahoo Group, in addition to searching for messages in your Group archive

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Maaf moderasi terlambat karena yahoogroups sering error           |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

.

__,_._,___

RE: ]] XL-mania [[ Refresh color - macro [1 Attachment]

 

Dear Syech,

 

Monggo, macro dari jeng ctv dulu..

 

Regards,

Rommy A

 

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of Pujiono, Setyo
Sent: Sunday, April 27, 2014 6:25 AM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Refresh color - macro [1 Attachment]

 

 

Dear Excel Guru's

Sy coba untuk menghitung  produk capacity dgn base color function dengan menambahkan macro dan ternyata berhasil. Namun ketika sy mengganti color di capacitynya, ternyata di perlukan satu macro unutk merefresh total colorfunction nya. Udah coba bikin macro, cuman hasil keluar dari area diimana cell yang di harapkan.

 

Option di excel untuk formula udah otomatis.

 

Mohon bantuan nya Gan, unutk create macro yang mana jika sy mengganti capacity color, refresh product output qty akan terhitung .

 

Thanks.

 

Best Regards,

 

Setyo Pujiono

Email    : setyo.pujiono@philips.com

 

 

 


The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.

__._,_.___
View attachments on the web
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Now you can search Photos & Files in your Group !
You can now search for photos and files in your Yahoo Group, in addition to searching for messages in your Group archive

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Maaf moderasi terlambat karena yahoogroups sering error           |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

.

__,_._,___

Arquivo do blog