Export Formatted Report To Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a report with very little human intervention. Is it
possible to add the VBA code in Access to format the excel spreadsheet and
transfer it to excel or do I transfer the data to excel and then code the
Formatting statements with Excel. I am just trying to figure out if this a
1 step process where I code everything in access or must I do some coding in
Excel to achieve the desired format. I would like to set this up to execute
automatically from the windows task scheduler.
 
Regarding the first question, you can code Excel formatting from Access.
You have at least a couple alternatives here. You can export an Access
report to Excel, or you can simply export a query or table to Excel.
Depending on exactly what you are trying to accomplish, exporting a report
may take care of some of the formatting, leaving you with less formatting
code to write. In either case, you can then open the workbook containing
the exported report or query (or table) through code and apply the
appropriate formatting.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I would like to create a report with very little human intervention. Is it
possible to add the VBA code in Access to format the excel spreadsheet and
transfer it to excel or do I transfer the data to excel and then code the
Formatting statements with Excel. I am just trying to figure out if this a
1 step process where I code everything in access or must I do some coding in
Excel to achieve the desired format. I would like to set this up to
execute
automatically from the windows task scheduler.
 
Back
Top