Access to Excel Macro

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top