View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maver1ck666 Maver1ck666 is offline
external usenet poster
 
Posts: 34
Default 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?