Hello all,
I have five workbooks that I need open one after the other. They are all in one folder. They autorefresh external data upon opening, then a macro runs to push the data to another database, then they close. I need to write a script to open the first one, wait until it runs and...
Hello,
This likely is an easy one. I need to have a batch file to run a dozen or so excel spreasheets in a folder, one at a time. I need them to start up, refresh and then shut down, doing this one at a time until the last one. Can someone help me with this one?
Thanks...
I think this is an easy one but I can't seem to find out how to do it! I have a query I run off of some linked Excel spreadsheets. If the results of some cells are less then say, 100 or greater than 1000, I' d like the color of the text in the exported query to be red. Any idea how I can do this?
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.