J
Jerry Khann
Hello,
With Excel 2007,
I have a macro in PERSONAL.XLSB witch I start with
a button in Quick Access toolbar
***
Sub MyFastSave()
NomDuFichierFinal = "PourVoir.xls"
NomAProposer = "D:\A_Sauver\" & NomDuFichierFinal
etat = Application.Dialogs(xlDialogSaveAs).Show(NomAProposer, xlExcel8)
If etat = True Then
NomApres = ActiveWorkbook.FullName
MsgBox ("The save in Excel 2003 format of " & NomApres & " is
good.")
End If
End Sub
***
If I execute this macro when I had create a new file, the dialog box
is OK with the good path, good file name and good file format.
But if I execute this macro when I had open an existing file by "double
clic"
on the file name in his folder, the dialog box is KO (bad): good file name
and
good file format, but the path is wrong (the original one of the file).
Nothing could change this?
Could you help me, or is it a bug?
Thank's in advance
Regards
***
Sorry for my english: it isn't my native language.
With Excel 2007,
I have a macro in PERSONAL.XLSB witch I start with
a button in Quick Access toolbar
***
Sub MyFastSave()
NomDuFichierFinal = "PourVoir.xls"
NomAProposer = "D:\A_Sauver\" & NomDuFichierFinal
etat = Application.Dialogs(xlDialogSaveAs).Show(NomAProposer, xlExcel8)
If etat = True Then
NomApres = ActiveWorkbook.FullName
MsgBox ("The save in Excel 2003 format of " & NomApres & " is
good.")
End If
End Sub
***
If I execute this macro when I had create a new file, the dialog box
is OK with the good path, good file name and good file format.
But if I execute this macro when I had open an existing file by "double
clic"
on the file name in his folder, the dialog box is KO (bad): good file name
and
good file format, but the path is wrong (the original one of the file).
Nothing could change this?
Could you help me, or is it a bug?
Thank's in advance
Regards
***
Sorry for my english: it isn't my native language.