View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh E Josh E is offline
external usenet poster
 
Posts: 3
Default 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 ***