Excel Automation - timer?

[brains28]

Hi,

I have a file that I update daily. It involves opening the file, going to a drop down menu and selecting 1 of the listed items and pressing a button to run the macro. Once the macro is complete, I then go back to the dropdown menu and select the next line item and press the same button to run the macro on this. I repeat this task 7times.

All the macro does is load a txt file to a third party system.

I am looking to see if it is possible to reduce the time it takes to do this task.

Your help is as always invaluable!

[teshiburu1988]

Upload an example sheet and i will take a look,

Teshi...

[brains28]

Here is the file.

Thanks...

[teshiburu1988]

I have created a new button for you that updates your drop down list value to the next one in the list using the list

i copied your list into view in F9 onwards

when you click the button it should change the value in F6 run your parser then change the value again and so on - this can even be put in a workbook open event

Teshi

[teshiburu1988]

oops forgot to add the final parser command to the command button macro

[brains28]

Sorry Teshi,

Could you post the final file?

Thanks
Brains

[teshiburu1988]

here you go - have even written the code into one version to allow it to run on open - you may need to change your file name back

but if you use that one all you will need to do is open the file every time and clear the success messages

any more help just ask


Teshi...

[brains28]

Hi Teshi,

When I press your button I get an error message.

"Compile Error - Expected variable or procedure, not module"

Not sure what the problem is, It bugs out on the first row of the below code with the above error


Private Sub CommandButton1_Click()
Worksheets("Sheet1").Range("F6").Value = Worksheets("Sheet1").Range("F9")
Parser

[teshiburu1988]

ok - the issue there is that your Praser module shares the same name as the function - if you rename your module to something else maybe even "ParserModule" it should work fine

[brains28]

Teshi, thanks so much. Really appreciate it.

[teshiburu1988]

S'ok also if you want you can move your completion message from your ParserModule and put it at the end of the code i wrote for you

Please dont forget to mark post resolved and if i have helped click on the little blue scales to improve my reputation lol

thanks again

teshi