notherand
07-22-2011, 04:42 AM
Hi guys!
I have hundred of raw data file (excel) which i have to create a report. However, i have to click first a specific field to get the data. I would like to ask how can i automate this. I saved my file in one folder.
what i need is.
-loop through a large number of files (all in one directory)
-double click specific cell (K10, same in all files)
-save file and close
i think this could be done in macro but im still newbie in excel macro. Any help would be appreciated! thanks!
*before the sheet that i need is display cell "K10" should be clicked. I dont know since i'm new in using excel. maybe it acts as a link. however, those are just the things that i need. loop,double click,save and close. :))
I have hundred of raw data file (excel) which i have to create a report. However, i have to click first a specific field to get the data. I would like to ask how can i automate this. I saved my file in one folder.
what i need is.
-loop through a large number of files (all in one directory)
-double click specific cell (K10, same in all files)
-save file and close
i think this could be done in macro but im still newbie in excel macro. Any help would be appreciated! thanks!
*before the sheet that i need is display cell "K10" should be clicked. I dont know since i'm new in using excel. maybe it acts as a link. however, those are just the things that i need. loop,double click,save and close. :))