PDA

View Full Version : Finding the Folder that the working file is in



Maurice
04-11-2007, 01:24 PM
HELP !
I would like to get the workbook containing the vba code to find out the folder that it is in and the path to it so that I don't have to store multiple paths for different users. I would be very grateful for a clue as I have been on a cicular tour so far. The FileSearch method is not available to me because the version of office is a non-commercial one.
Thank you in anticipation.

Bob Phillips
04-11-2007, 02:03 PM
Activeworkbook.Path

Maurice
04-12-2007, 07:41 AM
Can an answer possibly be that short? I'm flabbergasted. Thank you very much indeed, I will try it Pronto and I will now search for the smilie for Solved :thumb

lucas
04-12-2007, 08:38 AM
For solved...use the thread tools at the top of the page.