[belajar-access] Re: Export report ke excel

 

Sub contohaja()
On Error GoTo label_Err
    DoCmd.OutputTo acOutputReport, "tbbayar", "Excel97-Excel2003Workbook(*.xls)", "d:\temp\hasil.xls", False, "", , acExportQualityPrint
label_Exit:
    Exit Sub

label_Err:
    MsgBox Error$
    Resume label_Exit

End Sub

 

semoga sesuai

--- In belajar-access@yahoogroups.com, Afrizal <aflazio7@...> wrote:
>
> Dear Master Access
> saya mau nanya gmn cara export report ke excell wi access 2007
> saya coba buat tombol command wizard tidak ada pilihan xls atau xlsx
>
> thank
>
> Afrizal
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Members 9
• New Files 1

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___