Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get info of new filename and new path
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get info of new filename and new path
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get info of new filename and new path
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 "Sheeloo" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
showing path and filename | Excel Worksheet Functions | |||
Pulling in the path to a filename | Excel Worksheet Functions | |||
Filename and path | Excel Programming | |||
Need directory path without filename | Excel Programming |