Mungkin bisa dicoba tambahkan reference di menu Tool -> references, library "Microsoft Excel 11.0 Library" dan "Microsoft Office 11.0 Object Library". Semoga berhasil...
--- In belajar-excel@yahoogroups.com, slamet harto <[EMAIL PROTECTED]> wrote: > > Hallo pakar, > > ceritanya saya punya coding seperti ini: > With Workbooks(ComboWB.ListIndex + 1).VBProject.VBComponents > > Tiap run selalu debug > Messagenya: > Run-time error '1004': > Method 'VBProject' of object'_workbook'failed > > Sementara di object browser cuma ada: > VbAppWinStyle > VbCalender > VbCallType > VbCompareMethode > VbDateTimeFormat > VbDayOfWeek > VbFileAttribute > VbFirstWeekOfYear > VblMEStatus > VbMsgBoxResult > VbMsgBoxStyle > VbWueryClose > VbStrConv > VbTriState > VbVarType > > > Mohon bantuan dan solusinya untuk dapetin object VbComponent. > Terima kasih atas solusinya dan salam sukses selalu. > Wassalam, > harto > > > > ____________________________________________________________________________________ > Get easy, one-click access to your favorites. > Make Yahoo! your homepage. > http://www.yahoo.com/r/hs >
