Kalo saya tambahkan Error resume next memang bisa dan sukses.
Tapi kalau tidak saya tambahkan, masih ada error di statement
objExcel.Visible = True
Kenapa yaa.."Method visible of object _Application failed. kebetulan saya
pake referensi Microsoft Excel Library 8 punya..!!
apa karena referensi saya ya...
adzhar
<[EMAIL PROTECTED]
com> To
Sent by: [email protected]
[EMAIL PROTECTED] cc
oogroups.com
Subject
Re: [Programmer-VB] BACA FILE EXCEL
08/30/05 09:43 AM kok ngga bisa2..`
Please respond to
[EMAIL PROTECTED]
oogroups.com
Anda cuba source code di bawah:-
Option Explicit
Dim objExcel As Excel.Application
Dim objWorkbook As Excel.Workbook
Dim objWorksheet As Excel.Worksheet
Private Sub Form_Load()
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook = objExcel.Workbooks.Open(App.Path & "\Chemistry.xls")
Set objWorksheet = objWorkbook.ActiveSheet
Set objWorkbook = Nothing
Set objExcel = Nothing
End Sub
--- [EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED]
Date: Fri, 26 Aug 2005 08:57:35 +0700
To: [email protected]
Subject: Re: [Programmer-VB] BACA FILE EXCEL kok ngga bisa2..`
Hi Wata,
kalo deklarasinya saya buat Private Excel_App as Excel.Application,
errornya method 'open' of object 'workbooks' failed pada saat
ExcelExcel_App.Workbooks.Open File_Name
Tapi kalo deklarasinya Private Excel_App as Object tidak ada errornya, tapi
file Excelnya tidak terbuka sama sekali alias tidak ada reaksi apa2
terhadap aplikasi excel..?? Apa ada yg kurang...? Apakah ada references
yang belum saya pilih selain "Microsoft Excel 8 Library"..?
Ada ngga yaa source sederhana yg bisa membuka aplikasi Excel dan filenya
dari VB6, seperti kita membuka file Excel dari Expolerer..?
Tolong donk..?
Apa aja ya syarat buka excel selain open..?
"[EMAIL PROTECTED]"
<[EMAIL PROTECTED]
om.sg> To
Sent by: "[EMAIL PROTECTED]"
[EMAIL PROTECTED] <[email protected]>
oogroups.com cc
Subject
08/25/05 11:34 PM Re: [Programmer-VB] BACA FILE EXCEL
kok ngga bisa2..`
Please respond to
[EMAIL PROTECTED]
oogroups.com
Gagal nya kenapa? bisa dikasi pesan erornya?
--
Salam,
[EMAIL PROTECTED]
Halo doly,
Thursday, August 25, 2005, 2:35:58 PM, kamu nulis kayak ginih:
dac> Dear all,
dac> kalo baca word seutuhnya dengan vb udah bisa.
dac> tapi kenapa yaa saya buka excel dan baca excel secara utuh satu
workbook
dac> kok gagal terus..
dac> Apa yang salah dan kurang apa source saya (kebetulan ambil dari sdr
Mei
dac> Meisaroh di milis ini):
dac> ===============
dac> 'Deklarasi
dac> Private Excel_App As Object ' ===> Ini harus object atau application
dac> yaa..? saya sudah coba dua-duanya gagal juga.
Send instant messages to your online friends
http://asia.messenger.yahoo.com
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
**********************************************************************
This e-mail and any files transmitted with it may contain
confidential information and is intended solely for use by
the individual to whom it is addressed. If you received
this e-mail in error, please notify the sender, do not
disclose its contents to others and delete it from your
system.
**********************************************************************
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
Sila klik ke Cekak Hanafi Web Portal di (Visit Cekak Hanafi Web Portal):
http://www.cekakhanafi.com
(Peneraju Warisan Mutlak)
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
YAHOO! GROUPS LINKS
Visit your group "Programmer-VB" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
**********************************************************************
This e-mail and any files transmitted with it may contain
confidential information and is intended solely for use by
the individual to whom it is addressed. If you received
this e-mail in error, please notify the sender, do not
disclose its contents to others and delete it from your
system.
**********************************************************************
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
