Thread: open for append
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default open for append

I don't believe there is any option that will support this. A possible work
around: You would need to write you date and then write data in the existing
file to the file with the date. Delete the original and rename the new one.

You could write the new date in a separate file, then use the "DOS" copy
command to append the two files.
--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
Hi,

I use follow code for append date in file "date.txt":

Open ThisWorkbook.Path & "\date.txt" For Append As #1
Print #1, Now
Close #1

VBA append each date in next below row.
How append date (now) always in the first row, that is
early date will be in follow rows.

Please me resolve this problem.

Kindly regards
Mark