Auto Click Automation

[mbcebrian]

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.

I recorded the macro and i got this code.

Sub autoCLICK()
    Range("K10").Select
    Selection.ShowDetail = True
End Sub

also, after it had clicked i like to to auto-save and then close the file. My pc is slow so i cant open hundreds of file simultaneously.

anyone have an idea about this?

 

[sijpie]

What you want to do, if I understand correctly, is to
- loop through a large number of files (all in one directory?), then
- select the value of a particular cell (the same cell in each file?),
- transport that value into your report sheet (one below the other?)
- lastly to save your report sheet.

Is this correct, and can you give some details on my questions?

With a macro this should be a fairly easy thing to do, even on a slow PC.

 

[mbcebrian]

What you want to do, if I understand correctly, is to
- loop through a large number of files (all in one directory?), then

Yes, exactly!

- select the value of a particular cell (the same cell in each file?),

it should double click to be exact. Yes same cell in each file. its cell "K10"

- transport that value into your report sheet (one below the other?)
- lastly to save your report sheet.

No need to transport. After it has double clicked, it should just save the file and then close it.

Thank you for the reply