Access to Excel Macro

  • Thread starter Thread starter Josh E
  • Start date Start date
J

Josh E

Hi,

I have created a database in Access to handle financial information, and
I need to produce reports that extract my query results from Access into
Excel.

I need to create one file in Excel that will have buttons so when I pass
this to another person, they can easily extract the Balance Sheets,
Income Statements, etc. I am going to do this by creating a macro that
imports the query through Excel, and then formats it to look like a
Balance Sheet. Is there any easier process to do this, or is this the
best approach? I need to sure the end-user has minimum work to do in
order to generate a new Balance Sheet.
 
Is it simple enough of a situation to have an AutoOpen macro:

Private Sub Workbook_Open()

If Not_Already_Formatted_As_Balance_Sheet then
Call FormatAsBalanceSheet
End if
 
Back
Top