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!
Hello mbcebrian,
This can be done. I am curious as to why the cell "K10" must be double clicked? Is there a Worksheet_BeforeDoubleClick() event macro that must be triggered to calculate a result in the cell?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Lieth,
before the sheet that i need is displayed. Cell "K10" should be clicked. I dont know since im not that familiar with excel yet. maybe it acts as link im pretty sure it's not a macro.
Last edited by mbcebrian; 07-19-2011 at 11:51 PM.
i don't know if bumping is allowed here.
i still hope someone can help me with this? I still need this macro.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks