Export List box text to txt file

M

Matt

Howdy all,

I am needing to export the text of an unbound list box that is populated by
a query. I would like it to create a new file in the folder the dbase is
located.

It would be great if it would use the date as the name of the file. ex:
mmddyy.txt

thanks
Matt
 
K

Ken Snell \(MVP\)

Assuming that the list box's Row Source query is a stored query in the
database, use TransferText (macro or VBA code) to export that query to a
text file.
 
M

Matt

Ken Snell (MVP) said:
Assuming that the list box's Row Source query is a stored query in the
database, use TransferText (macro or VBA code) to export that query to a
text file.
Click to expand...

I am not quite following. The contents of the list box is not saved
anywhere. I do not have the list box bound to anything.

matt
 
K

Ken Snell \(MVP\)

What is the listbox's RowSourceType property? What is the listbox's
RowSource property?
 
Top