Output to excel file?

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
 
K

Ken Snell

I think you just forgot the = sign:

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

Gary

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
How to Write EXCEL files from a FORTRAN Program ? 0
Merging from an Excel file with graphics 1
Excel - Wich Function should I use? 1
Export Report with Graph to Excel error 2495 1
Sub projects added as read only in Master file which are saved on sharepoint 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Publisher is filling blank lines with data 2

Top