Export records into a text file based on criteria
I have an excel spreadsheet which imports data based on an MSQuery (refreshes
on open) which will provide a list of records.
What I want to do is this:
When a user updates a record, I would like Excel to export that complete
record into a central text file (comma delimited) on my network so we have a
log of what data was changed, time and who by.
Is this possible?
|