adding textbox value to excel filename

[tommy_mo]

Is there a way to add the value of a textbox to an exported excel file? I've got a button that creates the excel file, but I can't seem to figure out the code that will add the textbox value. I've tried Me.listbox and (Me.listbox) to no avail. Anyone care to help??? Cheers. -Tom

strExcelDetail = Me.Listbox & "Light Log" & strDTSaved & ".xls"


DoCmd.OutputTo acQuery, strQueryName, "MicrosoftExcel(*.xls)", strExcelDetail, True, ""

 

[tommy_mo]

nevermind. I answered my own question for once