We help IT Professionals succeed at work.

Code Modification

178 Views
Last Modified: 2014-12-26
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
Comment
Watch Question

Naresh PatelFinancial Adviser

Author

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

Thanks
gowflowPartner
CERTIFIED EXPERT

Commented:
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 PatelFinancial Adviser

Author

Commented:
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
gowflowPartner
CERTIFIED EXPERT

Commented:
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 PatelFinancial Adviser

Author

Commented:
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
gowflowPartner
CERTIFIED EXPERT

Commented:
Didn't we do this question earlier ???
gowflow
Naresh PatelFinancial Adviser

Author

Commented:
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 PatelFinancial Adviser

Author

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

Thanks
gowflowPartner
CERTIFIED EXPERT

Commented:
yes a bit slow as Christmas.
gowflow
Naresh PatelFinancial Adviser

Author

Commented:
Posting here in 5 min.
Naresh PatelFinancial Adviser

Author

Commented:
Here it is "VBA Save Loction".

Thanks
gowflowPartner
CERTIFIED EXPERT

Commented:
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
Partner
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Naresh PatelFinancial Adviser

Author

Commented:
Perfect - may I ask new question?
Naresh PatelFinancial Adviser

Author

Commented:
As usual - No 1
gowflowPartner
CERTIFIED EXPERT

Commented:
pls go ahead now
gowflow
Naresh PatelFinancial Adviser

Author

Commented:
5 min Sir. posting link over here.
Naresh PatelFinancial Adviser

Author

Commented:
here it is Auto Download.



Thanks

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.