Renaming .xlsx File in Folder Location using Variable

[A12help]

Windows 7, Access 2010 32-bit

I have exported a file to the following path and name:
h:\main\test\todaysdatafile_currdata.xlsx

Once exported, I am trying to rename it as follows (using the NAME command):
h:\main\test\mapfile_mmddyy.xlsx where the mmddyy reads a control field on the form that is equivalent to the current date in the mmddyy format.

I get everything in my results but the mmddyy variable.

Any suggestions?

Kindest regards,
A12help

[zmbd]

A12... as in your other post... we need to see your code.
Please format it using the <CODE/> button once posted.

[A12help]

DoCmd.RunSavedImportExport "Exp_SF Map File"
Name "h:\main\test\todaysdatafile_currdata.xlsx" As "h:\main\test\mapfile_mmddyy_" & ctlFileDt & ".xlsx"

[NeoPa]

Try :

Name "h:\main\test\todaysdatafile_currdata.xlsx" As _
     "mapfile_" & Format(Date(), "mmddyy") & ".xlsx"

Todays date is always available from the Date() function but it should be formatted explicitly if you want to be sure of it coming out in the right way.

[A12help]

NeoPa,

Thanks so much; I knew it would be something simple.

When I created the ctlFileDt field on the form, I did all of the date formatting there thinking the code could just read that field. I did not think about dumping the formatting piece directly into the code. I tried and this works great.

Sincerely appreciate the help.

[NeoPa]

Not a problem. It's good to be able to help :-)