| Tip taken from chapter 0 in the book Mr Excel On Excel |
| Sidhartha Chakravarty New Delhi, India |
» Reading Data from another (source) workbook and using it to work on the current (target) workbookHi Everyone,I need help in retrieving some data from a different workbook (dynamically using VB codes) and then storing it in either a array (one-dimensional) or by populating a combo-box and then using this to work on my current workbook. To give you an example - WorkBook Roster - 1. TEAM LEADER - A AGENT - 1 AGENT - 2 AGENT - 3 2. TEAM LEADER - B AGENT - 4 AGENT - 5 AGENT - 6 Let's say the data mentioned above is placed in Excel Workbook "ROSTER" which is placed on a network server, that I have access to (thanks to my network administrator). When the user works on AUDIT.XLS (which should have the code to retrieve the data from ROSTER.XLS), all he should do to populate the agent and team leader cells would be to select the TEAM LEADER name from the combo box and then based on the selection made, the AGENT combo box would give him the appropriate agent names to choose from. For example - He chooses TEAM LEADER 2, then the AGENT combo box should only show options - AGENT 4, 5 and 6. I have another problem - I need help in using ASP with data from excel using VB. Though I know VB to a certain extent (though class modules still make me nervous), I have practically no knowledge about ASP. I have heard that ASP codes are similar to VB codes, but I don't know where to begin from and which software to use to do the kidding. The ideas is to come up with a Internet Explorer page that gives users the freedom to lookup / post / retrieve data from Excel. Regards, Sid |
Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation
Site Developed By: Irubin Consulting