Dim sPath as String
sPath = ActiveWorkbook.Path
msgbox sPath

sPath will then hold a string that contains the activeworkbook path.

If by specify, you mean you are trying to change it, that can only be done
with a SaveAs .

--
Regards,
Tom Ogilvy



"Grandad" wrote in message
...
Hi

I need to specify the path of the ActiveWorkbook so that it can be used
later in my code.

I have tried something like "ActiveWorkbook = ActiveWorkbook.Path" but I'm
only guessing, can anyone help with the correct code please.

--
Kind Regards

Mick