Selamat siang rekan2 Be-Excel, Bagi rekan2 yang bergerak dibidang akuntansi dan suka utak atik macro yang berkaitan dengan Pivot Table, terlampir adalah PivotTable External Data Source dalam bentuk compressed File (.rar) yang terdiri dari 1 Folder dan 2 File (Pivottable dan Jurnal). Sebelum diutak atik extract dulu Folder tsb. ke salah satu Directory, mis. E Cara kerjanya: Buka file PivotExternalSource dan coba lakukan Refresh. Jika Drectory dari file Jurnal tidak sesuai akan ada pertanyaan yang harus kita jawab OK dan YES. (Macronya hasil Rekam/Edit, namun blm fully automatic). Pertanyaan (yang belum bisa saya jawab).... Bagaimana caranya agar Macro tsb dapat bekerja secara otomatis walupun kita gonta ganti Directory dan Foldernya (asumsi File PivotTable dan Sourcenya (nama tetap "Jurnal") tetap berada dalam satu folder). Terima kasih atas pencerahannya. Salam, HK You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group. To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email]. To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/218831185.584825.1610352694565%40mail.yahoo.com. |
Dear Pak Hendrik,
Terima kasih banyak Pak Hendrik atas ilmunya Pak.. Salam, Indra On Monday, January 11, 2021 at 3:13:18 PM UTC+7 Hendrik Karnadi 'HK' MilisBeExcel wrote:
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group. To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email]. To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/20300863-dfb9-468d-8e7e-c5f9af2b002dn%40googlegroups.com. |
Administrator
|
In reply to this post by hendrik karnadi
Fitur tersebut sudah mulai masuk legacy. Jamannya sudah pakai PowerQuery. Tidak perlu VBA. Regards, Kid On Mon, Jan 11, 2021 at 3:13 PM 'hendrik karnadi' via milis Belajar-Excel <[hidden email]> wrote:
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group. To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email]. To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPt0p7QugF-GrMZp2PMqOFHRaYKE8bvKjkVdxTwb7imtOg%40mail.gmail.com. |
Terima kasih Mr. Kid atas infonya.
Betul sekali jamannya sdh masuk Power Query dan saya juga sdh lakukan dengan contoh dari Webinar Mr. Kid. Berhasil. Masalahnya, ada temen yang masih pakai Excel 2010 dan pakai Windows 7....Install Add In Power Query dari internet ga berhasil. Alhasil dia mau kembali ke Macro. Terima kasih atas pencerahannya. Salam, HK
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group. To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email]. To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1708760338.140705.1610680822196%40mail.yahoo.com. |
Free forum by Nabble | Edit this page |