Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DoCmd.TransferSpreadsheet

Status
Not open for further replies.
Ringers

Ringers

Technical User
Feb 26, 2004
180
AU
I am trying to use DoCmd.TransferSpreadsheet to transfer data from a access 2003 form into a excel 2003 spreadsheet. But my code is not working. I am trying to export to alert.xls and have a series of combo boxes and check boxes i am trying to export from. The form is called medical form but i am not sure if should call it this or me.form.

I have never used this function before so any help would be good, Thanks.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, Me.Form, "C:\Documents and Settings\chicks\My Documents\Alert.xls", [Me.Combo12,Me.Combo14,Me.Combo16,Me.Combo18,Me.Combo18,Me.Combo20,Me.Combo38,Me.Combo40,Me.Combo42,Me.Check22,Me.Check24], , True
 
Sort by date Sort by votes
I think the transferspreadsheet only works with a query or a table not a form. You could make query with the fields you want and then filter the query and export that.

ck1999
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

scotton
  • Locked
  • Question
How do I use DoCmd.TransferSpreadsheet with this code? 1
Replies
8
Views
50
hneal98
hneal98

Part and Inventory Search

Sponsor

Back
Top