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

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)

You may want to consider using ThisWorkbook if the workbook with the macro is
not the active workbook.
--
HTH,
Barb Reinhardt



"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)

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