Dec 16, 2003 #1 tfoulkes Technical User Joined Dec 5, 2003 Messages 17 Location GB Hi all, I've got a list box returning values in two columns. I want to export this data to Excel to create charts etc. I was wondering if anybody had any advice on how to do this? Thanks Tim
Hi all, I've got a list box returning values in two columns. I want to export this data to Excel to create charts etc. I was wondering if anybody had any advice on how to do this? Thanks Tim
Dec 16, 2003 #2 dyarwood Programmer Joined Nov 3, 2003 Messages 1,483 Location GB If the data is in a table the export it using DoCmd.TransferSpreadsheet dyarwood Upvote 0 Downvote
Dec 16, 2003 #3 ggriffit Programmer Joined Oct 25, 2002 Messages 1,578 Location GB check out http://www.greggriffiths.org/webdev/both/excel/ although the main focus is Excel via the web, some of the code and the links may assist. Upvote 0 Downvote
check out http://www.greggriffiths.org/webdev/both/excel/ although the main focus is Excel via the web, some of the code and the links may assist.
Dec 16, 2003 Thread starter #4 tfoulkes Technical User Joined Dec 5, 2003 Messages 17 Location GB Unfortunately it's not in a table. The data is in a list box and is generated from VB code. It is the result of a search which all works fine. I've had a really good crack at this and can't work it out. Ta! Upvote 0 Downvote
Unfortunately it's not in a table. The data is in a list box and is generated from VB code. It is the result of a search which all works fine. I've had a really good crack at this and can't work it out. Ta!
Dec 16, 2003 Thread starter #5 tfoulkes Technical User Joined Dec 5, 2003 Messages 17 Location GB thanks ggriffit, thats quite handy. Tim Upvote 0 Downvote