{"id":1567,"date":"2023-11-17T04:20:20","date_gmt":"2023-11-17T04:20:20","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/"},"modified":"2023-12-06T06:14:03","modified_gmt":"2023-12-06T06:14:03","slug":"lemari-arsip-terbuka","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/","title":{"rendered":"Bagaimana cara membuka buku kerja di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3829780410\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk membuka buku kerja menggunakan VBA, Anda perlu menggunakan metode &#8220;Buku Kerja.Buka&#8221; dan menentukan jalur file (pastikan untuk menentukan jalur lengkap buku kerja dengan nama dan jenis file ekstensi). Metode ini memiliki total lima belas argumen opsional yang dapat Anda gunakan untuk memproses berbagai jenis file.<\/p><p> Dalam tutorial ini, kita akan menjelajahinya secara detail dan melihat metode alternatif yang dapat Anda gunakan.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah membuka buku kerja menggunakan VBA<\/h2><ol type=\"1\"><li> Untuk memulai kode, gunakan objek \u201cBuku Kerja\u201d.<\/li><li> Ketik titik (.) setelah itu dan pilih metode Buka dari daftar.<\/li><li> Tentukan jalur file di argumen pertama dan pastikan untuk mengapitnya dalam tanda kutip ganda.<\/li><li> Pada akhirnya, jalankan kode untuk membuka buku kerja. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53463\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-un-classeur-avec-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"buka buku kerja dengan vba\" width=\"586\" height=\"193\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_open_workbook() Workbooks.Open \"C:UsersDellDesktopmyFile.xlsx\" End Sub<\/code><\/pre><p class=\"content-box-grey\"> <em>Tautan yang berguna: <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">Jalankan makro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/merekam-makro\/\">Perekam makro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/editor-visual-dasar\/\">Editor Visual Basic<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/buku-catatan-makro-pribadi\/\">Buku Pegangan Makro Pribadi<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> Buku Kerja. Sintaks Terbuka<\/h2><p> Sekarang saatnya melihat sintaks metode yang baru saja Anda gunakan pada contoh di atas. Seperti yang saya sebutkan, ada lima belas argumen yang dapat Anda gunakan:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">expression.Open (FileName, UpdateLinks, _ ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, _ Delimiter, Editable, Notify, Converter, AddToMru, Local, CorruptLoad)<\/code><\/pre><p> Anda tidak akan menggunakan semua argumen ini. Namun beberapa di antaranya cukup penting dan mungkin berguna bagi Anda di dunia nyata.<\/p><h2 class=\"wp-block-heading\"> Membuka buku kerja yang dilindungi kata sandi<\/h2><p> Jika Anda ingin membuka buku kerja yang dilindungi kata sandi, dalam hal ini Anda bisa menentukan kata sandi dengan argumen kata sandi.<\/p><p> Di sini saya memiliki buku kerja di desktop yang memiliki kata sandi &#8220;test123&#8221; dan sekarang saya ingin membuka dan membuka proteksinya secara bersamaan. Ini kode yang perlu saya gunakan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks.Open \"C:UsersDellDesktopmyFile.xlsx\", , , Password:=\"test123\"<\/code><\/pre><h2 class=\"wp-block-heading\"> Buka buku kerja baca-saja<\/h2><p> Saat Anda membuka buku kerja baca-saja, Anda tidak bisa membuat perubahan pada buku kerja yang sama, tapi Anda harus menyimpan salinannya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks.Open \"C:UsersDellDesktopFolder1.xlsx\", , True<\/code><\/pre><h2 class=\"wp-block-heading\"> Buka semua buku kerja dalam satu folder<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_open_multiple_workbooks_folder() Dim wb As Workbook Dim strFolder As String Dim strFile As String strFolder = \"C:UsersDellDesktopFolder\" strFile = Dir(strFolder &amp; \"*.xls*\") Do While strFile &lt;&gt; \"\" Set wb = Workbooks.Open(strFolder &amp; strFile) strFile = Dir Loop End Sub<\/code><\/pre><p> Untuk menggunakannya sesuai kebutuhan Anda, pastikan untuk mengubah jalur folder.<\/p><h2 class=\"wp-block-heading\"> Kotak Dialog Buka File Buku Kerja<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_open_dialog() Dim strFile As String strFile = Application.GetOpenFilename() Workbooks.Open (strFile) End Sub<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/\">Salin file Excel (buku kerja) menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/\">Buku Kerja Aktifkan VBA (File Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/\">Tutup buku kerja VBA (file Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/\">VBA Menggabungkan Buku Kerja (File Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/membuat-buku-kerja\/\">VBA Buat buku kerja baru (file Excel)<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1567","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara membuka buku kerja menggunakan VBA di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menunjukkan cara membuka file Excel (buku kerja) yang disimpan di sistem Anda dalam folder tertentu.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara membuka buku kerja menggunakan VBA di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menunjukkan cara membuka file Excel (buku kerja) yang disimpan di sistem Anda dalam folder tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-un-classeur-avec-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/\",\"name\":\"\u25b7 Bagaimana cara membuka buku kerja menggunakan VBA di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-un-classeur-avec-vba.png\",\"datePublished\":\"2023-11-17T04:20:20+00:00\",\"dateModified\":\"2023-12-06T06:14:03+00:00\",\"description\":\"Tutorial ini menunjukkan cara membuka file Excel (buku kerja) yang disimpan di sistem Anda dalam folder tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-un-classeur-avec-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-un-classeur-avec-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuka buku kerja di vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara membuka buku kerja menggunakan VBA di Excel?","description":"Tutorial ini menunjukkan cara membuka file Excel (buku kerja) yang disimpan di sistem Anda dalam folder tertentu.","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:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara membuka buku kerja menggunakan VBA di Excel?","og_description":"Tutorial ini menunjukkan cara membuka file Excel (buku kerja) yang disimpan di sistem Anda dalam folder tertentu.","og_url":"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:03+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-un-classeur-avec-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/","url":"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/","name":"\u25b7 Bagaimana cara membuka buku kerja menggunakan VBA di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-un-classeur-avec-vba.png","datePublished":"2023-11-17T04:20:20+00:00","dateModified":"2023-12-06T06:14:03+00:00","description":"Tutorial ini menunjukkan cara membuka file Excel (buku kerja) yang disimpan di sistem Anda dalam folder tertentu.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-un-classeur-avec-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-un-classeur-avec-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/lemari-arsip-terbuka\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuka buku kerja di vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1567","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1567"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1567\/revisions"}],"predecessor-version":[{"id":2327,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1567\/revisions\/2327"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}