I have tried a few modules and macro's but without a deep-seated knowledge of VBA I'm a little stuck.
All I need to do is to export my table data [GOODS IN] every evening (by pressing a command button).
This exports the table to a specified folder......
However I need it to auto name the exported file by date and time (at the point at which the command is started).
Many Thanks
Ellis