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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy and paste form data to Excel

Status
Not open for further replies.
tekkyun

tekkyun

Technical User
Oct 23, 2003
122
GB
Can anyone give me clue how I might code the 'copy and paste' elements for the following procedure?

Open instance of excel
For subform 1 to n
Open subform
Select and copy subform data to clipboard
Paste data into next free excel Sheet rows
Close subform
Next subform

Close instance of excel
 
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
783
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
535
renigar
renigar
TrekBiker
  • Locked
  • Question
Sending data to Excel 1
Replies
2
Views
329
TrekBiker
TrekBiker
I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
754
hermanlaksko
hermanlaksko

Part and Inventory Search

Sponsor

Back
Top