Re: Exporting Data Into Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

On 5 Sep, 15:17, "Roger Carlson" <RogerCarl...@xxxxxxxxxxxxxxx> wrote:
Well, the purpose of the sample (as with all of my samples) is to give you a
working model that you can dissect. Take the time to figure out exactly
what is happening with my sample before you try to implement it in your
database. If you have specific questions about why it's doing certain
things, feel free to ask.

--
--Roger Carlson
MS Access MVP
Access Database Samples:www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

<AshP...@xxxxxxxxx> wrote in message

news:1188992336.292917.58700@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On 4 Sep, 17:32, "Roger Carlson" <RogerCarl...@xxxxxxxxxxxxxxx> wrote:
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportToExcel.mdb" which might give you some help.

--
--Roger Carlson
MS Access MVP
Access Database Samples:www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

<AshP...@xxxxxxxxx> wrote in message

news:1188807836.013643.79420@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi,

I am currently trying to export data from one of my forms to excel. I
know you can export to excel using macros and vb but i have noticed
that access gives the option to exprot to excel using a template.

How would i create a excel template?

Please reply and any advice is much appreciated

Many Thanks,

Ashley Parr- Hide quoted text -

- Show quoted text -

i have tried this and it works in the sample database you set up, but
as soon as i try to use it in mine i get alot of errors, it says
something along the lines of i havnt defined exportspread***.

any help would be good thanks- Hide quoted text -

- Show quoted text -

Thanks for the reply, but i did download your sample and open it up.

I looked at what it did and how it works and modified it to show data
in a different template and that worked great, but now when im trying
to implent it into my database it doesnt like some of the lines.

One of the errors i get is: "Compile Error: Userdefined type not
defined"
with "Set objXLApp = New Excel.Application" highlighted

I also had the same problem with defining objXLApp, so i changed the
code to:

Dim objXLBook As Object
Set objXLBook As Excel.WorkBook

then this part was fine, was this right to do or not?

.

Quantcast