Excel Script/ VBA Script

Cancelled

I currently have an excel file and i need some sort of 'watcher' which will run a script if a particular field in the excel file is populated. The script must create a text file and save it when field K3 or M3 = 1. The text file will contain one small line of text extracted from the same excel file.

So basically I have an excel file...

if field K3=1, run script which extracts text from field P3

if field M3=1, run script which extracts text from field Q3

Then write & save a .txt file to a target folder.

**Note: text string can reside in the same excel file in fields P3 & Q3 or if you write in VBA, we can place it there. I must have the flexibility to change the text string.

So, I am not sure if this can be done in Excel or VBA.

Skills: Excel, Visual Basic

See more: run vba script excel, vba file watcher, we excel, excel &, sort script excel vba, run script minutes excel, install xla vba excel, excel vba zvi, uses running vba script excel, excel vba automatically run script, run vba script cell excel, excel text file vba script, run program run script word excel vba, script run excel macro, excel vba run script, excel vba call script, running simple vba scripts escel, vba excel run script, run vba scripts excel, can vba script run outside excel, excel scripting text string, script install excel vba, vba excel script, excel save text file vba, start vba script excel

Project ID: #237490

36 freelancers are bidding on average $46 for this job

svet63

VBA developer since 1997. Yes, this can be done in VBA for Excel. Regards, Svet.

$45 USD in 1 day
(69 Reviews)
6.5
mywhitelotus

Please see PM

$100 USD in 2 days
(69 Reviews)
5.7
riyoyo

Use Excel plugin which will keep check the cell value continously. This plugin will also do the running script for storing the data to a file or so. Pretty easy, it needs a few minutes work only.

$125 USD in 0 days
(12 Reviews)
5.6
wsh2

Greetings Arkansas from the "Keystone State" of Pennsylvania.. {smile} Your thoughts are correct, this has to be done in VBA. Hello my name is Bill.. I am a MsExcel, VBA, MsAccess, VB.Net, VB6, VBScript, SQL, More

$49.95 USD in 1 day
(24 Reviews)
5.4
victory07

Please see PMB

$30 USD in 1 day
(13 Reviews)
4.6
KellogITSolution

Hello Plz check your PMB for my bid. Thanks John

$30 USD in 0 days
(15 Reviews)
4.4
VLADNOVA

Will be happy to help You, Sir. See PM for important details.

$30 USD in 1 day
(9 Reviews)
4.2
johnsinit

Dear MS Holdings! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$30 USD in 3 days
(16 Reviews)
4.2
crajeshbe

This can be done within a day. Please send your excel file, So i can give you a demo Regards C.Rajesh B.E

$30 USD in 0 days
(8 Reviews)
4.1
hiratariq

Please see PM

$40 USD in 1 day
(8 Reviews)
4.0
Icebear951

Hi, Please check your PM for futher details. Regards, Icebear.

$40 USD in 1 day
(6 Reviews)
3.1
cyberdeveloper

Hi, I'm a professional Excel programmer. I can do this job for you in less that one day.

$30 USD in 1 day
(9 Reviews)
2.6
itcslive

pls chk pmb

$30 USD in 1 day
(2 Reviews)
2.2
ashishyahoo

Dear Sir, I am ready to do this. Kindly see PMB. Ashish

$30 USD in 2 days
(2 Reviews)
2.0
ragavendram

Hi, I posses 5+yrs of experience, using VBA excel, access, word, vb.net , sharepoint. I can do this job. kindly ask me to know more about my qualifications and capabilities. - Ragi

$90 USD in 7 days
(0 Reviews)
0.0
nkarthick

I am VBA Developer, have extensive experience in VBA excel. I can do this project. Give me a Chance to accompolish the task.

$50 USD in 2 days
(0 Reviews)
0.0
Ishqh

Please check the PM

$40 USD in 1 day
(0 Reviews)
0.0
amiramahmoud

Dear Sir, i already did the job! (VBA in Excel) exactly as you requested, The paths and filenames will by dynamically set from another sheet in the Excel file. hope to here from you , thanks

$30 USD in 0 days
(0 Reviews)
0.0
RUFSOFT

Hi, I am ready to take your project. Thanks

$30 USD in 1 day
(0 Reviews)
0.0
vicooooor

This can be done using VBA. Pls see my PM.

$30 USD in 1 day
(0 Reviews)
0.0