Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Code Modification

Posted on 2014-12-19
18
Medium Priority
?
91 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
0
Comment
Question by:Naresh Patel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 11
  • 7
18 Comments
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40509451
I am doing this because need to combine 3 task together in one workbook & for this need to modify this code.

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40510532
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
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40510687
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
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 31

Expert Comment

by:gowflow
ID: 40510710
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
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40510764
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
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40510914
Didn't we do this question earlier ???
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40511051
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
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40514702
Mean while may I ask simple new question & post link over here?

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40517912
yes a bit slow as Christmas.
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40518200
Posting here in 5 min.
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40518205
Here it is "VBA Save Loction".

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40518366
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
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 40518397
ok I did not wait for your answer but figured out what you want. I did not do exactly like you requested but gave you rather a choice to either show trace or hide trace or show audit or suppress audit.

For this I created two checkboxes that you can toggle for trace and audit as per your request. I felt that maybe sometimes you want to test some files and need to see the outcome before you go in a 10000 files to discover after that this is not exactly what you want. When it comes to Data I am usually very cautious and conservative this is why I created the Audit and trace at the first place.

The destination folder has been set to be always
D:\AmiBroker Data\NSE\Eq
You will only need to set it ONCE when you run this version the first time ONLY. Press on the button locate the folder and that's it. ONLY once.

Please test it and let me know. Sorry for the delay.
gowflow
03-Formating-V01.xlsm
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40518570
Perfect - may I ask new question?
0
 
LVL 8

Author Closing Comment

by:Naresh Patel
ID: 40518574
As usual - No 1
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40518603
pls go ahead now
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40518612
5 min Sir. posting link over here.
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40518634
here it is Auto Download.



Thanks
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question