try something like this
if not should get you started in the right direction
Function GetMsAccessPath
maybe this topic will help more
http://www.quickmacros.com/forum/showthr...oft+Access
sorry cannot help more was just trying to get you started in right direction
also search forum for Microsoft Access there are other topics that may help.
in code editor type acApp then . and you will see a list of functions you can do
if not should get you started in the right direction
Function GetMsAccessPath
;/exe 1
typelib Access {4AFFC9A0-5F99-101B-AF4E-00AA003F0F07} 9.0
str sPath
Access.Application acApp
acApp._getactive
sPath = acApp.Run("EmployeeFolderPath")
out sPath
;BEGIN PROJECT
;flags 6
;END PROJECThttp://www.quickmacros.com/forum/showthr...oft+Access
sorry cannot help more was just trying to get you started in right direction
also search forum for Microsoft Access there are other topics that may help.
in code editor type acApp then . and you will see a list of functions you can do