{"id":4447,"date":"2023-07-11T01:07:48","date_gmt":"2023-07-11T01:07:48","guid":{"rendered":"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/"},"modified":"2023-07-11T01:07:48","modified_gmt":"2023-07-11T01:07:48","slug":"cetak-vba-ke-pdf","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/","title":{"rendered":"Cara mencetak ke pdf menggunakan vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut di VBA untuk mencetak lembar Excel yang sedang aktif ke PDF:<\/span><\/p>\n

 SubPrintToPDF<\/span> ()\n\nActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _\n                                Filename:=\" my_data.pdf<\/span> \", _\n                                Quality:=xlQualityStandard, _\n                                IncludeDocProperties:= False<\/span> ,_\n                                IgnorePrintAreas:= False ,_<\/span>\n<\/span>OpenAfterPublish:= True<\/span>\n\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan mencetak lembar Excel yang sedang aktif ke PDF bernama my_data.pdf<\/strong> dan akan disimpan di folder saat ini.<\/span><\/p>\n
 Catatan #1<\/strong> : Anda juga dapat menyertakan jalur file lengkap dalam argumen Nama File<\/strong> untuk menyimpan PDF ke folder tertentu.<\/span><\/p>\n
 Catatan #2<\/strong> : Baris OpenAfterPublish:= True<\/strong> memberitahu VBA untuk membuka PDF segera setelah diekspor. Anda dapat menghilangkan argumen ini jika Anda tidak ingin PDF dibuka setelah diekspor.<\/span><\/p>\n
 Catatan #3<\/strong> : Satu-satunya argumen yang diperlukan dalam metode EksporAsFixedFormat<\/strong> adalah Type<\/strong> , yang harus diatur ke xlTypePDF<\/strong> untuk mencetak lembar dalam format PDF.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan makro ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Ekspor lembar Excel ke PDF menggunakan VBA<\/strong><\/span><\/h2>\n
 Misalkan kita mempunyai lembar Excel berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang katakanlah kita ingin mengekspor sheet ini ke PDF bernama my_data.pdf<\/strong> .<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubPrintToPDF<\/span> ()\n\nActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _\n                                Filename:=\" my_data.pdf<\/span> \", _\n                                Quality:=xlQualityStandard, _\n                                IncludeDocProperties:= False<\/span> ,_\n                                IgnorePrintAreas:= False ,_<\/span>\n<\/span>OpenAfterPublish:= True<\/span>\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat<\/span> kami menjalankan makro ini, lembar Excel diekspor ke PDF dan kemudian PDF dibuka secara otomatis:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa format sel yang tepat dengan batas dan warna isian disertakan dalam PDF.<\/span><\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap metode EksporAsFixedFormat<\/strong> di VBA di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: cara membuat folder<\/a>
 VBA: cara menghapus folder<\/a>
 VBA: cara menghapus file<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut di VBA untuk mencetak lembar Excel yang sedang aktif ke PDF: SubPrintToPDF () ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=” my_data.pdf “, _ Quality:=xlQualityStandard, _ IncludeDocProperties:= False ,_ IgnorePrintAreas:= False ,_ OpenAfterPublish:= True End Sub Makro khusus ini akan mencetak lembar Excel yang sedang aktif ke PDF bernama my_data.pdf dan akan disimpan di […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"\nCara Mencetak ke PDF Menggunakan VBA (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencetak lembar Excel ke PDF menggunakan VBA, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mencetak ke PDF Menggunakan VBA (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencetak lembar Excel ke PDF menggunakan VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T01:07:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pd1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/\",\"url\":\"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/\",\"name\":\"Cara Mencetak ke PDF Menggunakan VBA (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T01:07:48+00:00\",\"dateModified\":\"2023-07-11T01:07:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencetak lembar Excel ke PDF menggunakan VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mencetak ke pdf menggunakan vba (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Mencetak ke PDF Menggunakan VBA (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara mencetak lembar Excel ke PDF menggunakan VBA, dengan sebuah contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mencetak ke PDF Menggunakan VBA (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara mencetak lembar Excel ke PDF menggunakan VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/","og_site_name":"Statorials","article_published_time":"2023-07-11T01:07:48+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pd1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/","url":"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/","name":"Cara Mencetak ke PDF Menggunakan VBA (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T01:07:48+00:00","dateModified":"2023-07-11T01:07:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencetak lembar Excel ke PDF menggunakan VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cetak-vba-ke-pdf\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mencetak ke pdf menggunakan vba (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4447"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4447"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4447\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}