B
bdmsfan
I use a macro to export my queries to MS Excel using the TransferSpreadsheet
funtion. I export one query per file. This happens every night. I would like
to report on the Excel file the time/date when it was updated. If I try to
use the Time and Date functions it will give me time and date when I opened
the file not when it was updated.
Any ideas? I'm using MS Access/Excel 2003
Thanks in advance
Bruno
funtion. I export one query per file. This happens every night. I would like
to report on the Excel file the time/date when it was updated. If I try to
use the Time and Date functions it will give me time and date when I opened
the file not when it was updated.
Any ideas? I'm using MS Access/Excel 2003
Thanks in advance
Bruno