Rename excel file depending on access Table first field

[AbdullahGH]

Hi


By using VBA Access ,I want to copy excel file and rename it depending on Table first field.


For example, instead of using fixed name like:


FileCopy "Cocuments\Folder\CurrentFile.xlsx", "C:\Documents\Folder\NewFile.xlsx"


I want to use:
FileCopy "Cocuments\Folder\CurrentFile.xlsx", "C:\Documents\Folder\NewFile" & [Table1]![Feild1] & ".xlsx".



But it is not work. What is the correct code ?

[June7]

Can't pull data directly from table that way. If this code is behind a form that includes the Feild1 in its RecordSource, simply:

FileCopy "C:\Documents\Folder\CurrentFile.xlsx", "C:\Documents\Folder\NewFile" & Me![Feild1] & ".xlsx".

Is NewFile a folder? If so, need a \ following it. Or perhaps no longer need the text 'NewFile'.