Stop appending record in text file

[sanjuss2]

Ai I am using following code to create folder & text files on the basis of information in column "A"

but after creating file once if I run again same macro it is appending record by duplication of record.
I want to pass message that "File already exists" & don't want to append record

Please Login or Register  to view this content.

Thanks in advance

[AlphaFrog]

Please Login or Register  to view this content.

[sanjuss2]

It NOT works properly because macro creates only single record file for different nomenclature.
I want all records of respective numbers in single file viz.
008Outward26122018 ---- 1 record
013Outward26122018 ---- 3 records
009Outward26122018 ---- 2 records
While running code for every line of record it passing the message 'file already exists' & I have approx min. 3000 records in a single file so it is very much time consuming.
I need if there is file available the records must not be added twice i.e. duplicate record.
A single message i.e. file already exist for a single FILE.
as well as debug option coming for File Created Successfully msgbox.

[mohan.r1980]

Hi Sanju,

but after creating file once if I run again same macro it is appending record by duplication of record.
I want to pass message that "File already exists" & don't want to append record

I think you mean you dont want to append duplicate record in created file is'nt it?

I want all records of respective numbers in single file viz.

if yes then there is not existing created file issue, you need to check the record which you have to append is duplicate or not.

[mohan.r1980]

Hi Sanju,

See what i read your question

Please Login or Register  to view this content.

[AlphaFrog]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[sanjuss2]

Hi
I am hereby attaching sample file.
In column A there is text records & by using following code by which it creates files by using fName = Mid(Cells(r, "A"), 35, 3) of the same columns .
The code create 1 folder of date specified in C2.
The files created are added in same folder.
The files are containing those records which match the condition i.e. = Mid(Cells(r, "A"), 35, 3)
Means if 3 characters are matched records must be stored in that file only.
code create different files as per our requirement.

The following code works perfectly but If again run macro the file appended with duplicate record, so I want that if file already created then msg must be 'File already exist'
Else
Can we overwrite the above files if we again Run the macro without passing any message to avoid record duplication.

Alphafrog your code is checking every record & showing file already exist which is time consuming & thanks for the same.

Mohan_r1980 your code creates only single file for all records which is not useful for me but it is avoiding duplication is most perfect & thanks for the same.

Please Login or Register  to view this content.

[mohan.r1980]

Try Below Code

Please Login or Register  to view this content.

[sanjuss2]

Your code create folder then file after click on button twice.
There is not record in the file
No separate file create for the mid field i.e. 35,3

I want separate file of same number

[mohan.r1980]

show your dummy output

means
dummy text files which you want to create
data which you want to write in text file.

[sanjuss2]

Hi
Please find attachments of output of text files. which contains the records.
the files are stored in folder name 25122018

I have used following code

Please Login or Register  to view this content.

If I run again this macro then duplicate records will be added in file.... I want to stop that duplication

[sanjuss2]

Hi all,
I Can use 2 macros if available
1. for creation of file
2. for stop duplication

If anyone have such kindly suggest

[mohan.r1980]

Hi
try

Please Login or Register  to view this content.

this is for creation of files
wait for duplicate checking i am busy today, may be some one help

[sanjuss2]

hi mohan.r1980

Thanks for co-operation.

actually the code which I have already specified is also given the same result & I am seeking guidance on 'NO duplicate record should be added after creation of file'.

[Andy Pope]

The the arguments for the Open keyword.
https://docs.microsoft.com/en-gb/off...open-statement

In all the code examples you are using the Append method, which is what you say you don't want.
Try using Output rather than Append.

[mohan.r1980]

Hi Sanju,
try below script which is combination of both requirement

Please Login or Register  to view this content.

[sanjuss2]

So excellent....
Thanks very much

[mohan.r1980]

Your welcome and thanks for rep++