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(NomAPropo ser, 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.

--
Jerry Khann

Adresse invalide: retirer le bouchon _O_ et .invalid