[milis-belajar-excel] Apakah bisa tranfer File dari VBA Excel menuju Excel Spreadsheet?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] Apakah bisa tranfer File dari VBA Excel menuju Excel Spreadsheet?

CENEL YUSUF MANURUNG
Sore Mr Kid,


Apakah bisa tranfer File dari VBA Excel menuju Excel Spreadsheet?
Bantu skripnya dong
Terimakasih



Regards,
YM

--
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/d32b0503-bcb7-4d04-addc-d9f1de7ff941n%40googlegroups.com.
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Apakah bisa tranfer File dari VBA Excel menuju Excel Spreadsheet?

Kid
Administrator
Maksudnya save as ?

Workbook yang VBA nya sedang bekerja :
    Thisworkbook.saveas "nama baru file fullname", enumFileFormat
Workbook yang sedang terbuka di-instance excel application yang sama bernama kid.xlsx
    Workbooks("kid.xlsx").saveas  "nama baru file fullname", enumFileFormat
Workbook kid.xlsx yang ada di D:\folder\subfolder tapi akan dikerjakan di instance excel application yang berbeda dengan yang vba nya sedang bekerja :
   dim wbkApp as workbook, xlAppLain as application, wbkLain as workbook
   set wbkapp=thisworkbook
   set xlapplain=new excel.application
   set wbklain=xlapplain.workbooks.open("d:\folder\subfolder\kid.xlsx",2,true)   'dibuka tanpa update file dan dalam keadaan read only
   wbklain.saveas  "nama baru file fullname", enumFileFormat
   wbklain.close false   'tutup tanpa di-save (setelah save-as)
   xlapplain.quit
   wbkapp.activate

Untuk enumFileFormat bisa dilihat dan dipilih disini sesuai kebutuhan.

Regards,
Kid





On Wed, Feb 3, 2021 at 7:41 PM CENEL YUSUF MANURUNG <[hidden email]> wrote:
Sore Mr Kid,


Apakah bisa tranfer File dari VBA Excel menuju Excel Spreadsheet?
Bantu skripnya dong
Terimakasih



Regards,
YM

--
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/d32b0503-bcb7-4d04-addc-d9f1de7ff941n%40googlegroups.com.

--
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/CAOiZkPvX4nZa7fFt8qHYwTF14vrrkBkacO4QJUuHa3VVmgvtRg%40mail.gmail.com.