export specific fields from report to excel

  • Thread starter Thread starter cutthroatjess
  • Start date Start date
C

cutthroatjess

I have a report that has some fields that are visible and some that aren't.
When I export the report to an excel spreadsheet, I would like all fields to
export and be visible. Is there a way to do this?

Thanks!

Jesse
 
Jesse

Have you tried generating a report that displays all the fields you'd like
to see in Excel?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Yes,
I have a report that has all the fields that I want. However, I had a
request to repeat one of the fields at the end of the list (due to length)
similar to a frozen column in excel.
I was able to simply copy the field in the report and then make the visible
property = false. Now, I'm trying to turn the visible property to true when I
export the report to excel and do so programatically I suppose.

Thanks!
Jesse
 
Jesse

I have no experience doing something like that, so maybe other newsgroup
readers can offer their ideas.

If I had to come up with a way to do this, it seems to me I'd have to first
open the report in design view and modify the .Visible property, then run
the report, then export to Excel, then close the report, then open the
report in design view again and re-set the .Visible property of that field.

Seems like a lot of work, for something that you could do once the data was
in Excel by copy/paste.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
OK,

I think what I'll do is since the report used a query. I'll use another
query that sets the field order that I want and export it that way.

Thanks for your help!

Jesse
 
Back
Top