PDA

View Full Version : Automate Click, Save Close



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

Kenneth Hobs
07-22-2011, 05:42 AM
What is the purpose of double clicking? By doing so, you put the cell in edit mode typically. Automating that is not what one would typically want as it requires a user action for each before it can proceed.

A single click is easily done. Of course we would need to know the sheet name or sheet number to select the correct K10.

Some programmers run code by a Selection event for a cell on a specific sheet. To activate such a macro, one needs to select some other cell as on open, that cell may already be selected. That would happen in your case as you saved the file after "doubleclicking".

notherand
07-22-2011, 06:21 AM
hi kenneth, thanks for the reply.

Let's put that the sheet name is "TABLE". I need the double click cell "K10" in sheet Table to display another sheet named sheet 1. I dont know if its activated by macro or its just a link. however, i tried to record macro and here's what i got.
Sub autoCLICK()
Range("K10").Select
Selection.ShowDetail = True
End Sub

i would like to upload the file but i can't cause it contains confidential data from our company.

notherand
07-25-2011, 06:11 PM
anyone? :dunno

Kenneth Hobs
07-25-2011, 07:16 PM
You should understand your code if you are to manage it. If you right click the sheet's tab, select View Code. You should see something like:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

End Sub
Between the Sub lines is what we should look at.