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!!!!!!!!!

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!

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

Thanks!

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

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!