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.
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.
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
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