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!

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

How to send certain records to excel

Status
Not open for further replies.

sabavno

Programmer
Jul 25, 2002
381
CA
Hi

I have a list box of many columns and rows. Rows represent the record. As I go through the selected by user rows, I want to send all selected records to the spreadsheet

Could I first pull off those records, put into something temporarily (file, table, listbox) and then send the whole bulk of pulled records to the excel?
 
Hi,

I would suggest a checkbox. As you go through the records, if you want it to go to excel, check the box. Then, you could either create a query to put those with checks into a table then export the table to excel, or create a query to look for those with the checkbox and export that query to excel.

Lee
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top