Exporting a file as excel within a macro

[Guest_imported]

I am trying to use a macro to export an impromptu v6 report as an excel file. I can get the code to work for exporting as a PDF format but not as excel.

Here is the code I am using.

DestPDFName = "d:\test\test.xls"
objImpRep.ExportExcel DestPDFName

It reports
test2!SendMe(54) - R91 "Object value is set to Nothing"

Any help please

Paul

 

[bearywell]

This is a piece of the code we use for a macro button. I am not sure if it what you are looking for but...hope it helps.

Set ImpRep=ImpApp.OpenReport("z:\biweekly\PT w vac sick pay.imr&quot
ImpRep.ExportExcel("z:\biweekly\PTw vac sick pay.xls&quot
ImpRep.CloseReport

 

[PaulKempo]

Thanks very I have now managed to sort it out.

Thanks

Paul

 

[griffindm]

There are actually two type of "Save As Excel" export. The one mentioned above gives you a raw export of each data element in the query. The other option, new in Impromptu 6 allows a WYSIWYG export (for the most part - page headers and footer do not export). Unfortunately, their is no API macro call for the second type, but you can call it using SENDKEYS to emulate keyboard menu selection.

Regards,

Dave Griffin