Hello, I have a VBA macro and when it runs I would like to find out the file name that the macro resides in. I can't use ActiveProject as the file may not be the active one at the time. I can hardcode a name in there but as my versions increase I may forget to update the version number in the code. Thanks
Hi, ThisProject.fullname HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional +32 495 300 620 For availability check: http://users.online.be/prom-ade/Calendar.pdf "Gilgamesh" wrote in message news:e9kgWlSJJHA.1160@TK2MSFTNGP05.phx.gbl... > Hello, > I have a VBA macro and when it runs I would like to find out the file name > that the macro resides in. > I can't use ActiveProject as the file may not be the active one at the > time. > I can hardcode a name in there but as my versions increase I may forget to > update the version number in the code. > > Thanks >
