Exporting to Excel

J

James G.

Hi,
I've got this working there are just a couple little things i want to put in
place so this works properly. It is based on a query rather than a table.

1. I have an address field that is exported. When opened in Excel it
contains unwanted characters such as boxes. Is there a way of eliminating
this?

2 I want the spreadsheet to be opened automatically when it has been
created. What code do i require to make this possible?

Thanks

James
 
Top