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.
****Added Saturday morning 3/15. Please see new details below.
The solution cannot be embedded in my existing excel file. It must be a separate excel , vba, file plugin or add on which continually monitors my excel document and 2 target fields k3 and m3. Your solution simply 'watches' my file and the fields. When a 1 is entered into the fields, it must create and save a text file with smal text string. It must do this automatically...no buttons or user dependent scripts. Some of you have suggested an external plugin/addon. that's fine. Remember I need the flexibility to point the monitoring software solution to any excel file.
36 freelancers are bidding on average $46 for this job
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.
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
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