How to export unbound form to excel with all formatting

[markey]

Access 2003
Hello. Hope this makes sense. I have an unbound form with unbound fields/values. This form is a calculator created in vb and I have no tables or queries associated with any of the data entered etc.

When the user enters data into the various fields, I want them to be able to click a button and have the data dump into excel or snapshot, with all of the forms formatting. I can export to excel, but it displays everything (all fields/values) in a vertical line, and no formatting is brought over.

Any comments or suggestions are much appreciated. Thanks

 

[DCrake]

Simple Software Solutions

Hi

I presume you are coping the data from your form to excel on a one to one basis. If so then create a Excel template with all the formatting in it and in code paste the values into the predefined cells in Excel.

A good article on this is explored via the following link. Try this and see if it helps

http://support.microsoft.com/kb/247412/en-us

Code Master

 

[markey]

Re: Thread

Thanks, this looks like it will work and makes a lot of sense, but it also appears to be pretty in depth. Due to the nature of my data, I'd have to code each individual field to export to excel. I'm looking for more of a quick fix.

How about a snapshot? Or, do you know how to print a form at.... lets say, 95% of its original size. Thanks again for your input.

 

[DCrake]

Simple Software Solutions

Hi

When you say you have a lot of data to copy to excel. Don't forget once you have spent that initial time coding it, you have total control of the movement of data and it is a once only exercise. Many problems take a lot of time to resolve but the benefits far outweigh the struggle. It's far easier to stand on the backs of giants than to attempt to reinvent the wheel.

Code Master: