Dynamic Name of the Expoeted File

[#1]

Hi all,

I am exporting a chart to excel using follwing macro.

sub Excel

set obj = ActiveDocument.GetSheetObject("CH01")

"D:\Test\test.xls"

end

sub

But it is storing Name as Test.xls but I need file name as "Test-Var1-Var2.xls)

Where Var1 and Var2 are two variable.

Please help me in storing the file name as said above.

Thanks in advance.