Rusty Hammond
rusty.hammond at cpiqpc.com
Wed Sep 15 23:46:51 CDT 2010
I don't suppose exporting it to an rtf file would work for the client. Most of the formatting would remain intact. Rusty -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Wednesday, September 15, 2010 11:37 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Creating a Spreadsheet from a Report I think you're right. But it's a lot of nit-picky code to make a complex report look right in Excel. Just looking for a way to avoid work. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, September 15, 2010 6:12 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Creating a Spreadsheet from a Report Excel automation is probably the way to go. You can export named ranges, run code out in the spreadsheet to perform formatting etc. John W. Colby www.ColbyConsulting.com On 9/15/2010 8:03 PM, Rocky Smolin wrote: > Thanks. Gotta think about this approach. > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl > Collins > Sent: Wednesday, September 15, 2010 4:55 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Creating a Spreadsheet from a Report > > > ______________________________________________________________________ > ______ > ___________ > > Note: This e-mail is subject to the disclaimer contained at the bottom > of this message. > ______________________________________________________________________ > ______ > ___________ > > > > > Rocky, > > Easiest way is to use a template which has the report already laid out > on it. Then you need to have some hidden helper sheets > > One (or more sheets) you dump the access / database data into either > via a view / query / table. This will give you the data you need to > make the report. Often this can only be a few lines depending on the > complexity of the outcomes. > > Then you write code in the template that pull the data from the hidden > helper sheets and populates the report. > > Another more useful way is this. > > Create an Excel workbook with hooks into your database. This way the > user can update the report 'live' and any database changes are > immediately pulled into the XL report. You can even have the user > changes in Excel feed back into the database if you want, although I > rarely do this. Generally I have Excel as a 'read only' report. > > You can then write code in Excel to create a 'stand alone' report for > emailing etc. You want the users to do this, rather than emailing the > live version, which will fail once it cannot talk to the database > anymore. It also stops folks for stuffing up the data. > > If you need examples, email me offist and I will send you a couple of > workbooks I have that do exactly this. > > Regards > Darryl. > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky > Smolin > Sent: Thursday, 16 September 2010 7:10 AM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] Creating a Spreadsheet from a Report > > Dear List: > > I have a client who wants one of the reports in my app to be exported > as a spreadsheet. But nota flat file. She wants the spreadsheet to > look like the report - header line, details with their own fields > headings, plus two other sub reports. > > I've done this with other reports on a cell by cell basis where the > Transfer method won't work. Big PITA. Is there an easier way to do this? > > > > MTIA > > Rocky > > > > ______________________________________________________________________ > ______ > ___________ > > The information transmitted in this message and its attachments (if > any) is intended only for the person or entity to which it is addressed. > The message may contain confidential and/or privileged material. Any > review, retransmission, dissemination or other use of, or taking of > any action in reliance upon this information, by persons or entities > other than the intended recipient is prohibited. > > If you have received this in error, please contact the sender and > delete this e-mail and associated material from any computer. > > The intended recipient of this e-mail may only use, reproduce, > disclose or distribute the information contained in this e-mail and > any attached files, with the permission of the sender. > > This message has been scanned for viruses. > ______________________________________________________________________ > ______ > ___________ > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. **********************************************************************