the reason your getting the cannot find the procedure 'EmployeeFolderPath().'. error message is because
Your calling the function incorrectly
change code to and will work
and it will work
full code below
Tip
Q. How to post QM code to the forum?
A. In QM, to copy all or selected text, use menu Edit -> Other Formats -> Copy for QM Forum. It copies correct and colored code to the clipboard. Then simply paste in the forum. Don't use the Code button.
read more here
http://www.quickmacros.com/forum/showthread.php?tid=786
Your calling the function incorrectly
change code to and will work
and it will work
full code below
;/exe 1
typelib Access {4AFFC9A0-5F99-101B-AF4E-00AA003F0F07} 9.0
str sPath
Access.Application acApp
acApp._getactive
;acApp._getfile("C:\Users\kevin\Documents\Database1.accdb")
sPath = acApp.Run("EmployeeFolderPath")
out sPath
;BEGIN PROJECT
;;flags 6
;END PROJECTTip
Q. How to post QM code to the forum?
A. In QM, to copy all or selected text, use menu Edit -> Other Formats -> Copy for QM Forum. It copies correct and colored code to the clipboard. Then simply paste in the forum. Don't use the Code button.
read more here
http://www.quickmacros.com/forum/showthread.php?tid=786