Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 26th, 2007, 02:47 AM
Authorized User
 
Join Date: Mar 2006
Posts: 83
Thanks: 1
Thanked 0 Times in 0 Posts
Default Autoformatting Reports Exported to Excel

Hiya folks!

Just wondering if it is possible to format reports that are exported from Access to Excel. Lets say I have a list of clients in the report. And when it is exported to Excel, I want that column in Excel that displays the client name to have a specific width, use a specific font, font size, colour, maybe a border or fill colour, etc.

Is this possible? And if so....how?!

Thanks!!!!!!!!!

 
Old April 26th, 2007, 05:03 AM
Authorized User
 
Join Date: Mar 2006
Posts: 83
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Or maybe... another option... what if I already had an Excel worksheet already formatted the way I want to... but just to transfer the report data or values from Access?

Thanks!

 
Old May 3rd, 2007, 06:00 AM
Authorized User
 
Join Date: Mar 2006
Posts: 83
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hiya folks... I guess this is a tough one.. anyone know where I might be able to get some help on this issue?

Thanks!
 
Old May 6th, 2007, 08:43 PM
Registered User
 
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

you can use Paste special to resolve it. ok m thary hacker in cambodia.

 
Old May 14th, 2007, 06:54 AM
Authorized User
 
Join Date: Mar 2006
Posts: 83
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Okay folks! I found the solution! It took a while but it works like this....

First create the database with a report that contains the data that you want to export.

Then create an Excel sheet where you want to have the data from the Access report copied into.

You will then have to create two macros...one in Access... and another one in Excel.

The one in Access will export the report to a temporary Excel file and then automatically open the main Excel file (not the temporary one).

Once the Excel file opens... it automatically runs a macro that opens the temporary file, copies the data from the specified range, closes the temporary file, and pastes (using the Paste Special feature mentioned by Camproma) the data into the main Excel sheet.

Soooooooooooooooooooooooo if you want more info on this, please let me know!






Similar Threads
Thread Thread Starter Forum Replies Last Post
Reports in excel using jasper mohanasrini J2EE 1 July 1st, 2009 11:15 AM
How to set password to exported Crystal Report jdaulagar Beginning VB 6 0 January 10th, 2007 04:19 PM
Exported Access Parameter Queries to Excel vallasca Access VBA 4 January 19th, 2005 07:34 PM
Crystal Reports From Excel timjoe1234 Crystal Reports 1 June 9th, 2004 11:35 PM
Generating Excel Reports athanatos ASP.NET 1.0 and 1.1 Basics 1 August 19th, 2003 01:53 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.