Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-10-2005, 10:14 AM   #1
pb21
Registered User
 
Join Date: Nov 2004
Posts: 122
Thanks: 0
Thanked 0 Times in 0 Posts
pb21 is an unknown quantity at this point
recordsets and excel

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

pb21 is offline   Reply With Quote
Old 02-10-2005, 10:23 AM   #2
Rob.Mills
Registered User
 
Join Date: Aug 2002
Location: Raleigh, NC USA
Posts: 871
Thanks: 0
Thanked 1 Time in 1 Post
Rob.Mills
Will Docmd.Outputto not suffice?
Rob.Mills is offline   Reply With Quote
Old 02-10-2005, 10:55 AM   #3
pb21
Registered User
 
Join Date: Nov 2004
Posts: 122
Thanks: 0
Thanked 0 Times in 0 Posts
pb21 is an unknown quantity at this point
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.

pb21 is offline   Reply With Quote
Old 02-10-2005, 11:12 AM   #4
pb21
Registered User
 
Join Date: Nov 2004
Posts: 122
Thanks: 0
Thanked 0 Times in 0 Posts
pb21 is an unknown quantity at this point
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

pb21 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 07:36 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World