Thanks Duane! I'll check it out.
Doyce
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> Doyce,
>
> The best answer to the Automation is to search Bing on "automation Excel from Access". You can basically open the Excel file from code in Access and do whatever you want to the file. There are tons of code samples plus you can use the macro recorder in Excel to write crappy code which can be modified and pasted into an Access module.
>
> Duane Hookom MVP
> MS Access
>
>
> ----------------------------------------
> > To: MS_Access_Professionals@yahoogroups.com
> > From: winberry.doyce@...
> > Date: Mon, 8 Jul 2013 11:56:06 -0700
> > Subject: RE: [MS_AccessPros] Transfer to spreadsheet totals
> >
> > Duane,
> >
> > A union query is a good idea and easy. I'm interested in what you mean by Automation though. Could you explain?
> >
> > Doyce
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
> > Sent: Monday, July 08, 2013 1:46 PM
> > To: Access Professionals Yahoo Group
> > Subject: RE: [MS_AccessPros] Transfer to spreadsheet totals
> >
> >
> >
> > You could use a union query that adds a totals record to the bottom. Automation is another solution.
> >
> > Duane Hookom MVP
> > MS Access
> >
> > ----------------------------------------
> >> To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>
> >> From: winberry.doyce@...<mailto:winberry.doyce%40roadsysinc.com>
> >> Date: Mon, 8 Jul 2013 17:11:34 +0000
> >> Subject: [MS_AccessPros] Transfer to spreadsheet totals
> >>
> >> Hello friends,
> >>
> >> I'm transferring data from a query to Excel. Is there an easy way to get totals at the bottom of the columns that are numerical without opening the spreadsheet after the fact and adding them manually? I'm using Access 2010.
> >>
> >> Doyce
> >>
> >>
> >>
> >> ------------------------------------
> >>
> >> Yahoo! Groups Links
> >>
> >>
> >>
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar