[RESOLVED] location/directory of workbook?

[pgag45]

Hey all,

Is there a command to get the full path of the current workbook?

like a Workbook.Location or something?

which would return "C:\test\workbook.xls" ?

thanks much!

[dmaruca]

Workbook.Path

[pgag45]

That doesn't work for me...

do I have to defined Workbook as my current Workbook?

and Application.path returns the MS office folder...

[dmaruca]

The path won't return any data if the workbook hasn't been saved yet. Use ActiveWorkbook if you aren't sure which workbook to reference.

[Hack]

Try

Application.ActiveWorkbook.FullName

[pgag45]

awesome thanks guys

[pgag45]

combined with

Application.ActiveWorkbook.name

get the whole path and file name