[AccessD] Excel Macro Automation from within Access

Thanks Darsant.  This option seems feasible, but sounds like a lot of
coding to get it to work by tomorrow.  
I'll have to use a band-aid until I can look into your approach when I
have more time.

Thanks,
Mark Boyd
I/S Supervisor
McBee Associates, Inc.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darsant
Silverstring
Sent: Wednesday, June 01, 2005 2:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Excel Macro Automation from within Access

On 6/1/05, Mark Boyd <MarkBoyd at mcbeeassociates.com> wrote:
> It isn't the column headings that I need to preserve, but the data in 
> the Report Header section, such as titles, sub-titles, etc.
> 
> Mark Boyd
> I/S Supervisor
> McBee Associates, Inc.

Well, you could take the query that the report is feeding from, and pipe
the data through VBA code to export it to excel.

Err, well, it'd be multiple recordsets depending on what you wanted to
format, but you could use do while loops on each recordset to output the
appropriate heading, then output the data, then total the data, then
move onto the next recordset.

With VBA code linking it to excel you can do whatever formatting you
want, but you're going to have to more softcode the output and modify
the macro that you created to work with the Access interface.

In other words, instead of outputting from report format to excel, you
can output from the module itself. More work but allows you 100%
accessability and formating options vs having to correct the
auto-formatting done by report-->excel procedure.

--
Darsant Silverstring 

"Peace cannot be kept by force. It can only be achieved by
understanding."
-Albert Einstein
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
 
-----------------------------------------
This message and any attachments are intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by replying to this message, and then delete it from your system.
-------------------------------------------