var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: export macro
Need to export a table to the c:\ drive.
However i would like it to be automated in a macro...
Is there a way to use a date function to give each export a unique identifier?
i.e [name of table] + Date()? or something?
I never use macros, but to do it in code it would be;
Obviously changing the path and format to the ones you want.
DoCmd.OutputTo acOutputTable, "tablename", acFormatXLS, "c:\" & Date & ".xls", False
Additionally you would need to change in the regional control panel the date seperator to - instead of /. This is because windows doesn't allow file names with /'s in them.