Can someone tell me if it is possible to import or link an existing macro in an Excel file to an Access 2010 database? If so, any direction on how to go about accomplishing this?
Thanks kindly.
sren
Can someone tell me if it is possible to import or link an existing macro in an Excel file to an Access 2010 database? If so, any direction on how to go about accomplishing this?
Thanks kindly.
sren
You want to execute an Excel macro from Access?
Macros in Excel are really VBA procedures (macros in Access are very different).
Google: Access run Excel macro
Does this help http://www.ehow.com/how_4595711_run-...el-access.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yes, I want to link to an Excel file and run the macro (in Excel but from within the database)....if that makes sense.
What you have shared is very helpful! Thanks so much.