jeeva
10-15-2005, 02:10 AM
Dear all,
In one of the worksheets in a work book i've 4 columns which are UI objects of a screen listed with there types and comments. These objects are fixed for every screen. For one particular scenario say we have to go thru first 4 screens. So this work sheet will have the data from all the 4 screens in the flow order.
My problem is i need to write a macro for filling these columns with the data taken from another XLS (each screen in a indivdual tab). Please let me know how to go about this. Is it possible to write a macro to copy these contents to the xls worksheet which i need to generate. The selection of the screen driven by user input through checkboxes in a Screen Form.
If more information required i shall povide the same too to ur individual mail ids.. i dont find any attachment option in this page !:help
In one of the worksheets in a work book i've 4 columns which are UI objects of a screen listed with there types and comments. These objects are fixed for every screen. For one particular scenario say we have to go thru first 4 screens. So this work sheet will have the data from all the 4 screens in the flow order.
My problem is i need to write a macro for filling these columns with the data taken from another XLS (each screen in a indivdual tab). Please let me know how to go about this. Is it possible to write a macro to copy these contents to the xls worksheet which i need to generate. The selection of the screen driven by user input through checkboxes in a Screen Form.
If more information required i shall povide the same too to ur individual mail ids.. i dont find any attachment option in this page !:help