How to get info of new filename and new path

  • Thread starter Thread starter Makelei
  • Start date Start date
M

Makelei

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
 
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...
 
Thanks Sheeloo,
This is how I did it:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
....
If ActiveWorkbook.Saved Then
FName = ActiveWorkbook.Name
Filename = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
...
Else
...
End if
....
End Sub

BR
MakeLei
 
Back
Top