Export A2K2 Report to Excel and change some rows all from within E

W

Winston

I am using the following to output an A2K2 Report to a simple Excel SS

DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, stOutPutName

What I want to do is Open the XLS file, Delete Row 1 change the font and then save as a simple txt file. Using acFormatTXT seems to skip a few rows. Regardless, my intent is to do this from within A2K2.

Is it possible? If no one knows, can someone point me in the correct direction?

Thanks
Winston
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export report to excel ERROR - please help 3
Report export issue 2
Export as txt truncates after office updates 0
Exporting a Report to Excel 2
Export of a report as Snapshot or EXCEL-File 0
Export Report as csv format? 4
Exporting from Access2000 query to Excel2000 template file 9
Controlling MS Excel 97 from Access 97 (Using VBA) 0

Top