Export List box text to txt file

  • Thread starter Thread starter Matt
  • Start date Start date
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
 
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.
 
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
 
What is the listbox's RowSourceType property? What is the listbox's
RowSource property?
 
Back
Top