recordsets and excel (1 Viewer)

P

pb21

Registered User.

Local time

Today, 13:23

Joined

Nov 2, 2004

Messages

122

• Feb 10, 2005

• #1

I want to export the data from a recordset, create a new spreadsheet from an excel template and then put the recordset data into the spreadsheet and I am not sure how to go about this.

advice would be welcome as to the methods available.

regards
Peter

 

R

Rob.Mills

Registered User.

Local time

Today, 08:23

Joined

Aug 29, 2002

Messages

871

• Feb 10, 2005

• #2

Will Docmd.Outputto not suffice?

 

P

pb21

Registered User.

Local time

Today, 13:23

Joined

Nov 2, 2004

Messages

122

• Feb 10, 2005

• #3

docmd.outputto

I am not familiar with that method but it doesnt look hopeful as i will need to put the data into certain cells in the template.

 

P

pb21

Registered User.

Local time

Today, 13:23

Joined

Nov 2, 2004

Messages

122

• Feb 10, 2005

• #4

getobject

I have opened the existing spreadsheet with :

Dim auditspreadsheet As Object

Set auditspreadsheet = GetObject("c:\Audit.xls")

The spreadsheet has macros in it and its asking if i want to run them can i turn them off in vba so it doesnt ask? I dont need the excel macros I only want to now add data into the spreadsheet.

regards