T teabags Registered User. Local time Today, 00:41 Joined Jun 29, 2006 Messages 21 Jul 3, 2006 #1 How do export an Access report to excel?
B bigstav Registered User. Local time Today, 08:41 Joined Jul 6, 2006 Messages 20 Jul 6, 2006 #2 Report to Excel Try this Code from a Button :- DoCmd.OutputTo acReport, "ReportName", "MicrosoftExcel(*.xls)", "C:\TEST.XLS", False, ""
Report to Excel Try this Code from a Button :- DoCmd.OutputTo acReport, "ReportName", "MicrosoftExcel(*.xls)", "C:\TEST.XLS", False, ""
A AccessWater Registered User. Local time Today, 03:41 Joined Jun 14, 2006 Messages 52 Aug 2, 2006 #3 Hi, bigstav, I usually distribute my access to several users. If I want to export the report to Excel to user's desktop, how to set up the path for that? Thank you for your help.
Hi, bigstav, I usually distribute my access to several users. If I want to export the report to Excel to user's desktop, how to set up the path for that? Thank you for your help.
A Adeptus What's this button do? Local time Today, 17:11 Joined Aug 2, 2006 Messages 300 Aug 3, 2006 #4 Replace Code: "C:\TEST.XLS" with Code: Environ("Userprofile") & "\Desktop" (assuming you're using an English-language version of Windows)
Replace Code: "C:\TEST.XLS" with Code: Environ("Userprofile") & "\Desktop" (assuming you're using an English-language version of Windows)
A AccessWater Registered User. Local time Today, 03:41 Joined Jun 14, 2006 Messages 52 Aug 3, 2006 #5 Thank you very much. Adeptus. It works great.
