I am trying to create a macro that will open a query, refresh it, export it to an excel spreadsheet, save it and close it. Everything seems to work except for the export to excel. When I review the reportscript there is no code referencing the export.
What do I need to do to include the export in the macro?
Rob
Pearson Education
Listserv Archives (BOB member since 2002-06-25)
d{095}exch/O=pearsontc/PRMD=pearson/ADMD=telemail/C=us/"@MHS> Mime-Version: 1.0
Rob
You will need to use the dataprovider.converto function to convert to excel format.
Example:
set dp = ActiveDocument.DataProviders.Item(1) call dp.ConvertTo (ExpExcel,1,“E:\Test_reports\Details”)
Mike McErlain
At 11:37 AM 3/8/2000 -0500, you wrote:
I am trying to create a macro that will open a query, refresh it,
export it to an excel spreadsheet, save it and
close it. Everything seems to work except for the export to excel.
When I review the reportscript there is
no code referencing the export.
What do I need to do to include the export in the macro?
Rob
Pearson Education
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’ Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
Listserv Archives (BOB member since 2002-06-25)