Avatar of Naresh Patel
Naresh Patel
Flag for India asked on

Code Modification

Hi Experts,

I have Full code in attached WB & need to delete some task in code.
in WB I have 4 buttons.
1 which select the path for formatting .csv files
I need fixed hard coded path in Code it self i.e. D:\AmiBroker Data\NSE\Eq

2 Delete row button which trigger the formatting task for .csv files for that location.
I need - formatting only - but it also records trace and audit in separate sheets which is not required.

3 & 4 as above i.e. 2 applied 3 & 4 buttons and its code not required as there is no trace & audit data which it clear.

See this Link. I had got this code from this.

See attached .

Thanks
03-Formating.xlsm
Microsoft ExcelMicrosoft OfficeOffice Suites-Other

Avatar of undefined
Last Comment
Naresh Patel

8/22/2022 - Mon
Naresh Patel

ASKER
I am doing this because need to combine 3 task together in one workbook & for this need to modify this code.

Thanks
gowflow

WOW I read all the links back and didn't know you went thru all this trouble becoz of my latest code. I noticed that since 1 week I have word that keep trying to run setup each time I open word so must be this security that is messing all up.

I will look in the details of this issue.
gowflow
Naresh Patel

ASKER
In this question I want only process which delete the rows which doesn't have "Eq" & "BE". rest audit and trace not required. as in next question I need to combine 3 WB process to gather...which you participated in past questions i.e. Downloading Zip Files From Site, Unzipping Zip Files to .csvFormatting .csv Files.   all three process & question solved by you.

Thanks
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
gowflow

ok is everything gathered in the attached file 03-Formating.xlsm that you attached in this question ? and all explanation clear in this question ?? as hate to go back to links to understand requirement.

If it is not clear pls draft something clear so I can work on it. I did not look at the file nor looked at the requirement yet only looked at the link you posted first that got me to the problem of the December update and the button being inaccessible.

gowflow
Naresh Patel

ASKER
Sir.Gowflow.

Got your point....for this question I need code which delete rows form WB(.csv files). criteria is column B have values other then "EQ" or "BE" then delete that rows but except header.no need to have record of deleted data or trace .just simply delete that rows. "EQ" & "BE" condition hard coded in code it self not any ware in work sheet. if any .csv file dosent have "EQ" or "BE" in column B then by pass that csv and jump to next csv file. my .csv files location is "D:\AmiBroker Data\NSE\Eq", this location is also hard coded in code it self.

attached is two file attached 1 is "before" & other is "after"

Thanks
Before.csv
After.csv
gowflow

Didn't we do this question earlier ???
gowflow
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Naresh Patel

ASKER
Yes.....but for combining other 2 codes ....Need to remove auditing and tracing part in this code. If I run this code on 500 .csv files my WB loded with plenty of data. So need to remove these things only stick to only deleting part.

Thanks
Naresh Patel

ASKER
Mean while may I ask simple new question & post link over here?

Thanks
gowflow

yes a bit slow as Christmas.
gowflow
Your help has saved me hundreds of hours of internet surfing.
fblack61
Naresh Patel

ASKER
Posting here in 5 min.
Naresh Patel

ASKER
Here it is "VBA Save Loction".

Thanks
gowflow

When you say

2 Delete row button which trigger the formatting task for .csv files for that location.
 I need - formatting only - but it also records trace and audit in separate sheets which is not required.

You mean you only want to delete the unnecessary rows but
DO NOT WANT Trace and
DO NOT WANT Audit ??

what is the next para ?

3 & 4 as above i.e. 2 applied 3 & 4 buttons and its code not required as there is no trace & audit data which it clear.

What do you mean by 3 & 4 ??

gowflow
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
gowflow

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Naresh Patel

ASKER
Perfect - may I ask new question?
Naresh Patel

ASKER
As usual - No 1
gowflow

pls go ahead now
gowflow
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Naresh Patel

ASKER
5 min Sir. posting link over here.
Naresh Patel

ASKER
here it is Auto Download.



Thanks