Excel Macro

[Dar]

Can I copy the code from an Excel macro and insert it into an Access module
and run the code from Access?

 

[Arvin Meyer [MVP]]

Can I copy the code from an Excel macro and insert it into an Access
module
and run the code from Access?

Yes, but you'll need either a reference to the Excel Object library and
early binding code, or late binding code with the Excel automation object.
Here's some late bound code as an example:

http://www.mvps.org/access/modules/mdl0006.htm