Do you want it before or after the user has saved the current file to a new
name in a new directory?

I don't think you can get it BEFORE... as there is no BEFORE till the user
makes a choice...

You can get it using Cell formula and then you can do whatever you want with
it...
rename, delete the new name etc...

"Makelei" wrote:

Hi,
I have tried to figure out how can I get information on
a) New file name that user wants to save the current file with
b) Path to new location that user wants to save the file

I havve used:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

But I am stuck. I am able to get the current name and path, but that is not
what I need... Please, help me.
Thanks in advance
Makelei