And you may want to use & instead of +.

+'s are used to add numbers.
&'s are used to concatenate strings.

But excel's VBA is forgiving.

ActiveWorkbook.Path & "\" & ActiveWorkbook.Name

or even:
Activeworkbook.fullname
or
ThisWorkbook.fullname



md wrote:

On Mar 28, 8:46 pm, md wrote:
I running a vba script inside a workbook. How do I get the complete
path to the workbook and name in which this script runs?

Thanks

ActiveWorkbook.Path + '\' + ActiveWorkbook.Name (that was easy)

--

Dave Peterson