What is the Pathname Variable?

[Rougy]

Hi,

I'm writing a macro that will include the pathname with the filename, but I forgot what the pathname variable is.

Date = &D

Path = ??

Filename = &F

I used to know what it was, but can't find it now in Excell Help.

Thanks.

-----
The death of dogma is the birth of reason.

 

[Rougy]

This seems to be working:

dim vFileName as string

vFileName = ActiveWorkbook.FullName

-----
The death of dogma is the birth of reason.

 

[JamieDeVry]

PathName is not a variable. It is a property of the workbooks object collection and it is used to return the path anf file name of the workbook in question. for example:

sub mcrTest
Dim strPath as string

strPath = activeworkbook.pathname

msgbox strPath

end sub

Jamie 'DeVry'

 

[JamieDeVry]

... use PathName to return the directory location of the workbook, use the name property to return the name of the workbook, use the FullName property to return the path and name of the workbook.

Jamie