Recent content by WSC4ME

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

Ok. Can i make my form look like my query? All the data in one view? The forms I have used all are one entry per page. That is why I exported the query. its more like the table view I was looking for. Thoughts?

The worksheet is linked to an external data source that refreshes when the spreadsheet is ran. (auto-update is turned on in external data range properties) I was thinking about the clean closing of the spreadsheet too. I have two of the spreadsheet automated now in XP scheduler and I am using...

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?

I would like to add a hyperlink to each for of a report, specific to the webpage the data in each row is refering to. Can this be done?