Setting the File Name

K

Kerry Purdy

Hi

I have a query which pulls data from a table using date fields on a
switchboard(StartDate & EndDate). This data list is then exported to Excel
using a Macro. I would like the name of the file to include the start and
end dates entered in the switchboard/used by the query. Is this possible?

Many thanks

Kerry
 
K

Kerry Purdy

Excellent, thanx. It was the formatting causing the Error.

Have set it to

="G:\Admin Database\NameBadges Btwn " & Format([Forms]![Frm Main
SB]![StartDateEntry],"ddmmyy") & " and " & Format([Forms]![Frm Main
SB]![EndDateEntry],"ddmmyy") & ".xls"

it works perfectly, thanx

Kerry


Steve Schapel said:
Kerry,

Yes. Something like this?...
=[StartDate] & [EndDate] & ".xls"

--
Steve Schapel, Microsoft Access MVP

Kerry said:
Hi

I have a query which pulls data from a table using date fields on a
switchboard(StartDate & EndDate). This data list is then exported to Excel
using a Macro. I would like the name of the file to include the start and
end dates entered in the switchboard/used by the query. Is this possible?

Many thanks

Kerry
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

Grouping Names in Mail Merge 0
VBA - exporting serial letters to single documents 0
Adding data to MS Access from csv file 0
Automation of scanned file storage based on content 0
Merging from an Excel file with graphics 1
Change a great number of words in word files, with a macro as short as possible. 5
Some mail merge fields not pulling into document 2
Making a macro only work on certain files 2

Top