Thanks Dana, unfortunately that's for manipulating the Excel file outside of Excel. What I'm trying to do would be an in-line process. I'm going to try thinking on this from a different perspective and see if building out a modal pop-up would do the trick as well.
Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. On Mon, Apr 1, 2013 at 12:17 PM, Dana <[email protected]> wrote: > > have you looked into powershell? I am not sure if this example is what you > want to do exactly, but maybe it will give you some things to look up. > > http://windowsitpro.com/blog/manipulating-excel-files-powershell > > > On Mon, Apr 1, 2013 at 8:42 AM, C. Hatton Humphrey <[email protected] > >wrote: > > > > > Knowing what to search for is sometimes the most challenging part of > > finding something! > > > > I'm working on an Excel spreadsheet that needs to "peek" into a SQL > > database to populate some cells. I've got the first two set, however now > > I'm looking at building out the Excel/SQL equivalent of a multi-selects > > related, per row. > > > > Here's what I'm trying to accomplish: > > 1. User keys a SSN > > 2. Excel pulls an employee ID, name and company code from the SQL > database. > > I have this working using VBA. > > 3. Excel populates a list for the user to select three different data > > points from (call them Location, Department and job title). These are > > stored in multiple tables in the database but I already have the query to > > pull them in. > > 4. Based on the Job title, Excel pulls a dollar amount from the SQL > > database to go into the next table. > > 5. Based on the department, Excel pulls a "participation" number (will be > > either a percentage or a dollar amount) to apply to the dollar amount > > pulled in #4. > > 6. A formula is applied to the numbers pulled in #4 and #5 to provide > some > > breakdown. > > > > I've gotten the connection working with VBA, know the query/queries I > need > > to write, the problem I'm having is figuring out what to search for to > have > > a dynamic named list per row that is dependent on values entered or > > selected in other cells. > > > > At this point I've searched for quite a few variances but haven't found > > anything similar to multi-select-related per Excel row. > > > > Any suggestions on how to word #3 so the search engine stops throwing me > to > > the wolves? > > > > Thanks! > > > > Until Later! > > C. Hatton Humphrey > > http://www.eastcoastconservative.com > > > > Every cloud does have a silver lining. Sometimes you just have to do > some > > smelting to find it. > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:362325 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
