open for append

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

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
 
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.
 
Hi Tom!
Mayby this action can do on excel file eg. date.xls
Is there an easy code?
Supportive question: Can work (write, read) on files *.xls
without open it.

Best Regards
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Worksheet name to each begining of each row with values 2
Compare data set 1 with data set 2. Add to data set 2 if not found 0
save(append) to an excel file 2
How to append data from different sheet and different workbook? 2
append multiple worksheets data into a single multi-dimensional array 4
Sort on 3 columns when number of rows vary daily 1
Help pLease... Creating a Usage Log 2
adding/appending comment by code 3

Back
Top