Execute code from other MS Office Products

[Guest]

I've used the following to execute a procedure in the module of one form from
a different form:

Forms!frmName.ProcedureName

How would I execute the same procedure (in Access) from Word or Excel or
PowerPoint?

Thanks,
sjw

 

[Douglas J. Steele]

You'd have to use Automation.

See whether
http://msdn.microsoft.com/library/en-us/modcore/html/deovrWorkingWithOfficeApplications.asp
is enough to get you going.

 

[Guest]

Thanks, just what I needed!

You'd have to use Automation.

See whether
http://msdn.microsoft.com/library/en-us/modcore/html/deovrWorkingWithOfficeApplications.asp
is enough to get you going.