Selesai

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

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

Keahlian: Excel, Visual Basic

Lihat lebih lanjut: how do i fix my, code code internet, excel update vba code, excel amibroker vba code, vba code run faster excel, import table excel sheets vba code, import excel access vba code, convert report excel access vba code, convert excel sheet vba code, vba code run external application, excel 2007 vba code

Tentang Pemberi kerja:
( 3 ulasan ) Al Ain, United Arab Emirates

ID Proyek: #9134935

Diberikan kepada:

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 dalam 1 hari
(2 Ulasan)
0.9

10 freelancer menawar dengan rata-rata $40 untuk pekerjaan ini

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 Lebih banyak

$100 USD dalam 2 hari
(27 Ulasan)
5.3
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 dalam 5 hari
(26 Ulasan)
4.6
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 dalam 1 hari
(46 Ulasan)
4.4
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 dalam 3 hari
(11 Ulasan)
3.3
jnekam

A proposal has not yet been provided

$15 USD dalam 1 hari
(8 Ulasan)
3.7
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 Lebih banyak

$25 USD dalam 3 hari
(12 Ulasan)
3.5
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 Lebih banyak

$111 USD dalam 1 hari
(2 Ulasan)
2.8
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 dalam 1 hari
(1 Ulasan)
0.4
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 dalam 1 hari
(0 Ulasan)
0.0