Export Report to Excel without Date() and Time()

[agent-]

Hello,



I need to be able to Export a report to Excel with only the detail section being exported. The header is also being exported for two Text boxes that have Date() and Time() as control source. There are no labels for these boxes and they are still being exported to Excel. Is there anyway to disable them from being exported?

If not I will have to create the queries and write the VBA to export that to excel, but if this is possible it would help a lot.

Thanks!!

[June7]

You are using the Export dialog? Is there other data in the header you do want? If not, what happens if the header is set to not visible?

[agent-]

Yes I am using Export dialog.

There is no data in header that I want. In addition, when it is NOT visible, it still exports to Excel

[June7]

Then I guess query is the only way to restrict what goes. Export the query by the dialog or VBA.

[agent-]

Yeah that is what I decided to set up also. Seems strange that it was auto pulling the date/time from the header but NOT from the footer.

[CGM3]

Actually, it seems to be more extensive than that.

I'm designing a report that will be exported to Excel, and which has all of its Display data in text boxes arranged in a single row across the sheet (so the report gives a simple matrix with each record on a different row.) Most of these text boxes use formulae to display data in the desired format (for instance, the txtInclude field reads Included if the Include Boolean field in the table is True, otherwise it reads Excluded.)

When I export the report to an Excel spreadsheet, the first row of the sheet holds the name of the corresponding text box in the Detail display, even the ones that don't have a formula, with the remaining rows holding the expected record values. Thus, the column with the Include field data has txtInclude on row 1, with Included or Excluded in the rows beneath it.

I can go with a query, but it would be nice to know how (if possible) to suppress this, uhm, "undocumented feature." (Because we all know Microsoft applications just don't have bugs! )