create excel file with embeded macro using Access

[Dharmesh Patel]

Hi,
I have an access application that gathers data from various production databases and creates an excel spreadsheet full of new prices of various products and automatially e-mails the excel files to various sales managers.

I now need to be able to embed a macro in the excel files which when run by the sales manager, will filter the product (in column A) by product type and print all products for product type A.

I ca do all these seperately however i need to be able to create the macro when I create the excel file, using access.

In short I need to know how to create an excel macro using MSAccess.

Many Thanks

Kind Regards
D

 

[Joe4]

Duplicate:
http://www.mrexcel.com/forum/showthread.php?t=537806

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted:
http://www.mrexcel.com/forum/showthread.php?t=127080