I am running a query, and exporting it to excel. A few of the fields have dates, and one is a memo field. When I export it to excel, the dates show up as hash marks. If I resize the field in excel, the dates appear. Also some of the memo fields wrap and the cell expands to show the multiple lines,and other times it doesn't. I was wondering if there was a way for me to tell excel to resize properly so my users don't have to?
Dan, I have looked at the example, put the code in just like it was*, and I get an error. It says that " Dim exApp As Excel.Application" is not defined. From what I can tell, all that is is a var decloration.