VBA in Excel to search for a specific formula in multiple Excel files

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

I would prefer if you would be geographically located in Europe.

I need the VBA in Excel (Let's call our workbook '[login to view URL]') which will search for a specific formula used in multiple Excel files.

It should work close to the following:

1. Work under MS Excel 2010 in German language

2.1. Will search for .xls, .xlsx, .xlsm files in the (multiple) pathes specified on the 1st Spreadsheet (e.g. in A2 - C: drive, in A3 - D:\Working Files\Documents). Search in all sub-folders (till the deepest possible level).

2.2 Log in a newly created spreadsheet in [login to view URL] all found files and a path to them

3.1. Search within those files, within all existing spreadsheets (in the whole workbook), if the specific formula is used

Formula: sverweis(

Please be aware that this formula could be a part of other formula, e.g. =wenn(A1<>0;sverweis(.....);"example")

If such formula is found, the search in this file can be stopped, and the code has to proceed to searching the next file, and examining the next file.

The formula sverweis( should be defined on the 1st spreadsheet as well, so that we could replace it with any other formula (not hard coded in VBA code!).

3.2. Log in the 2nd newly created spreadsheet (in the same workbook [login to view URL]) and log all found files' names in one column and their path as a link (!) on the network in the second column

5. The ability to cancel the search while still preserving the found files.

While applying please state:

0. Your estimate of the speed (time) with which the search could perform.

1. If you are an individual or a company/team and what is your time zone

2. Provide a prototype - search in one specific file (name of the file is in cell A1, file in the same directory as the [login to view URL]) and confirm if the file contains in the formula the "sverweis(" formula as a result.

3. Place your bid and Inform about the expected delivery time

4. State you questions to the project

5. What's the difference (advantages/disadvantages) in the approach when searching in the files while opening it and without opening it (is it possible)?

Excel Visual Basic for Apps

Project ID: #14430648

About the project

19 proposals Remote project Active 6 years ago

Awarded to:

Darkzenon

i fist time here it will be my first job. i have alredy make for you seach in folder in VBA 2010 excel (en english) in is seach all files in folder you want. [login to view URL] Relevant Skills and Experience e More

€8 EUR in 3 days
(1 Review)
0.3

19 freelancers are bidding on average €47 for this job

ParisPallas

I've read your brief and can see that you'd like to have an Excel spreadsheet. Relevant Skills and Experience I have 7 years’ experience designing and developing Excel spreadsheets filled with formulas and VBA code. More

€55 EUR in 2 days
(523 Reviews)
8.5
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

€55 EUR in 1 day
(502 Reviews)
8.4
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.

€55 EUR in 1 day
(487 Reviews)
8.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Relevant Skills and Experi More

€55 EUR in 3 days
(325 Reviews)
7.4
axiomswb

we have expertise in this domain(web scraping , Excel VBA , data processing , data entry). Client satisfaction is our main motto for long term relationship. Relevant Skills and Experience web scraping , Excel VBA , More

€50 EUR in 1 day
(45 Reviews)
6.6
avinav606lx

Hey There, This should be done in couple of days. I work individually Without opening its not possible, The speed would depend on deep your drive is along with how heavy i your excel file. Thanks, Abhinav

€133 EUR in 2 days
(166 Reviews)
6.5
kevivu

Expert in VBA/VB/.NET, SQL, Adobe packages, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Relevant Skills a More

€44 EUR in 1 day
(85 Reviews)
6.1
osmemon

I have 7 years of experience in this field with 100% client satisfaction history. You can see my profile for past working and reviews before hiring me. Relevant Skills and Experience Excel, VBA, 7 years of Experience. More

€50 EUR in 1 day
(32 Reviews)
5.6
abhinovpankaj

Exp in VBA and Excel ,Working in industry for more than 6 years. Relevant Skills and Experience VBA Excel VSTO Proposed Milestones €35 EUR - VBA Excel

€35 EUR in 1 day
(48 Reviews)
5.4
teeares

I have written many macros in Excel. I can create macros to search directories to find specific files. I can also search for formulas in spreadsheets and strings. Now to some of the questions- I am an individual. I can More

€35 EUR in 2 days
(50 Reviews)
5.0
SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine, time zone is GMT +3 hours. I can finalise the job tomorrow, or during weekend as latest. The longest time is to open/close files in Excel. Relevant Skills a More

€50 EUR in 3 days
(9 Reviews)
4.4
ketas

A proposal has not yet been provided

€54 EUR in 1 day
(14 Reviews)
3.9
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo More

€55 EUR in 3 days
(10 Reviews)
3.3
Adminsuport

Hi, I am interested to your job.I am fully expert in Data entry,web research, Lead Generation, extracting email, data mining, Google, Bing, Yahoo, MS Office (Full), Relevant Skills and Experience I am waiting to be hi More

€35 EUR in 1 day
(1 Review)
1.7
krishantha972

Windows or web base software develop using C#, vb .net MS SQL Crystal report. Relevant Skills and Experience Windows or web base software develop using C#, vb .net MS SQL Crystal report. Proposed Milestones €35 EUR - More

€35 EUR in 1 day
(2 Reviews)
1.1