Export to Excel in same path its save it

[angelaecheverri]

Hi

Does anyone knows how can i export a chart to excel and save it in the same path is my application?

I am using this macro....

sub Export

set obj = ActiveDocument.GetSheetObject("CH45")

obj.ExportEx "C:\Users\Angela\Documents\01 Empresas\02 En Curso\08 Fundacion Santa Fe\03 Modelos\Cartera x Edades\ABC_Historico.xls", 5

End Sub

but .... in this way i must to write a path...

i would like this path will be the place is save my application....

any clue?

thanks

Angela E