Regarding notepad

S

Shallo

Hi, I've got a Macro in VBA which reads/copies data from a particular
cell and then when i run this same macro's code in mainframe It over
writes the file rather than appending it. Plz can you suggest me if
there is any code which opens a particular file in append mode to add
new data to the existing one without deleting the previous.
 
N

NOPIK

there is any code which opens a particular file in append mode to add
new data to the existing one without deleting the previous.
Click to expand...

open "Name" for append as #
 

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

Adding data to MS Access from csv file 0
Macro to extract data from multiple Excel files 7
Calling Access 'form' from other applications 0
Appending to File 0
VB Automation of a Word 2002 Template 6
Download/Import from Tab Delimited - Formatting of Data 5
In XL VBA, Word Document SaveAs throws error 8
reading and replacing just the first line of a txt or csv file XL2 1

Top