Thanks a lot mbak vi
________________________________ From: siti Vi <[email protected]> To: [email protected] Sent: Thu, January 21, 2010 11:23:38 AM Subject: Re: [belajar-excel] autorun saya bukan pemakai MS Office 2007, jadi ndak tahu babar-blas di Excel 12 seperti apa harusnya. tetapi kalau di excel 2003 ada cara menyuruh kuntilanak menjawab allert (tepatnya meniadakan munculnya allert) spt ini Application. DisplayAlerts = False ' --- instruksi yg bisa menimbulkan allert message Application. DisplayAlerts = True mudah2an di excel 12 : property DisplayAllert (salah satu member dari object Application) belum di buang... ----- Original Message ----- >From: waku >To: belajar-excel@ yahoogroups. com >Sent: Thursday, January 21, 2010 10:26 AM >Subject: [belajar-excel] autorun > >Dear Milist, > >Saya sudah buat file yang di tempeli code auto run, perintahnya sbb: > > >Private Sub Workbook_Open( ) >ActiveWorkbook. SaveAs Filename:="H: \Wahyu\DATA\ RMBUFFER" & x & m & ".xlsx", >FileFormat:= xlOpenXMLWorkboo kMacroEnabled, CreateBackup: =False > > ActiveWorkbook. Save > ActiveWindow. Close > >End Sub > >yang jadi masalah muncul interaktif pop up konfirmasi karena file ext xlsm di >save as ke file ext xlsx. > >Bagaimana ya caranya menghilangkan interaktif pop up ini ya, soalnye >rencananye mo di active kan tengah malam, siape nyang mau nge klik hihihi >masa kuntilanak :) > >Mohon bantuannye ye > >Thanks sebelumnya >wahyu >
