Solved: Export Listbox to New Excel Spreadsheet

[boneKrusher]

Hi All,

Does anyone have a code to Export Listbox values to New Excel Spreadsheet?

I put together a simple form which reads the contents of folders, loads them to a list box and now I want to export the values to an excel spreadsheet.

Thank for the help!

Bones

[lucas]

Pete has a kb entry that sounds like what your looking for:
http://vbaexpress.com/kb/getarticle.php?kb_id=837

Sorry bones I didn't realize this was in the access forum but maybe this will give you some ideas.

[boneKrusher]

How nice is that! Thanks its perfect