Save as excel with date

[jvaneert]

Hi All,
I am a newbie in macro's

I want to save a impromptu report as an excel file and save the date in the filename.
So each day i will have an export with the date in it.

So for example List 1 28 februari.xls, list 2 1st march.xls

Can someone please provide me with some macro code?

Regards and thanks in advance

Jules

 

[DoubleD]

These lines should give you a pretty good idea. You should be able to get the rest from the Cognos Documentation.

strFile = objImpRep.Name & "_" & Format(Date, "Medium Date")

objImpRep.ExportExcel (strFile)

I am what I am based on the decisions I have made.

DoubleD