Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Gruuuu
  • Content: Threads
  • Order by date
  1. Gruuuu

    Combining a group of file into a single PDF (automation) (Acrobat 9)

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

    Lookup on different worksheet not working.

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

    Workbook.SaveAs Excel 2007 Unhelpful Error

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

    For Loop UDF

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

    MSDN Office VBA Development Center

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

    Having trouble with the Replace Method

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

    Parsing a string as arithmetic

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

    Refer to CurrentRegion in a UDF?

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

    Want to develop an executive dashboard...

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

    Excel files keeping print settings

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

    ComboBox OnChange resulting in Parameter Query popup

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

    Save a file from Download File dialog

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

    Excel 2007 Autofilter Misbehaving

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

    Excel VBA - Flow of control between routine and subroutine

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

Part and Inventory Search

Back
Top