Access to Excel Macro
 

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.



*** Sent via Developersdex http://www.developersdex.com ***

Access to Excel Macro
 

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



"Josh E" wrote:

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.



*** Sent via Developersdex http://www.developersdex.com ***