Unusual Extract Requirements

B

Bill Sturdevant

I need to export data to an Excel spreadsheet with column
headers. I am using "DoCmd.OutputTo" successfully and
getting the column headers.

BUT, I now have an unusual requirement. I need to export
records and headers as follows in order to product an
Excel spreadsheet to send to another company:

Row 1: Text data in certain cells
Row 2: Blank
Row 3: Column Headers
Row 4: Text data in certain cells
Row 5 and subsequent rows: the data being extracted.

What is the best way to accomplish this?
 

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

Need Help with a VBA subroutine 0
Cell data entering slow! 0
Dealing with a Pivot Table (when I don't want to) 0
Merging from an Excel file with graphics 1
convert columns to rows 6
Excel does not accept text format! 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
column header problem when exporting -- need # character 3

Top