on 11-28-2014 10:04 AM
Dear all,
I got a list of queries (technical names) and I should create 1 worksheet with 1 crosstab per query.
This should be done by VBA.
I've looked at the SAPSet* formulars and didn't find anything corresponding.
Any idea?
Kind regards
Michael
Hi Michael,
I don't think that this feature is available!
I just recorded a macro, but obviously there is no relation to any technical query Name 🙂
ActiveWorkbook.Names.Add Name:="SAPCrosstab1", RefersToR1C1:= _
"=Tabelle1!R4C1"
Selection.UnMerge
ActiveWorkbook.Names.Add Name:="SAPCrosstab1", RefersToR1C1:= _
"=Tabelle1!R4C1:R88C11"
Selection.UnMerge
Everything that comes with AO is for usage on an inserted query, but not to insert queries.
You probably have to do it manually.
Best regards,
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.