Help is requested. Excel VBA to generate, verify outline. 
Author Message
 Help is requested. Excel VBA to generate, verify outline.

This is vague, so I will jump right in.

One database needs to have some of the same dimensions of an outline
of different database.  We can not use the outlilne editor for
maintenance. We only use load rules for outline maitenance.

I plan on using a VBA Excel Macro, to help create a "generational
outline file" to load.   Grand Parent, Parent, Child, etc.
 As long as each line holds the complete generational path, this could
be loaded right? Even if it is not in top down order - - ?

I plan to start with all zero level members in the dimension, use a
macro to copy them to  sheet2, zoom out to get the parent, copy the
parent to  sheet2, zoom out on the parent .....etc  etc for each zero
level member.

Any thoughts or suggestions are welcome.
Anyone had to do this before?

thanks




Tue, 25 Sep 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Request: example of an ODBC connection to btrieve data from Excel VBA

2. Excel VBA In ActiveX Help

3. Please Help - VBA DAO in EXCEL 7.0

4. Please help - VBA DAO for Excel 7.0

5. Need Help Manipulating Excel 2000 from Access 2000 using VBA

6. Help with Shell command from VBA in Excel

7. Need Help with VBA reading Excel using ADO

8. help, help, Data-outline control!

9. AS serializes requests if MDX has VBA

10. Create a Dynamic generated SQL query in VB/VBA

11. REQUEST: P.O.S. Rental progrm am database

12. Controlling ADP from Excel with VBA


 
Powered by phpBB® Forum Software