Output to excel file?

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Hi,

I want to output a table to a excel file and then delete the table,
but I need to use this DLookUp("export","photo_path") &
format(date(),"yyyy") & Forms![select_delete]![mm] &".xls"
to be the file path & name. I try to use a marco to run, but the file name
field cannot accept.
Is it I need to write code to do it, can anyone please help me!

Thank!!

Gary
 
I think you just forgot the = sign:

=DLookUp("export","photo_path") & Format(date(),"yyyy") &
Forms![select_delete]![mm] &".xls"
 
Thank Ken!!

Ken Snell said:
I think you just forgot the = sign:

=DLookUp("export","photo_path") & Format(date(),"yyyy") &
Forms![select_delete]![mm] &".xls"


--

Ken Snell
<MS ACCESS MVP>

Gary said:
Hi,

I want to output a table to a excel file and then delete the table,
but I need to use this DLookUp("export","photo_path") &
format(date(),"yyyy") & Forms![select_delete]![mm] &".xls"
to be the file path & name. I try to use a marco to run, but the file name
field cannot accept.
Is it I need to write code to do it, can anyone please help me!

Thank!!

Gary
Click to expand...
Click to expand...
 
Back
Top