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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Export BPMN Visio Chart to Excel 0
Excel --> Word 4
Solved Disk Full error message when exporting PDF 0
Add additional information to excel form after original data entry 0
Integrating information from Word to Excel (not mail merge) 1
Excel - Wich Function should I use? 1
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0

Top