workbook save location before save - Excel 2002

[christhedonstar]

Hi,

Is there a way to get the path where the user chose to save the workbook?

Thanks,

Chris

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
dim wbPath as string

wbPath = ????

End Sub

Cheers,

Chris

 

[bubba100]

What happens with wbPath=Activeworkbook.Path

 

[christhedonstar]

Actually the dialogue of where the user wants to save comes up after the the beforesave event . I don't see an aftersave event handler

 

[SkipVought]

Hi,

What do you intend to do with this value?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}