Hello Everybody,
I am running a code which takes a couple of minutes to compute and I would like the user to see what is going on. I want to avoid to put a process bar as I know it will slow the code even more.
I have put an application.StatusBar with one of the loop but the form is...
Hello all,
I am trying to automate excel to open n number of file into a directory.
The target is to open all the *.txt file which are in a directory, then grab a couple of values and copy them into an output *.xls file then open the next *.txt file and son on.
The following sub does the job...
Hi,
I am trying to automate the opening of 1000 of excel spreadsheet. Each spreadsheet say is named as 120500,120501..120599
The aim is to open each of these file in a loop and pick some of the values in each of the spreadsheet.
Then after the file is open and the data extracted the file as to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.