Analyze it with Microsoft Excel

[ccoffelt]

I just completed a report for my boss and he wants to export it into Excel so that he can manipulate the data some more. When we use the Analyze it with Excel option it does not carry over the Label Name. Instead it says Text 4, etc.

Example:
Text4 Text73 Text75
Plant 701 OPR-012 402

We want the label to carry over as well:
Dept Name Machine Dept#
Plant 701 OPR-012 402

In the label properties I have it like so:
nameeptName_Label etc.,
caption: DeptName

Did I miss something simple? Any ideas as to how to get this to work?

 

[Remou]

What are the textboxes called?

 

[ccoffelt]

Yeah it was a Id 10 T error. I went back earlier today and realized I hadn't named them duh. New to this stuff. Thanks for replying.

 

[Remou]