Search results for query: *

Long story short, I'm kicking off most of this code from VBA in Excel, but I'll get to that later. First: I'm having trouble with running the javascript, and it seems like it's a fairly simple syntax issue, but only time shall tell. The process goes something along the lines of this...

Ok I'm stumped here. The answer has to be something really stupid to evade me so well. I have a workbook that has several tabs with items across the top, and my stores down the left side. The data cells look up the item values (text) in a separate worksheet for each store. Folks at the stores...

I've recently upgraded to 2007, and for the most part, my VBA seems to work. This is one of the odd, rare occasions where this is not true: Workbook's purpose: serve as a "kickoff" processor (I give it a list of workbooks, it opens them in turn and runs the code saved in each one.) One of the...

Growing tired of crazy Excel calisthenics to display certain data, I decided to develop a For Loop UDF. It works ok, if yet a little clunky. Here's the code: Function FORLOOP( ByVal string_variable As String, ByVal start_value As Long, ByVal value_limit As Long, ByVal value_increment As...

I don't remember seeing this linked here in recent history. Forgive me if I missed it! http://msdn.microsoft.com/en-us/office/ff688774.aspx Contains a wealth of resources centered on 2007 2010 Office VBA development. Has a "Begin here" section, plus intermediate and expert techniques. The...

A while ago I was working on a way to parse a string as a formula, then calculate the answer. Well I'm still working on that, and I finally got it working. Here was my original thread http://tek-tips.com/viewthread.cfm?qid=1608956&page=3 My first thought was that I would take the string, and...

Here's the skinny: I'm creating a database tool in an excel book that can automate some queries against an external Database (Teradata, not that it matters). My basic setup is: I have a list of query files in the excel book. Each entry in the list is the name of a .sql file. Each query...

I'm working on a couple functions to use in a larger project. I want two distinct functions, one that returns an array, and one that lists those array values beneath the cell that contains the function. I have no problems with the first function, works exactly as intended. My problem is the...

I've been tossing the idea of a customizable dashboard around in my head for some time lately. I've done a bit of reading, and I'm sure I could do some more regarding concepts and practices. What I'm interested in now is figuring out what technology and software to use. The vitally important...

My department updates a slew of excel files which we occasionally print in large quantities. On a select few files, if the Active Printer is not changed, individual sheets will print out with the same printer settings that they were printed with last time, even if the default settings of the...

I have several comboboxes on a form, they each have a RowSource which is a simple query For example: SELECT DISTINCT Type FROM monsters; When I change the value of the combobox by selecting it from the list, it gives me a "Please Enter a Parameter Value" popup. Which is annoying. How do I...

I'm trying to save a csv file which is generated by a database query and accessed through a browser. There is not URL that I can use (or I would be done a long time ago). I'm using the MSHTML references to navigate through the forms and setting options before submitting. Once I submit, I get...

I've created a report for my management staff who have a mixed bag of Excel technical aptitude. In the workbook I have a few recap pages which show a number of our profit centers alongside several metrics. Simple stuff. I've added an autofilter on the metrics to help them identify problem areas...

Ok, I'm relatively newbish to VBA. Most of what I've learned has been from the Microsoft Help Files or from OzGrid, with a smattering from the Tek-Tips forums. The process I am trying to run should be automating macros in a dynamic list of files. I have a Range on the workbook from which I run...