April 2006
Beginner
1114 pages
98h 16m
English
workbook.Path
Returns the path of the workbook. This property is useful for locating other files in the workbook’s folder. For example, the following code lists all the workbooks in the current workbook’s folder:
fname = Dir(ThisWorkbook.Path & "\*.xls")
Do While fname <> ""
Debug.Print fname
fname = Dir( )
LoopRead now
Unlock full access