Fix a VBA code to run through multiple Excel files to do a specific action

Imekamilika Ilichapishwa Dec 16, 2015 Kulipwa wakati wa kujifungua

$10 USD

Kulipwa wakati wa kujifungua

Imekamilika Kulipwa wakati wa kujifungua

I need a vba code to do the following actions on multiple excel files in a specific directory:

1- when I run the code, a msgbox appears to select the directory where i have my excel files

2- then, I need the code to go through sheet2 in each file inside the directory and sub-directories to check if the date inside range1 is greater than 30/06/2015

3-if the date is greater than 30/06/2015, then clear this cell (not the row)

4-Go to range2 check if the date is greater than 30/06/2015, if true clear this cell

5- then, if the cells in range1 and range2 empty, make the corrosponding cell in range3 empty.

6- show msgbox of how many excel files were checked

I will need to do the same thing again, but the date would be 31/08/2015

I attached two files:

- the first is a sample of the excel files i will run the required code for.

the yellow shade area are the effected cells, column "N" represent range1, column "O" represent range2, and column "W" is range3.

if the date in cell "N11" and "O11" are greater than 30/06/2015, empty cell, otherwise keep information.

why i need this code? I need this to get the percentage of range 3 once before 30/06/2015 and another before 31/08/2015 and i will have to do the same things on multiple excel files.

-the second a code I downloaded from the internet to protect and unprotect multiple excel files and worked like a charm for me

Excel Visual Basic

Kitambulisho cha Mradi: #9134935

Kuhusu mradi

10 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

Imetuzwa kwa:

Picha ya Profaili ya kanwaljeetk56
kanwaljeetk56

I have seen the excel sheet you attached, basically you want to cleanup cells not meeting the criteria and based on that percentage cells will be cleaned up. I will give you a test run VBA

$13 USD kwa siku 1
(Maoni 2)
0.9

10 wafanyakazi huru wanazabuni wastani wa $40 kwa kazi hii

Picha ya Profaili ya boriscikotic
boriscikotic

Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: I Zaidi

$100 USD kwa siku 2
(Maoni 27)
5.3
Picha ya Profaili ya macroPOL
macroPOL

Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on projects.

$40 USD kwa siku 5
(Maoni 26)
4.6
Picha ya Profaili ya redouaneaberdin
redouaneaberdin

Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

$15 USD kwa siku 1
(Maoni 46)
4.4
Picha ya Profaili ya carlosperezit
carlosperezit

Hi I'm an expert in MS technologies (VBA, Excel, Net) The required vba code is very simple and can be deliverable in a few hours Regards Carlos

$30 USD kwa siku 3
(Maoni 11)
3.3
Picha ya Profaili ya jnekam
jnekam

A proposal has not yet been provided

$15 USD kwa siku 1
(Maoni 8)
3.7
Picha ya Profaili ya atifarzi
atifarzi

I have already done many similar tasks. Unfortunately it does take more than 1 day because of unforeseen circumstances like fine tuning the script. Honestly I am bidding an amount which I would take for 1 day, but I su Zaidi

$25 USD kwa siku 3
(Maoni 12)
3.5
Picha ya Profaili ya zu02
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc Zaidi

$111 USD kwa siku 1
(Maoni 2)
2.8
Picha ya Profaili ya panchosg
panchosg

I am Engineer and i know about VBA and excel. I development very codes of VBA in excel. For example matrix management.

$35 USD kwa siku 1
(Maoni 1)
0.4
Picha ya Profaili ya Avi12881
Avi12881

I will try to do it within short time as i am motivated person & can understand urgency as well as i can able to help you in attractiveness of the project

$15 USD kwa siku 1
(Maoni 0)
0.0
Tuma Mradi Kama huu