FW: [belajar-access] Export Report

 

 

---

From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com]
Sent: 24 Nopember 2015 8:27
To: belajar-access@yahoogroups.com
Subject: Re: [belajar-access] Export Report

 

 

Om aksan,
Kl yg mau diexport report nya bukan querynya ada caranya gak ?
Thx
Pada 24 Nov 2015 08.03, "Aksan Kurdin aksan.kurdin@gmail.com [belajar-access]" <belajar-access@yahoogroups.com> menulis:

dari: http://www.access-programmers.co.uk/forums/showthread.php?t=188007
DoCmd.TransferSpreadsheet acExport, , "YourTableOrQuery1", "X:\YourOutputFile.xls", True DoCmd.TransferSpreadsheet acExport, , "YourTableOrQuery2", "X:\YourOutputFile.xls", True DoCmd.TransferSpreadsheet acExport, , "YourTableOrQuery3", "X:\YourOutputFile.xls", True
regards,
A.K.
On 11/23/2015 3:15 PM, alam.caputra@yahoo.co.id [belajar-access] wrote:


Teman - teman milis....
Ada yang tau caranya untuk mengexport beberapa report dalam access ke satu file excel yang nantinya ada beberapa worksheet
Terima kasih

__._,_.___

---

Posted by: "alam.caputra" <alam.caputra@yahoo.co.id>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

SPAM IS PROHIBITED

Visit Your Group

·                                 New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___