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:362324 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
